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.

Deployment Contributor Logger

Niche tool of the day

If you know what a deployment contributor is and have wanted to see what steps were in a plan and have got bored setting a breakpoint in visual studio and using the watch window or something to display the steps in a plan, you might find this useful.

It is really simple, all it does it look through all the steps in a deployment plan and dumps (Console.WriteLine) the steps, any properties it can find and some custom bits like the T-SQL that makes up the step.

If you have no need to see what makes up a deployment plan then it is pretty useless :)

To use it, grab the code from https://github.com/goeddie/DeploymentPlanLogger add it to your folder that has sqlpackage.exe in and append this argument “/p:AdditionalDeploymentContributors=AgileSqlClub.DeploymentPlanLogger”.

If you have lots of steps then it will generate a lot of text, make it slightly quicker by piping the output to a text file and then reading that.

This is only of use when you are experimenting or learning about deployment contributors so not everyone’s cup of tea!

This is what the output looks like:

output from the dpleoyment contributor logger

I wrote it in literally an hour so it doesn’t cover every case but should be enough to get someone started in case this sort of thing floats your boat!