Tag Archives: administration

How Do You Patch 100 Database Servers?

Posted on November 18, 2024 by way0utwest

In most of the organizations I’ve worked for or consulted with, patching was always a challenge. Patching hasn’t usually been given a priority and is often skipped when operations staff is busy. This has resulted in lots of un-patched, or … Continue reading →

Posted in Editorial | Tagged | Comments Off on How Do You Patch 100 Database Servers?

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