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 want the opportunity(…)
Posts by Thomas LaRock:
Recently (OK, on July 23rd, 2014 to be exact) I co-presented a webinar with Scott Klein (blog | @SQLScott) titled “Know Before You Go: SQL Server on Microsoft Azure Virtual Machines“. It was a repeat performance of the session we delivered at TechEd in Houston earlier this year. There were a handful of questions asked during(…)
Remember when I told you I had come across and old script that checked your SQL Server configuration setting? Well, here’s another old script of mine I think is worth sharing. The idea was that I wanted to verify what changes (if any) were made to my SQL Server instance as a result of a 3rd party vendor(…)
I was going through some old files recently and I came across a folder that was essentially a junk drawer of scripts I’ve put together over the years. I don’t know what to do with most of them now. For example, the isql scripts for some Sybase ASE 11.5 instances aren’t very helpful for many these(…)
I’ve said it before but it bears repeating: I work with some amazingly creative people these days. Happy Sysadmin Day!