Tag Archives: administration

Monday Monitor Tips: Projecting Disk Space

Posted on October 28, 2024 by way0utwest

One of the things that many DBAs struggle with is managing space across an estate. There might be one or two servers that you watch closely, or that are a constant problem, but it’s easy to run out of space … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Monday Monitor Tips: Projecting Disk Space

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