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 easilySource control is a vital part of IT work, since it is used to...

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

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

One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing....