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

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

Research into Autism in Information Technology

Title: Exploring the experiences of employees on the autism spectrum working in information technology: an interpretative phenomenological analysis

My name is Sabrina Ellis, I am the Operations Director here at...

Research into Autism in Information Technology

Title: Exploring the experiences of employees on the autism spectrum working in information technology: an interpretative phenomenological analysis

My name is...

SSDT: Build in VSCode

Over the last couple of years I have been using VSCode more and more and Visual Studio less and less, this is great but there isn't first class support...

SSDT: Build in VSCode

Over the last couple of years I have been using VSCode more and more and Visual Studio less and less,...

Input Into Azure Data Studio

I see more and more people starting to use Azure Data Studio. As it keeps growing and expanding, it’s going...

Pro SQL Server Linux–Connecting and Building an App

As part of my learning goals for 2018, I wanted to work through various books. This is part of my...

Defaults In msdb Database

The defaults in the msdb database are about what is missing. It's missing quite a few things that could be critical to your environment.
Related Posts:

SQL Server Configurations - Back...