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...


As I mentioned yesterday, during the PASS Summit keynote I held up a placard that said #SQLFamily on one side and 'Hug Me' on the other. I suddenly realized that this was creating a hug bottleneck of sorts because (1) there is only one sign (and it's mine, don't bother asking)...

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....

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...

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...