MORE ABOUT ME

SQL Tag

Nobody likes surprises when it comes to upgrading or migrating SQL Server instances. Trace flags get set and forgotten. I'm hoping that this post will help people to remember....

For years I have found myself often needing these three pieces of information with regards to SQL Server:When was the last time the server was restarted?When was the last time the SQL instance was restarted?When was the last time the SQL Server wait stats were cleared?If the server itself is restarted, then the...

A while ago I had posted a script to help find jobs that were currently running longer than expected. Since I've been sharing some scripts recently, I decided to verify that this script still works for finding long running jobs in SQL Agent for SQL Server 2014. Why This Script Matters Because you...