Tag Archives: administration

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

Be Careful with Missing Index Requests

Posted on December 4, 2023 by way0utwest

One of the things that has been interesting to watch over time is how the SQL Server platform has expanded the amount of information that we get back about the performance of the query optimizer and query processor. While it’s … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Be Careful with Missing Index Requests