Daily Archives: August 18, 2021

Finding Failed Job Steps

Kendra’s query was a good starting point, and I used most of it in the first CTE shown below. This query basically looks at msdb.dbo.sysjobhistory and msdb.dbo.sysjobactivity, joining them on the job_id, which is the PK. However, we are only … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Better SQL is a Good Career Investment

Many of us reading this are data professionals, and we likely know quite a bit about SQL in general. We may use T-SQL, specifically, with SQL Server, but many of the skills we have would be portable to other dialects, … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Daily Coping 18 Aug 2021

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. All my coping tips … Continue reading

Posted in Blog | Tagged , , | Leave a comment