It's too cold not to do a release
You look just like a snake when you crawl like a worm.
sp_Blitz Improvements
#1310: @CferMN reported quite an odd conversion error! Turns out, division was a better idea than multiplication.
#1341: We we missing the newest version of Windows, and we had a broken link. Thanks to @JaySpatz for letting us know!
#1359: Something we've all wanted for a long time: We now tell you which power plan your server is running. It turns out there are three major ones that have been around since like, forever. If you have a weird custom power plan, let us know! Some manufacturers add their own. We are using xp_regread to do this, which we think is less intrusive than xp_cmdshell.
sp_BlitzCache Improvements
There have been quite a few improvements and fixes around the new clickable columns. I do apologize (and take full responsibility for) the bugs. Hopefully this'll be the end of it, but just saying that... Long story short, did you know that QUOTENAME returns NVARCHAR(258)? #1322, #1327, #1329, #1365
#1325: We not grab schema along with store proc/function names
#1349: Improve the handling of some warnings that were firing inconsistently when multiple statements were in a batch
#1331: To improve documentation, I added URLs to a bunch of warnings that were missing
#1366 Add tempdb spills (and a new spill/avg spill sort order), 2017 cu3+ only
#1370: Basic collection of new row goal information, 2017 cu3+ only
sp_BlitzFirst Improvements
#1367: Add new CXCONSUMER wait to list of known waits. 2017 cu3+ only (also supposedly coming to 2016 sp2)
sp_BlitzIndex Improvements
#1337: @js0505 was kind enough to add a data compression switch to index create statements
#1344: New check for indexes with a bad read to write ratio. These are indexes that do get used by read queries, but get way more writes.
sp_BlitzWho Improvements
Nothing this time around
sp_DatabaseRestore Improvements
Nothing this time around
sp_BlitzBackups Improvements
Nothing this time around
sp_BlitzQueryStore Improvements
All the same stuff as sp_BlitzCache, except the tempdb spill info, because that wasn't added to query store DMVs.
sp_AllNightLog and sp_AllNightLog_Setup Improvements
Nothing this time around
sp_foreachdb Improvements
Nothing this time around
PowerBI
Nothing this time around
sp_BlitzLock
#1350: @DaleKBurrell let us know about a fix for illegal XML characters! Thanks!