It used to be "won't use larger than 2GB". Right now it's around 8, but will likely become 16 in a couple of years.
As for video, it's also common to stream to an external recorder from the DSLR etc.
Are they, though? Because I use SD cards for photography and have for quite a few years and I take them not only to yards and beaches, but mountain peaks, spelunking in mud caves out in the desert, etc, and I have never had an SD card break on me either physically or in terms of data loss.
To be fair, though, for photos only (no video) even with high-res uncompressed RAW photos I can't imagine anyone practically needing SD cards anywhere near the 512 GB size. That's a lot of photos...
YMMV, I guess, maybe I'm totally lucky, but I have yet to personally have an incident which makes me worry about the robustness of decent quality SD cards.
http://www.amazon.com/EZOPower-Portable-Wireless-External-Sm...
I mean it does cost $35, but it's pretty much exactly a magic remote backup machine (that can also charge your gear!). Or you can spend more cash and get one with an integrated hard drive and need no other devices.
There are a lot of photographers who won't use SDs larger than 8GB for just that reason--lose one, you don't lose everything.