New Version Of SP_Blitz With Some Contributions From Me

Brent Ozar Unlimited has released a new version of their awesome sp_Blitz server checkup script. I’m pleased to report that this version includes some checks that I submitted: a check for the last successful DBCC CHECKDB, a check to see if @@servername is null, and an update to the backup check to make sure the […]

Share

A Useful Tip For Dealing With A Full Transaction Log Drive

This is a problem all DBAs will run into at some point – the drive a database’s transaction log is on runs out of space. In most cases, this was caused by the transaction log autogrowing until there is no room left on the drive. If your alerts are set up correctly, you’ll get an […]

Share

Yet Another Reason Why Dynamics / Great Plains Is Horrible

The database design for Dynamics / Great Plains is well known to be incredibly poor. Now I’ve run into another reason why the program sucks. As per best practices, I’ve got alerts set up on all my SQL Servers. One of these alerts is for severity 20 errors. I have a server that is host […]

Share