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 How To Fix Error SQL17502

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

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

SqlPackage Deploy Performance - IgnoreXX are not your friend!

Following on from yesterdays blog I was wondering about the comparison of objects that were the same...

SSDT Deploy / Publish Performance

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

SSDT and Friends - .net meetup video

I did a talk at the london .net meetup if you want to get an overview of what SSDT is and how to get...

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

tSQLt Visual Studio Test Adapter

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

Post Deploy Scripts In Composite Dacpacs not deploying

Composite projects in SSDT are a really useful way to logically split databases up while still being...

What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!

In the final part of this 3 part series on what SSDT actually is I am going to talk about the docume...

What is SSDT? Part 2 - More Reasons to Bother!

In part 1 of this series available here I introduced my drawing of what I think SSDT is and talked a...