March comes in like a 40 of Steel Reserve and leaves like your memory of the night after drinking a 40 of Steel Reserve.
Get it here!
#754 You know what Brent hates? Poison. Not the song, or the band, just the wait types. He added some more, and proud we are of all of them.
#670 You know what else Brent hates? Evidence. You should see the amount of stuff I’ve had to burn, shred, and bury since I started working here. I mean, you shouldn’t see it. So now we recompile the stored proc and all the dynamic SQL in it so it doesn’t leave a bunch of garbage behind in your plan cache.
#715 Are you on 2016? Are you me? We now support using the sys.dm_exec_function_stats view. You’ll use it a ton, I’m sure.
#751 We now offer vague and temporary support for Azure SQL DB. Why? Because MS has made breaking changes without much warning before, so this could break by the time you try to run it. @BrentOzar again!
#741 HEAPs are just the worst, right? Because Forwarded Records, right? They’re a zoo. Now we warn you if you have a lot of those in a sample period. You’re welcome. Now fix your HEAPs.
#698 One time I tied myself to train tracks. Wait, no, that was a roller coaster. There was screaming a lot of screaming and crying and sweat-soaked cotton candy. Then @BrentOzar untied me. Then he tied file speeds to wait types so you know if your storage is to blame for writelog or pageiolatch waits.
#723 The funny thing about missing index requests is that they’re not all created equally. Some of them don’t have a very high impact, and some of them don’t have a very high usage rate. We make some distinctions now. We’ll make more later.
#720 There was some minor rioting when we (I) changed code to look in master for sp_BlitzWho. Now we look in master or in the current database context, so if you have our stored procs in another database, you can run them from that database and probably find things.
Get it here!
Thanks for reading!