View index usage statistics that show you how often the indexes in the database are used, and whether they’re used for writing or...

This Monday, at SQLSaturday Israel, I presented my new session, “The Data Loading Performance Presentation”. I worked on the session a...

Last week, Boris Hristov (b|t), the organizer of #SQLHangout, invited William Durkin (b|t) and me to a SQL Hangout about transitioning...

I have been working with SQL Server for the past 17 years, and in the past few years I have been also very involved in the SQL Server...

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