Tag Archives: administration

Rename a Database: #SQLNewBlogger

Posted on November 13, 2024 by way0utwest

I had someone ask me how to rename a SQL Server database recently. They were doing some development work and wanted to rename databases to test an application. I thought I remembered, but in this post, I show I learned … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Monday Monitor Tips: Tracking The Cost of Instances

Posted on November 11, 2024 by way0utwest

One of the things that I’ve been asked in every operations situation is what licenses do we need for our servers. This is a rare request, often once a year, but it results in a bunch of work to figure … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Monday Monitor Tips: Tracking The Cost of Instances

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