If there was ever a release you should skip for reliability reasons, it's this one. There's a lot of AI-edited code in here. I'm really only putting it out there because I want to let early adopters start playing around with a few new things: sp_BlitzIndex adds an @AI parameter to get index consolidation advice…
For the last few years, I've slowed the First Responder Kit release down to once per quarter. It felt pretty feature-complete, and I didn't want to make y'all upgrade any more than you have to. You're busy, and I don't want to take up your time unless there's something really big to gain from doing an upgrade.
Two big sets of news this month! The Consultant Toolkit now supports imports to a database so you can track your clients' health and performance over time, and sp_BlitzCache has a new @AI parameter.
Set @AI = 2, and get a prompt you can copy/paste into the AI of your choice to help you tune the query.
Set @AI = 1, and we'll actually call ChatGPT or Google Gemini for you and return the advice.
First off, I understand if you read the headline and you have a knee-jerk reaction. I totally understand that there are a lot of people out there who hate AI, and believe me, I hate most uses of it. Lots of its advice can be misleading at best, and absolute garbage at worst. However, if…
This quarter's release includes new checks for SQL Server 2025's new memory pressure warnings, Azure SQL DB's operations in progress, accurate CPU usage on Docker containers, warnings about not using partitioned statistics where appropriate, and much more. If you'd like to thank me for my work in maintaining the First Responder Kit, the best way…
This quarter's release includes new checks for SQL Server 2025's new memory pressure warnings, Azure SQL DB's operations in progress, warnings about not using partitioned statistics where appropriate, plus bug fixes.
To get the new version:
I'mma wax philosophical for a second: I love the open source nature of the First Responder Kit because it lets anybody, anywhere, diagnose database problems faster. If you're a full time employee somewhere today, you owe it to yourself to use the FRK scripts because if you ever switch from one company to another, your…
This quarter's release contains a few advanced warnings & tools, like table input for sp_BlitzLock, new warnings about paused resumable index operations that will be deleted automatically by SQL Server 2022, and a new option to maintain carriage returns and line feeds in sp_BlitzCache's output.
To get the new version:
If there was ever a release you could skip, this is probably the one, because you could count this release's changes on just one hand! Well, assuming you were an alien with six fingers. I won't even recap the most important changes - you can just scroll down and read 'em.
To get the new version:
The wording of all of sp_BlitzIndex's warnings is now much more clear and inclusive thanks to hard work by W. Eli Hayes and VladDBA. When Kendra Little first wrote sp_BlitzIndex about a decade ago to help you analyze your index designs, we brainstormed about how to surface warnings. Index design is not black and white:…
The next release would normally be August, but I'm doing a release a little early in order to fix 2 issues with the Consultant Toolkit. The May release broke the ability to automatically upload results to Amazon S3, and didn't include all of sp_BlitzLock's results. Those are now fixed, so I wanted to get another release out quickly so consultants don't have to keep using the old version.
If you've hard-coded installer file names, there's a big change in this release. There are now just 2 installer scripts: Install-All-Scripts.sql, and a new Install-Azure.sql, which only installs the scripts that are compatible with Azure SQL DB. The old Install-Core scripts are gone because we've deprecated sp_AllNightLog, sp_BlitzInMemoryOLTP, and sp_BlitzQueryStore. Read on for why.
New this month: better sp_BlitzIndex performance on databases with tens of thousands of objects, sp_DatabaseRestore can run test scripts, and David Wiseman and Sean Killeen implemented basic automated testing for the First Responder Kit.
To get the new version:
New this month: more work on letting sp_Blitz run with limited permissions, nicer Markdown output, sp_BlitzLock compatibility with Managed Instances, and more.
To get the new version:
The last couple of releases have focused on running sp_Blitz with limited permissions, like not being able to see inside some user databases. Those efforts continue this month with a lot of work from Montro1981.
To get the new version:
Turns out y'all actually work over the summer - there are actually cool new features this month! I think I'm actually going to have to record updated sp_BlitzIndex, sp_BlitzLock, and sp_BlitzQueryStore modules for my "How I Use the First Responder Kit" class because these features are pretty awesome.
To get the new version:
This one's a pretty quiet release: just bug fixes in sp_Blitz, sp_BlitzLock, and sp_DatabaseRestore.
To get the new version:
This month's big changes are performance tuning in sp_BlitzFirst & sp_BlitzLock. Part of the benefits of using the open source FRK is that when any of us work with *really* big/fast/ugly servers, we tune the FRK procs to work better in those environments - which means it'll likely work better in yours, too. For example,…
Thanks to this technique to run SQL Server on Apple Silicon chips, I'm now developing exclusively on my Mac! I've been using a Mac for over 15 years, but in the past, I've always used Windows at some layer somewhere. This time around, it's all Mac the whole way down, which is kinda nifty. Makes my release process easier.
Santa's elves took a break from building toys and shipped a new version of the First Responder Kit. There are some great improvements in here, like a makeover for sp_BlitzLock and much better PSPO compatibility for sp_BlitzCache.
To get the new version:
