2015 is here! Last year I wrote about what I had learned in 2013, and I try to make it a tradition. So without further ado, here’s what I...

Last week I had the honor to present a seminar at Expert Days 2014, which is an annual conference for developers organized by E4D...

I’m on my way to give a presentation at the PASS Database Administration Virtual Chapter about SQL Server bugs. All the materials from my...

This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan caching...

In just a little while, I’m going to give a presentation at the PASS Performance Virtual Chapter. You can download the materials from my...

If your database needs a complete index overhaul, you can do it automatically. This useful script rebuilds or reorganizes indexes...

When you set up a multi-subnet cluster, whether it’s a Failover Cluster Instance or an Availability Group, you need to make sure you...

Five years ago the term “cloud” was still a buzzword, and there was a lot of uncertainty and misconception around it. I remember many...

This query stats script returns aggregated statistics information for every query statement in the cached plan. Use it to get details on...

The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “1” not found /] Course...