Monthly Archives: August 2021

Daily Coping 20 Aug 2021

Posted on August 20, 2021 by way0utwest

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 , , | Comments Off on Daily Coping 20 Aug 2021

Register for the 2021 PASS Data Community Summit

Posted on August 19, 2021 by way0utwest

Registration for the 2021 PASS Data Community Summit opened today. This year’s event is virtual on November 8-12, and you can register for free. That’s right, free. No cost, just the time, which is something you might point out to … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Register for the 2021 PASS Data Community Summit

Daily Coping 19 Aug 2021

Posted on August 19, 2021 by way0utwest

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 , , | Comments Off on Daily Coping 19 Aug 2021

Finding Failed Job Steps

Posted on August 18, 2021 by way0utwest

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