Logon Triggers Can Stop SQL Agent From Starting

Last weekend was patch weekend and several of my SQL Server machines got Windows Updates applied and were rebooted. Today, I discovered that on a couple of severs, SQL Agent did was not running. The first thing I did was verify that the service was set to autostart. It was. Hmm. Time to dig into […]

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