If you write code to SQL Server then you might be interested in this: at the end of 2017 I wrote a tSQLt tdd training course which has helped over 300 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. The course is free if you are happy to wait 10 weeks to complete it, with 1 lesson being made available per week - if you are in more of a hurry or you would like to help support the project you can purchase the course which makes it instantly available to you.

SSDT: Unable to connect to master or target server.

Every now and then I come across this error in SSDT, normally when trying to publish and the odd thi...

SSDT Deploy / Publish Performance

Publishing dacpac’s is a little bit of a pain when you have multiple databases, it can easily ...

Refactoring in SQL Server Data Tools - SSDT

In this post I will talk about the in-built refactoring support in SSDT – the language is slightly d...

Database Deployments in Uncontrolled Environments

The ideal is to make a change and see that change deployed to production, in a perfect world we woul...

Controlling a dacpac deployment

I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how t...

tSQLt Visual Studio Test Adapter

tSQLt Visual Studio Test Adapter What is this? This lets you use Visual Studio to run tSQLt tests ea...

DacFxed - Powershell Nugetized DacFx wrapper

Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to o...

SQLCover v 0.2 - Bug fixes and Azure V12 Support

I have released a new version of SQLCover which is a code coverage tool for T-SQL (let’s you i...

Where do you put your business logic? In stored procedures?

There seems to be two trains of thought and I think this is mainly down to who and where your develo...

How do you audit automatically generated sql deployment scripts?

I saw recently an email where someone stated that the reason that they manually create deployment sc...