Launch week: the Season Pass & Fundamentals Week are 50% off — ends in 14d 17h 26mSee the sale

Category: First Responder Kit Updates

[Video] Updated First Responder Kit and Consultant Toolkit for May 2020

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.

Read more about [Video] Updated First Responder Kit and Consultant Toolkit for May 2020 3 comments — Join the discussion

Updated First Responder Kit and Consultant Toolkit for January 2020

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.

Read more about Updated First Responder Kit and Consultant Toolkit for January 2020 Be the first to comment
News & Opinion

Announcing a New Live Online Class: How I Use the First Responder Kit

During the hands-on labs for my Mastering classes, when I'm answering an attendee question, this kind of thing happens a lot: Attendee: "How would I find the query causing that missing index recommendation?" Me: "Oh, good question - you can use the sp_BlitzCache @SlowlySearchPlansFor parameter. Here's how it works." (Does a quick demo) Attendees in…

Read more about Announcing a New Live Online Class: How I Use the First Responder Kit 2 comments — Join the discussion

Updated First Responder Kit and Consultant Toolkit for October 2019

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.

Read more about Updated First Responder Kit and Consultant Toolkit for October 2019 4 comments — Join the discussion

Updated First Responder Kit and Consultant Toolkit for September 2019

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.

Read more about Updated First Responder Kit and Consultant Toolkit for September 2019 6 comments — Join the discussion

Updated First Responder Kit and Consultant Toolkit for March 2019

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

Read more about Updated First Responder Kit and Consultant Toolkit for March 2019 8 comments — Join the discussion

Updated First Responder Kit and Consultant Toolkit for February 2019

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

Read more about Updated First Responder Kit and Consultant Toolkit for February 2019 5 comments — Join the discussion

Updated First Responder Kit with Your January Code Resolutions

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

Read more about Updated First Responder Kit with Your January Code Resolutions 4 comments — Join the discussion

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

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,…

Read more about Updated First Responder Kit for November 2018: Get Into Sports Dummy Be the first to comment