In my seven years as a production DBA I can count on one hand the number of times I have needed to restore the master database as a result of a disaster. With over 180 instances of SQL Server in our care I believe that is a large enough sample size making it safe to … Read more
Many novice administrators make the common mistake of believing that the SQL Server upgrade process for a database server is as easy as pressing a few buttons.
We’ve all had those moments. It’s late in the day. You are about to head home a few minutes early so you can bring your daughter to soccer practice on time. Your phone rings. The voice on the other end of the line mutters something about the server “being slow”, and needs you to fix … Read more
There is no question in my mind right now that the SQL Server 2012 book I am most looking forward to having on my bookshelf is the Professional SQL Server 2012 Internals and Troubleshooting by Christian Bolton (blog | @christianbolton) et al. I enjoyed Christians first book (Professional SQL Server 2008 Internals and Troubleshooting) as well, and … Read more
What if you threw a house party and nobody came? You’d feel pretty sad, I’m sure. OK, what if you threw a house party for 20 people except those 20 people told all their friends about the party and 45 people showed up causing your neighbors to call the cops and shut the party down … Read more
Looking for a good book on SQL 2012? Only a handful are available right now, you can see a list of books available for pre-order over at Amazon. No, you won’t find my name as an author to any of them. I’ve been asked to write a chapter or two a few times but nothing … Read more
