Excellence in SQL Server

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

Doing a bit of R&D, I decided to start testing docker on my Windows 10 machine so I can run a docker container with SQL Server and then...

Whilst reviewing some code recently I saw the creation of a global temporary table (##). There was actually no need to create a global...

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...

When SQL Server introduced the concept of included columns in indexes in SQL Server 2005, they didn't really provide any way to get...

We are currently working on a project to do a major data update on a manufacturing database to update client and product codes in...

This is just a simple tip to improve the security of your SQL Server installation. If you can, you should try and rename the sa login. It...

It is a far too common occurrence as a SQL Server consultant to have a complaint of poor performance and when you investigate you find...

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

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...

How do you make sure that any user database created is created on the disks that you have set aside for the data, transaction log and...

The setting of the correct index fill factor is a constant source of debate amongst DBAs. There is a lot of information that you need to...

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

This is the eighth tip on SQL Server 2012 availability groups (AG) to help you understand what else you need to consider in creating a...

This is the seventh tip on SQL Server 2012 availability groups (AG) to understand their configuration and setup. Tip 7: In our current...

This is the sixth tip on SQL Server 2012 availability groups to make sure CDC works. Tip 6: Change Data Capture (CDC) has been around...

This is the fifth tip on SQL Server 2012 availability groups to make sure you get your design right. Tip 5: You are limited in SQL Server...

This is the fourth tip for making your setup of SQL Server 2012 availability groups easier and complete. Tip 4: Another business...

This is the third tip for making your setup of SQL Server 2012 availability groups easier and complete. Tip 3: As part of a clients...