I haven’t seen a BSOD on a machine without faulty memory in over a decade.
Lucky you. Device driver bugs or collisions can still cause a BSOD just fine. I got one on one of my machines about a month ago when updating a driver; first BSOD in probably two years. The good news was that a pair of reboots straightened it out without need for any further diagnosis.
One thing I will say is that Win7 has proven very robust about fixing itself after issues like that. It's a pleasure.