Skip to content

No one believes me when I say I'm not hungry

Choose a tag to compare

View all tags
@BlitzErik BlitzErik released this 14 Nov 16:30
2017-11-15
5d9f493

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 this week!

Please clap.

sp_Blitz Improvements

  • #1199 We've updated the unsupported builds list! Now you can numerically gauge how bad you are at patching SQL Server. Thanks to @tony1973 for letting us know about this. Apparently he's really good at patching SQL Server!
  • #1205 We now guarantee a total lack of duplicate Check IDs. Can a primate get a primary key, here? Thanks to @david-potts for letting us know about this one.
  • #1207 If you have read only databases on your server, we'll no longer gripe about a lack of DBCC CHECKDB. Thanks to @Gavin83 for coding this one!

sp_BlitzCache Improvements

  • #1230 Oh, that missing parameter in the dynamic SQL. Thanks to @GrzegorzOpara for letting us know!

sp_BlitzFirst Improvements

  • #1232 No one likes retaining things. Actually, people like retaining everything other than water. Which is weird, since HYDRATION IS IMPORTANT! I'm not a doctor, but this new parameter is a good way to purge old perf data. Put your data on a diet.

sp_BlitzIndex Improvements

Nothing this time around

sp_BlitzWho Improvements

Nothing this time.

Next time around, we're going to be pruning the default list of columns that it returns, and adding an @ExpertMode that returns all of them. If you have opinions, now's the time to let us know.

sp_DatabaseRestore Improvements

@ShawnCrocker did a bang up job adding and fixing a bunch of stuff, as only someone who actually needs to restore databases all the time can do!

  • #1198 The @StopAt parameter was being ignored for Full and Diffs -- no more!
  • #1192 There was a dependency bug when moving files was blank. Now we look for the default instance path.
  • #1180 You can now change the recovery model of a database after restoring it!

sp_BlitzBackups Improvements

Nothing this time.

sp_BlitzQueryStore Improvements

Nothing this time.

sp_AllNightLog and sp_AllNightLog_Setup Improvements

  • #1133 Skips over attempting to restore system databases, because what kind of maniac would want that to happen? Thanks to @dalehirt for this one!

sp_foreachdb Improvements

Nothing this time.

Assets 2
Loading