On my MacBook Air Bootcamp the SD card slot disappears on a Sleep/Wakeup cycle.
Curiously though, a USB Flash drive does not show this problem. I can put a 32gb USB stick in one of the USB ports, go through a sleep/wakeup cycle and it is still present. Obviously the SD card slot is treated quite differently from the USB ports...
Apparently nobody at Microsoft uses a Mac with Bootcamp for testing or even personal use. Else they would have fixed this problem years ago. Although I fault Apple for not pursuing a solution with Microsoft more vigorously, it would appear to me that it is a Microsoft driver issue. The Bootcamp SD card slot shows to use a Microsoft driver dated 6/21/2006. I just got through updating the Bootcamp drivers - so this driver version appears to be quite static in recent Bootcamp releases. Either Apple needs to develop their own Bootcamp driver for this SD card slot OR Microsoft needs to lend a hand to fix this nagging issue. As a systems analyst/programmer for some 40 years I cannot fathom this being a tough nut to crack if one had access to the right tools.
But don't hold your breath. There are hundreds (if not thousands) of posts all around the internet discussing this issue for over 3 years - and so far I have yet to find anyone with a true solution. The problem has been documented to Microsoft AND to Apple - yet they appear to close (or ignore) the issue without ever bothering to fix it.
MAYBE, just maybe, someone from Microsoft or Apple will see this discussion and actually take ownership of the task of getting a remedy to us. Who knows? Maybe pigs will soon fly too!