Crystal Reports Formula for MSDB Dates and Times
As a DBA, I find myself spelunking through data and often having to present it in a somewhat human-friendly format. This is where my skills with Crystal Reports come in quite handy. I joke that I’m a Crystal Reports Jedi Master. Truth be told, I’ve just been working with the product entirely way too long. [...]
Using sysjobhistory to Find What’s Running Longer than Usual
We all have SQL Agent jobs that run periodically. Wouldn’t it be nice to know that something ran longer than average last night? When something runs longer than average, this could indicate a looming problem. I love finding these things before they cause serious problems because that prevents my phone from ringing in the middle [...]