Tag Archives: administration

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

Posted on July 3, 2024 by way0utwest

I had a customer that was looking to document a restore that had occurred on one of their systems and didn’t see it. They had concerns about SQL Server accurately tracking history across time and noted they hadn’t cleaned any … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment

Xp_cmdshell Use Cases

Posted on July 3, 2024 by way0utwest

I had someone ask me recently how to run xp_cmdshell on a Linux version of SQL Server. I told them you can’t, as it’s an unsupported feature and not one that I expect to see released. I had to double-check, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Xp_cmdshell Use Cases

What Metrics Do You Collect?

Posted on June 28, 2024 by way0utwest

One of the hot terms in software these days is observability. There are a few definitions (Splunk, RadixWeb), but essentially this is the insight into how your software runs and performs using metrics, logs, traces, etc. In DevOps, we do … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on What Metrics Do You Collect?

DBCC CLONEDATABASE is Semi-Discontinued

Posted on June 3, 2024 by way0utwest

I saw a tweet that DBCC CLONEDATABASE was being discontinued for production databases, which both scared me and didn’t make sense. I’ve used this a few times for a quick copy of a database and like how it works. Discontinuing … Continue reading →

Posted in Editorial | Tagged | 2 Comments