T-SQL Tuesday #104 – My Undercover Toolbox favourites

This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here. Bert has a great topic for this month, he wants us to write about code you’ve written that you would hate to live without. I have found the SQL server community to be extremely helpful... Continue Reading →

Jul 10, 2018 2

UNDERCOVER TOOLBOX: Sp_RunningJobs – See all currently running SQL Agent Jobs

Update: 07/08/2017 - Identified and fixed a bug with the Elapsed Days not showing accurately. Update: 31/7/2017 - We have improved the Stored Procedure, the revised version now includes Days elapsed in addition to Hours, Minutes and Seconds. There are quite a few Running agent job scripts out there , most of the ones I... Continue Reading →

Jul 27, 2017 3