Excellence in SQL Server

By running a simple check of your database settings (use helpdb or query sys.databases) you may find databases that are set to autoclose ...

We had a query recently about a database that had a lot of objects starting with the name _dta_. We explained that these where hypothetic...

After touching base with a few contacts at Microsoft, I tried a number of suggestions to get the Windows container working with SQL Serve...

Finding the cause of very high CPU usage on your SQL Server may not be as easy as running scripts against a few DMV's, looking at perfmon...

The following is an example of a poorly named table from a major backup software vendor. This caused failures with the regular maintenan...

A common occurrence in reviewing SQL Server implementations is finding very large databases that have log file sizes greater than the siz...

We see a lot of databases in full recovery that don't need to be. Why? Because the default for the model database (used as the template f...

Whilst trying to create a temporal table (system versioned table) on SQL Server 2016, I kept getting a syntax error on the SET (SYSTEM_VE...

I have spent most of the past 5 to 6 years upgrading SQL Servers. Upgrading from SQL Server 2000 (and prior), 2005, 2008 and 2008R2 to SQ...

Recently we had an issue where a database was unable to grow the mdf file. This was causing availability issues as no new inserts were ab...