First Responder Kit

Celebrating Two Years of sp_Blitz® (And a New Version)

Last Updated February 13, 2017

#SQLPass, First Responder Kit, SQL Server

Two years ago this week, I took to the stage at the PASS Summit 2011 and unveiled sp_Blitz®, my free health check stored procedure that helps you rapidly take over SQL Servers you’ve never seen before. Some historical highlights include: 117,125 downloads 117 checks (technically much more than that, because we look for variations of…

How to Find ‘Secret Columns’ in Nonclustered Indexes

Last Updated November 16, 2017

Kendra Little

Indexing, sp_BlitzIndex

sp_BlitzIndex® just can’t keep a secret. That’s a feature, not a bug. I wrote sp_BlitzIndex® specifically so that it would rat out some things that SQL Server is doing behind the scenes to secretly help you out– because it’s really better if you know about it. What are secret columns? SQL Server needs a unique…

sp_BlitzIndex® Holiday Week Edition

Last Updated February 13, 2017

Kendra Little

First Responder Kit, SQL Server

Only one thing could have dragged me away from the soft glow of the electric leg lamp glowing in the window… sp_BlitzIndex® It’s one of those weeks when things get nice and slow. Your business users and managers are all out of the office due to holidays. Your inbox is blissfully quiet. You get a…

Instant Index Insight: How to Use sp_BlitzIndex® (video)

Last Updated February 13, 2017

Kendra Little

First Responder Kit, Videos

You probably don’t have enough time to dig through DMVs trying to figure out which indexes you should add or drop. Whether you’re a DBA or developer, junior or senior, you’re probably too busy doing your real job to master all the index best practices – and now you don’t have to. In this 30…

First Responder Kit

Celebrating Two Years of sp_Blitz® (And a New Version)

How to Find ‘Secret Columns’ in Nonclustered Indexes

sp_BlitzIndex® Holiday Week Edition

Instant Index Insight: How to Use sp_BlitzIndex® (video)

Save your cart?