If you write code to SQL Server then you might be interested in this: I have written a tSQLt tdd training course which has helped over 500 people learn both tSQLt and how to apply TDD practices to their SQL Server T-SQL development, you can join the course at https://courses.agilesql.club.

xSQLServer is dead long live SqlServerDsc

I have had a problem with DSC in Azure Automation for a few months now, there was a change made to t...

What The Tool? Multiple choice quiz to help you choose a tool for SQL Server

There are a few different choices for tools to use when it comes to SQL Server, while the “exp...

Azure Virtual Machine + Premium Disk Throughput Calculator

I keep having to refer to the virtual machine size page and the disks pricing page to work out how b...

Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)

I was setting up an availability group listener recently and when I tried to connect to the listener...

You have your database in source control now what?

This post is for a specific type of person if you are: New to source control Are getting started on...

SSDT How To Fix Error SQL17502

TLDR: If you build an SSDT project you can get an error which says: “SQL71502: Function: [XXX]...

Where do you install tSQLt?

The question of where to install tSQLt is probably the most common question I get when I talk about ...

tSQLt Test Adapter for Visual Studio 2017

So Visual Studio 2017 has been released a while and I had created a version of the test adapter (whi...

Learn how to unit test SQL Server T-SQL code

A free email course on how to use tSQLt including the technical aspects of writing unit tests AND th...

SSIS ForEach Enumerator File Order

I saw on slack recently a question about how the ssis file enumeraror orders (or more specifically d...