Tag Archives: administration

Reusing Tools for New Purposes

Posted on January 23, 2022 by way0utwest

One of the things you learn early on in programming is that you ought to reuse code whenever possible. This often means refactoring code into functions or methods. This ensures that the code is more easily maintained and that the … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Reusing Tools for New Purposes

The Need for 256GB

Posted on January 21, 2022 by way0utwest

I have seen a few people call for raising the RAM limit in the Standard Edition of SQL Server. In 2016, Aaron Bertrand voiced this, and for 2019, Glenn Berry asked that the limit be raised to 256GB. In the … Continue reading →

Posted in Editorial | Tagged , , | 5 Comments

Data Cleanup

Posted on January 3, 2022 by way0utwest

The end of the year is when I do a little data cleanup. Not a lot, but some. Work slows down, with no major deadlines, so I’m able to spend a bit of time organizing myself. I usually go through … Continue reading →

Posted in Editorial | Tagged | Comments Off on Data Cleanup

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