Pro SQL Server on Linux–Install

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

Query memory grants part 2: Varchars and sorting

Why the heck did we make all our columns varchar? That’s a hypothetical question, please.
But now we have to pay...

Source Control using Azure Data Studio and GitHub

You can maintain and deploy code easily

Source control is a vital part of IT work, since it is used to track changes over software and documents, with two main...

Source Control using Azure Data Studio and GitHub

You can maintain and deploy code easilySource control is a vital part of IT work, since it is used to...

SQL Server Removing Duplicates

I know, I know your data could never possibly have duplicates because obviously, you have all the constraints in place...

Store sensitive information with Azure Key Vault

Azure Key Vault is a service which allows you to keep and manage passwords, certificates and other sensitive information securely....

Testing SQL in the Advent of Code

I like participating in the Advent of Code each year, though my participation often varies wildly as life gets in...

TICK TOCK…6 MONTHS UNTIL SQL SERVER 2008/2008 R2 SUPPORT EXPIRES UNLESS YOU TAKE ACTION

If you are still running SQL Server 2008/2008 R2 you probably have heard by now that as of July 9,...

Waiter Waiter There's an Index in my Index

I’ve done a few posts on Clustered and Non-Clustered indexes before, what I’ve not however covered and something that is...

Automating like an Enterprise DBA

TSQL Tuesday
The second Tuesday of the month comes to us a little early this month. That means it is time...