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 … Read more
I’ve written before about interviewing a Database Administrator (DBA) and general hiring techniques. I’ve talked about how an interview should be a conversation, not a trivia contest. I always describe the interview process as being a lot like being on a blind date. You shouldn’t be looking to stump someone during an interview. Memorization of obscure facts such … Read more
It’s the end of the college basketball season here in the US. At this time of year I get a little nostalgic for my former life as a basketball coach. I always enjoyed playing in March as that meant our team was doing well and advancing through the playoffs. I recall one year while in … Read more
Last year I did a series on the system tables inside of SQL Server, which included this post on the sysjobhistory table in the msdb database. As much as I like (and use) that code from time to time to help people find the outliers with regards to long running jobs, something always nagged me … Read more
