Tag Archives: administration

Enabling an Index: #SQLNewBlogger

Posted on October 2, 2024 by way0utwest

I don’t do a lot of work with disabled index, but I learned how to re-enable one today, which was a surprise to me. This short post covers how this works. The Scenario Imagine that you have an index on … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Enabling an Index: #SQLNewBlogger

Cleaning Up Your Database

Posted on October 2, 2024 by way0utwest

How many of you have objects in your database that aren’t being used? What about something in a schema with a _old in the name? Or _2 or _3 or _delete? There is a lot of old, deprecated stuff I … Continue reading →

Posted in Editorial | Tagged | 2 Comments

Monday Monitor Tip: Compliance Checking for Old Versions

Posted on September 30, 2024 by way0utwest

A customer recently wanted to know if any of their instances were too old and out of support. This was for a compliance purpose, and they had the need to show a report to management of when instances were out … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Monday Monitor Tips–Finding CUs for My Instance

Posted on September 16, 2024 by way0utwest

How can I quickly get a CU patch for a system that’s out of date? I’ll discuss that situation. You might think you get to patch every instance every few months, and you may be able to. But most of … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment