Alright so I see that this is an on going problem with the SD cards not staying connected to the Surface.
I refuse to believe that this is a hardware issue. I say that because when the SD card does disappear, if I go to disk management I can still see the card albeit no info is available for it.
Also when the card disappears, when I eject it Windows makes a noise letting me know something was disconnected/removed. If the card somehow wasn't making good contact it wouldn't be showing up in Windows at all. It would either show up or it wouldn't.
The Micro SD card is a SanDisk 128GB. I heard some people tried to put electrical tape on the card to make the contacts press together but it didn't do the trick for me. This is obviously a software problem.