Excellence in SQL Server

This is the second tip for making your setup of SQL Server 2012 AlwaysOn Availability Groups easier. Tip 2: Make sure that you have...

We recently set up a production SQL Server 2012 system with AlwaysOn Availability Groups (AG) to provide High Availability (HA). During...

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

Recently I was working on a SQL Server that had the following trace flags enabled. 1204 and 1222 for deadlocks. 1117 uniform tempdb...

Whilst debugging a slow query recently and went through the usual suspects. There were indexes on join columns, all the table joins were...

Whilst recently reviewing performance issues on a large legal system, I noticed that every non-clustered index, explicitly included the...

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

In SQL Server 2014 there are 289 messages with the word 'availability'. Run the following query: SELECT message_id, severity, text FROM...

Detecting and resolving deadlocks in SQL Server can be difficult. By default deadlock detection is not enabled. Deadlocks can cause data...

SQL Server comes with a large number of alerts and errors that on some systems are never configured. SQL Agent Alerts should be...

When I started with SQL Server over 20 years ago we wrote our own backup and maintenance stored procedures and then created SQL Server...