The DBA Plate rz
The DBA Plate for 2016

Four years ago I wrote about the DBA Plate, which was a reference to the food plate that replaced the food pyramid right about the time the U.S. Congress declared pizza to be a vegetable. I had every intention of keeping the plate updated annually but never got around to...

The view from my office during the keynote.
Notes From the PASS Summit Keynote

Well, here we are, another PASS Summit behind us. Each Summit is special to me, in different ways. It's like having children; you love each of them but for different reasons and in different ways....

Help Keep PASS Summit Awesome for Everyone

Earlier this week I saw this post from Chris Webb (blog | @technitrain) regarding a session he is delivering at the upcoming PASS Summit. When I read the abstract there was one section that jumped out at me (emphasis mine): If you’ve been to PASS Summit before, you know that social media...

HOW TO: Improve Database Performance Without Changing Code

I’ve stated before that great database performance starts with great database design. So, if you want a great database design you must find someone with great database experience. But where does a person get such experience?We already know that great judgment comes from great experience, and great experience comes from...

Lost Data

DBAs get paid for performance but we keep our jobs with recovery.Being able to recover data is the most important job function you have as a DBA.  If you can't recover your data because database backups are missing, or corrupt, then you should consider a new line of work.The year is...

how to recreate sql server statistics in a different environment
HOW TO: Recreate SQL Server Statistics In a Different Environment

Did you know table and index statistics are the most important piece of metadata for your database?The reason for this has to do with how SQL Server (and other database engines) build query execution plans. The query optimizer builds an execution plan based upon the statistical data available at the...