Tag Archives: administration

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

More Interactive Notebooks from MS Docs

Posted on August 11, 2021 by way0utwest

I saw a note from Microsoft recently that they are trying to improve some of the support experiences for customers that are going through their docs. The idea is to make it easier for a customer to get a rich … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on More Interactive Notebooks from MS Docs

Deploying SQL Server Automatically

Posted on July 31, 2021 by way0utwest

I’ve had to install SQL Server many times over the years. Often it has felt that most of these installs were one-offs, a dev server, a new QA instance, a production server for a brand new application. A few times … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Deploying SQL Server Automatically

Essential Operations

Posted on April 22, 2021 by way0utwest

It would seem obvious, but IT Operations staff are often essential to ensuring that systems and business can keep running. From websites to email to VPNs, many of the companies in which I’ve worked don’t have systems that will run … Continue reading →

Posted in Editorial | Tagged | Comments Off on Essential Operations