First Responder Kit Updates

Brent Ozar's Consultant Toolkit

Updated First Responder Kit and Consultant Toolkit for April 2019

April 30, 2019

First Responder Kit Updates

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: Download the updated FirstResponderKit.zip Azure Data Studio users with the…

Pocket Square

Updated First Responder Kit and Consultant Toolkit for March 2019

March 21, 2019

First Responder Kit Updates

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 EU customers:…

Pocket Square

Updated First Responder Kit and Consultant Toolkit for February 2019

February 20, 2019

First Responder Kit Updates

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…

Pocket Square

Updated First Responder Kit with Your January Code Resolutions

January 28, 2019

First Responder Kit Updates

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 Improvements: skipping checks on Azure SQL DB Managed…

Pocket Square

Updated First Responder Kit for January 2019: Extraneous Syllables

December 26, 2018

First Responder Kit Updates

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. Anyway, you should go hug someone smarter than you. Unless they have sensory or boundary issues. Or a restraining order against you. Thank…

Updated First Responder Kit for November 2018: Get Into Sports Dummy

November 30, 2018

First Responder Kit Updates

COACH! 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…

Pocket Square

First Responder Kit Release: Fingers Crossed!

October 2, 2018

First Responder Kit Updates

This is a small release just to make sure you don’t forget about us. We know you’re busy. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1755 – @MisterZeus added a new check for alerts that don’t send information out. I mean, is that even an alert? #1766 – @jadarnel27 added some code to help folks who have a standard (non-sa)…

Pocket Square

First Responder Kit Release: What Does A Fish Know About Friday?

August 31, 2018

First Responder Kit Updates

I know, it seems like just yesterday I was doing one of these releases. But no, it was three weeks ago. You’ve just been drunk for a really long time. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1698 – Now warns you about any SQL Modules that have ANSI_NULLS or QUOTED_IDENTIFIER off. Thanks @MisterZeus! #1719 – @TheUsernameSelectionSucks pointed out…

First Responder Kit Release: A Year From Now These Will All Stop Working On 2008 And 2008R2

August 10, 2018

First Responder Kit Updates

You think I’m kidding. Time bomb. Boom. Get your upgrade underwear on. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1664 – We’re officially smart enough to not warn people that we’re recompiling our own stored procedures. #1669 – Reworded the stacked instances details. Servers may be installed and not running. #1687 – @josh-simar has servers linked with AD accounts,…

Pocket Square

First Responder Kit Release: Like pssdiag, if pssdiag had parents who cared

June 27, 2018

First Responder Kit Updates

I went to the PFE and guess what he told me? Guess what he told me? He said girl you better try fix those spinlocks too No matter what you do, now run this tool You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1620: @AAvella schooled us on Group Policy registry settings. Someday, we’ll get our act…

Pocket Square

First Responder Kit Release: Just When You Think There’s Nothing New Left To Do

June 4, 2018

First Responder Kit, First Responder Kit Updates

T*m* f*r An*th*r F*rst R*spond*r K*t R*l**s*. All joking aside! A big thank you goes out to a few people this go around: @jadarnel27 for not only contributing a bunch of Super Professional T-SQL, but also for writing a web scraping application to compile a list of current SQL Server versions. @nedotter @ktaranov and Aleksey Nagorskiy for putting together…

First Responder Kit Release: Darn May Showers

April 30, 2018

First Responder Kit, First Responder Kit Updates

There’s usually something that I think is funny in this space. Instead, I’m going to extend my already extensive day of civic duty by letting you know something interesting about jury duty. Sometimes, if you show up when they ask you to, they can make you come back for a second day if they…

Pocket Square

First Responder Kit Release: Driving Miss Data

March 29, 2018

First Responder Kit Updates

Ugh. Bungabase slow. When Grog try count meat, Glug eat meat. Then Grog get hungry and Glug try count meat. Bungalock. Need big head make bungabase fast. You big head? You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1459: A while back, Brent blogged about implicit transactions. In the comments, a smart commenter named Dan pointed…

Pocket Square

First Responder Kit Release: SQLBits was pretty awesome but now I have to do work again

February 28, 2018

First Responder Kit Updates

APRIL FOOLS! IT’S ONLY MARCH FIRST! Tomorrow. Butthead. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1407: @parlevjo2 gave us a check to make sure databases are owned by an existing user. Existence is everything, so I hear. #1416: After existence is probably location. After that is collation. @ktaranov let us know that our collation wasn’t all that. Especially…

Pocket Square

First Responder Kit Release: Sunday, Boring Sunday

January 28, 2018

First Responder Kit Updates

This is a modified limited release. After a few new feature releases, we’re achieving stasis. You can download the updated FirstResponderKit.zip here. There are a couple points from the last release that I really need to emphasize: sp_BlitzCache got some new columns added to the output for tempdb spills. If you want to keep logging it…

First Responder Kit Release: It’s Too Cold Not To Do A Release

January 9, 2018

First Responder Kit Updates

You look just like a snake when you crawl like a worm. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1310: @CferMN reported quite an odd conversion error! Turns out, division was a better idea than multiplication. #1341: We we missing the newest version of Windows, and we had a broken link. Thanks to @JaySpatzfor letting us know!…

Pocket Square

First Responder Kit Release: Treating Object References Like Object Instances, Man

December 5, 2017

First Responder Kit, First Responder Kit Updates

Object reference not set to an instance of an object. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1281 We’ve lowered the priority of Query Store being disabled. It’s just not as important as the backups you’re not taking and the corruption checks you’re not running. sp_BlitzCache Improvements #1253 Due to an unfortunate copy and paste incident,…

First Responder Kit Release: The Ides Of November

November 15, 2017

First Responder Kit, First Responder Kit Updates

IB Rewop This is a cleanup release to get some of the pull requests in that didn’t make it in before the precon. There’s also a secret unlockable character that Brent is blogging about next week! Please clap. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1199 We’ve updated the unsupported builds list! Now you can…

Pocket Square

First Responder Kit Release: Precon Precogs

October 24, 2017

First Responder Kit, First Responder Kit Updates

This release comes to you from a hotel room in Chicago: The land of fiscal insolvency and one shooting per hour. It’s pretty nice, otherwise. This release is to get the pre-precon important stuff in. As much as I’d like to push all the recent contributions through, between travel, speaking, and uh… what do the…

Menu