Tag Archives: administration

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

Who Still Uses SP_ for Naming?

Posted on December 13, 2023 by way0utwest

An interesting post recently from Chad Callihan on the reasons why someone shouldn’t use sp_ to prefix their stored procedures. This is advice that I’ve seen for years, but I haven’t run into this lately with many customers. It seems … Continue reading →

Posted in Editorial | Tagged , | 6 Comments