Skip to content

This heat has got right out of hand

Choose a tag to compare

@BlitzErik BlitzErik released this 01 May 17:00

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®

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.

sp_BlitzBackups

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

sp_BlitzQueryStore

  • 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.