sp_blitz

Our free server troubleshooting tool, sp_Blitz®, just learned some new tricks. If you call it like this: EXEC dbo.sp_Blitz @OutputDatabaseName = ‘DBAtools’, @OutputSchemaName = ‘dbo’, @OutputTableName = ‘BlitzResults’ It will create the table DBAtools.dbo.BlitzResults (if it doesn’t already exist) and insert the results. The table includes columns for the server name and the check date,…

There’s a new version in town.  v18 adds new checks looking for: Backups stored on the same drive letters as user databases (Thanks @AlinSelicean!) Agent jobs that don’t have failure notifications set up (Thanks @Thirster42!) Shows free drive space per drive letter if you pass @CheckServerInfo = 1 in. We don’t consider this a problem…

I don’t blog every release of sp_Blitz® (we pushed v15 out silently with a few bug fixes) but we added a lot of improvements and fixes in this version – and by we I mean you.  After I blogged about v14’s release earlier this week, that encouraged a lot of people to come out of the woodwork…