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 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
Big breaking change here: the new @OutputTableRetentionDays parameter defaults to 7 days. If you’re keeping more data than that in your BlitzFirst% output tables, set this parameter in your jobs right away, or else data older than 7 days is going to get deleted.
- #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 @OutputTableRetentionDays 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
@StopAtparameter 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.
For Support
When you have questions about how the tools work, talk with the community in the #FirstResponderKit Slack channel. If you need a free invite, hit SQLslack.com. Be patient – it’s staffed with volunteers who have day jobs, heh.
When you find a bug or want something changed, read the contributing.md file.
When you have a question about what the scripts found, first make sure you read the “More Details” URL for any warning you find. We put a lot of work into documentation, and we wouldn’t want someone to yell at you to go read the fine manual. After that, when you’ve still got questions about how something works in SQL Server, post a question at DBA.StackExchange.com and the community (that includes us!) will help. Include exact errors and any applicable screenshots, your SQL Server version number (including the build #), and the version of the tool you’re working with.
