Let’s talk SQL Server Waits: Topic 2 – CXPacket

With our effort to talk about SQL Waits we come across another common wait called CXPacket. Last week we reviewed...

Multi-server scripts with SSMS using SQLCMD mode

SSMS is the most common tool used by SQL Developers or DBA’s but unfortunately there are some features that are...

See SQL Run

Note: I am perfectly aware of my ability as an artist so let the ribbing begin

Speaking at SQLBits in March 2019

I have been selected to speak for a second time at SQLBits, which is being hosted in Manchester UK this...

Understanding and working with NULL in SQL Server

Graphic representation of the difference between 0 and NULLImage taken from 9gag.com

According to database theory, a good RDBMS must implement a marker to indicate "Missing or inapplicable information".SQL Server...

Understanding and working with NULL in SQL Server

Graphic representation of the difference between 0 and NULL
Image taken from 9gag.comAccording to database theory, a good RDBMS must implement...

Webinar next week on Database DevOps

Next week is my webinar on why the database is the heart of DevOps. You can still register today to...

Authentication considerations for your applications when migrating to Azure SQL Managed Instances

This blog post is related to my previous blog post on Azure SQL Managed Instances:
Azure SQL Managed Instance – full blown...

Azure SQL Managed Instance – full blown SQL Server in the cloud….?

This blog post is one that I have had percolating in the background since around November 2018.
My good mate John...

Cardinality: Not Just For The Birds

Watch this week's video on YouTube
When building indexes for your queries, the order of your index key columns matters.  SQL Server can make the most effective use of an...