SQL102

This past Saturday was World Backup Day, It’s not an actual government recognized holiday, but as a DBA you should start celebrating it.  Maybe celebrate isn’t the right word for what you might want to do on WBD.  If you have a copy of the  SQL PASS Summit 2011 DVDs, check out Grant Fritchey’s Lightning…

Read More World Backup Day

I’ve worked with hundreds databases in my career.  I could probably design a handful of them from memory if asked.  I have notes to remind me of lessons learned from most of them.  When I start looking through that list one of the things I most often reference is the importance of Foreign keys.  Why…

Read More Foreign Keys and Witchcraft