Extraneous syllables
sp_Blitz Improvements
- #1874: brent Fixed Some Capitalization Issues.
sp_BlitzCache Improvements
- #1864: If you're on 2016+, we'll populate function names the way we do stored procedure names.
- #1873: Every once in a while I'd get a weird error about a database not being accessible. I tracked it down to the database property returning a wonky result that didn't match an equality.
sp_BlitzIndex Improvements
- #1881: With special thanks to @jobbish-sql for figuring the query out, and @jadarnel27 for putting together an easy Q&A for the documentation page.
- #1884: Fix for false positives in the heaps with nonclustered primary keys check. If you had a column that, by chance, had the word "rid" in it, it would get flagged. Thanks to @imyourdba for reporting this oddball!
- #1888: Added server uptime information to the header row of final results. Just a minor tweak, since several checks reference it.
sp_BlitzFirst Improvements
- #1891: & #1889 both relate to Managed Instances. One with database sizes returning NULLs, and one weird XE wait to screen out. Big thanks to Some Guy Named Forrest® for having a Managed Instance, and playing doctor with us.
sp_BlitzQueryStore Improvements
- #1873: Same as BlitzCache
- #1892: @tboggiano suggested a couple enhancements: to return resources by max, and list out all the different plans we found for a query.
sp_BlitzLock
- #1890: Added some collation modifiers to the final results.
- #1867: Added code to resolve Agent job and step names involved in deadlocks
- #1866: @jobbish-sql and I spent a fun Saturday afternoon perf tuning this old dog, with some nice final results. It went from running for about 5 minutes to running for around 11 seconds.
sp_ineachdb Improvements
sp_foreachdb Improvements
Nothing this time around
sp_BlitzWho Improvements
Nothing this time around
sp_DatabaseRestore Improvements
Nothing this time around
PowerBI
Nothing this time around
sp_BlitzInMemoryOLTP Improvements
Nothing this time around
sp_BlitzBackups Improvements
Nothing this time around
sp_AllNightLog and sp_AllNightLog_Setup Improvements
Nothing this time around