Tag Archives: administration

Extended Event Comfort

Posted on February 10, 2025 by way0utwest

I saw an interesting thread recently in the SQL Server Community Slack where someone posted about extended events (XE). They were asking about whether XE would have a problem with a situation. The problem wasn’t so interesting, but a quote … Continue reading →

Posted in Editorial | Tagged , | 4 Comments

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