First Responder Kit Release: Now With 50% MORE Double Checking

First Responder Kit

So many things happen in mid-Summer. Dreams. Death. Pit stains.

And FRK updates!

Special thanks to @digitalohm for once again taking the axe to sp_DatabaseRestore. You are the only person on our email list who isn’t getting a Box O’ Tripe®

You can download the updated here.

sp_Blitz Improvements

  • #872 @MosesOfJ pointed out that, while our code is flawless, our spelling was not. Thanks, Mo.
  • #877 Dear sir Moses also pointed out that our code is not flawless, but our spelling was! Hey, we’re… 50/50. Kinda. What’s math got to do with code, anyway? Now SkipChecks work NVARCHAR(4000)% better.

sp_BlitzCache Improvements

  • #889 Added pre-2017 future-proofing to pull information about statistics and adaptive joins out of XML
  • #890 Things were formatted. No one got drooled on. Quite the day.

sp_BlitzFirst Improvements

  • #879 After a weird situation (blame @TaraKizer), we decided to stop ignoring CLR waits. Boy oh boy.

sp_BlitzIndex Improvements

  • Nothing this go around. We try not to mess with perfection.

sp_BlitzWho Improvements

  • Has attained a zen-like state and did not receive any chakra filth.

sp_DatabaseRestore Improvements

  • #871 Here we stand athwart log restores yelling STOPAT! So, you know, if you want to stop at a certain time within a log restore, you can do that now. This was all @digitalohm, whose mailbox will not smell like the worst hangover ever.


  • Initial release! There were many PRs and fixes in the dev branch leading up to this that aren’t really pertinent historically, because this has no history. Literally none. This is a newborn. Give it a spankin.


  • MAZEL TOV! It’s another new stored procedure. Requires 2016, and an enabled query store. Details will be forthcoming in a blog post this week, but you can get it now and feel the hot rush of blood that accompanies hitting F5 and finding out how horrible things truly are.


You can download the updated here.

Previous Post
Why Your Biggest Query Plans Don’t Show Up in Some DMVs
Next Post
[Video] Office Hours 2017/05/31 (With Transcriptions)

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.