Tag Archives: administration

The Need for 256GB

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

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

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

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