DacFx how to get the data type from a column a discussion of properties, relationships and the TSqlModel
Reading Time: 15 minutes (it is quite hard going, but you need to know this if you need to work with...
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.
How can we merge multiple dacpacs into one
Reading Time: 4 minutes (not a minute longer) TLDR; You probably don’t want to actually merge ...
SSDT: Build in VSCode
Over the last couple of years I have been using VSCode more and more and Visual Studio less and less...
SSDT: /p:AllowIncompatiblePlatform, what platforms are compatible?
Sometimes you don’t have the perfect development environment for SQL Server, sometimes you dep...
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...
