Category: First Responder Kit Updates

We have quarantined all of the bugs. Many of the bugs. Okay, 7 of the bugs. Hey, we actually added more improvements than we fixed bugs this month! My favorite new things are that sp_BlitzIndex @Mode = 2 now makes it even easier to do disconnected index tuning just purely inside a spreadsheet, and sp_BlitzCache runs faster on big servers.

In the immortal words of "Orange" Julius Caesar as written by Shake's peer, "Beware the bugs of March." It took us 2,064 years, but we've finally fixed those bugs, plus added a couple of new features.

To get the new version:

We spent Valentine's Day removing the bugs from your chocolates. You're welcome.

To get the new version:

My newest class, How I Use the First Responder Kit, has been going great - but there's a catch. I designed this class as a mix of training and consulting, so I'm giving you advice on your server as we go.

Because of that, I can only fit so many people (around 50) per class.

A couple of times a year, I disconnect from the Internet to sit down with a planning book, my Epic Life Quest, and my future task list. I spend time making sure my day-to-day tasks are still prioritized right. When I do that, I often find out that I've lost focus on a particular task, or I've been spending too much time on something. We only get so many hours in a day, and I gotta figure out where I can be the most effective.

It's the hap-happiest season of all. To get the new version:

Download the updated FirstResponderKit.zip
Azure Data Studio users with the First Responder Kit extension:
ctrl/command+shift+p, First Responder Kit: Import.
Download the updated Consultant Toolkit in your account

This is a pretty doggone big release. There are a lot of improvements to sp_BlitzFirst, sp_BlitzCache, and sp_BlitzWho to prepare for a new release of the First Responder Kit Power BI Dashboard. If you're using that today, I would strongly recommend updating to this new version of the FRK scripts - they fix a ton of bugs and start collecting data in a way that will make joins easier.

This month's release has a lot of new feature goodness: the Consultant Toolkit can automatically upload the results to Amazon S3, plus sp_BlitzCache adds a new sort order to better catch unparameterized queries burning up CPU, a new warning for selects that are doing writes (other than >500MB spills, which we've been warning you about for years), and support for SQL Server 2019's air_quote_actual plans.

Nothing too dramatic, mostly bug fixes this month. Been pretty quiet on the development front the last couple of months. Some stability is nice around here, eh?

To get the new version:

This month, lots of improvements and bug fixes, including checking for paused resumable index operations, Evaluation Edition expiration dates, sp_BlitzCache shows the number of duplicated plans for each query, sp_BlitzIndex will skip a list of databases for you, and more.

To get the new version:

This month, just half a dozen bug fixes, plus a new parameter for sp_BlitzCache to search the plan cache for specific strings. To get the new version:

Download the updated FirstResponderKit.zip
Azure Data Studio users with the First Responder Kit extension:
ctrl/command+shift+p, First Responder Kit: Import.
Download the updated Consultant Toolkit in your account

I hereby christen this the Rich Benner Memorial Release. He's still alive, it's just that we'll always remember him for the work he put into this month's version. (I'm kidding, of course. We won't remember him. (I'm kidding. Rich will appreciate the humor in that.))

You can download the updated FirstResponderKit.zip here, and Consultant Toolkit customers can grab their updated version in their My Accounts page. EU customers - check your email for the updated version.
Across-the-Board Changes

I have a sneaking suspicion that a bunch of you made New Year's Resolutions to contribute to open source, because y'all got started with a bang this year. We've even got improvements from Microsoft folks for Azure Managed Instances!

You can download the updated FirstResponderKit.zip here.
sp_Blitz Changes

Does anyone know what the date really is?

I usually don't, and I often consider how doomed humanity would be if I were the smartest person on the planet during any given era.

I dunno, I just like this picture. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1786 - @dallyhorton made a good point: if we're gonna warn you about Change Tracking, we should tell you which database it's enabled for. #1791 - Who do DMV queries think they are, blocking each other? Get over yourselves. #1793 - CheckIds shouldn't be twins,…

This is a small release just to make sure you don't forget about us.

We know you're busy.

I know, it seems like just yesterday I was doing one of these releases.

But no, it was three weeks ago.

You think I'm kidding.

Time bomb.