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

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

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 episode on YouTube.
When building indexes for your queries, the order of your index key columns matters.  SQL...

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

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

Controlling the firewall for an Azure SQL DB via T-SQL

The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I...

Deploying SQL Server to Kubernetes using Helm

In previous posts I’ve run through how to deploy sql server to Kubernetes using yaml files. That’s a great way...