-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Ed Elliott's Sql Developer Blog

Ed is a Sql developer who has a mixed background in support, as a dba and as a developer working with a number of languages c, c#, vb, go, assembly with a variety of technologies and is currently trying to make the sql developer community a little bit more agile, one build step at a time!

Archives: September 2015

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…

Read more

0 comments, 579 reads

Posted in Ed Elliott's Sql Developer Blog on 30 September 2015

Deployment Contributor KeepTableColumns Filter

To help with this scenario (it is pretty specific):

You have a table that has columns that you do not know about when you create the dacpac, possibly you have a customer who modifies your schema after you deploy. If you deploy your dacpac those columns will be dropped which…

Read more

0 comments, 625 reads

Posted in Ed Elliott's Sql Developer Blog on 23 September 2015

Inside an SSDT Deployment Contributor

In my deployment filter I have been asked a couple of times to allow columns that exist on a table that do not exist in a dacpac to be ignored so that they are deleted. The typical scenario is that a vendor supplies a database and then customers can add…

Read more

0 comments, 516 reads

Posted in Ed Elliott's Sql Developer Blog on 23 September 2015

Setting up a new CI server to build SSDT projects

I am going to ignore the fact that people don't want to install visual studio on a build server, in the future there will likely be a way to install just the required components rather than everything. Today, the way I see it is that I develop in Visual Studio,…

Read more

0 comments, 412 reads

Posted in Ed Elliott's Sql Developer Blog on 23 September 2015

ScriptDom versioning issues

I installed the 2016 SSMS client recently and in one way or another any of my apps that I have written that use the DacFx ScriptDom have all broken in slightly different ways. One app throws a type conversion error and another just failed to find any statements in a…

Read more

0 comments, 525 reads

Posted in Ed Elliott's Sql Developer Blog on 15 September 2015

Why is my tSQLt test not running?

I wrote a test earlier and forgot one of the two cardinal rules about tSQLt so I was running my test suite and the test did not run, I re-deployed and it still didn't run so I thought I would create this handy list of things to check that mean…

Read more

0 comments, 1,094 reads

Posted in Ed Elliott's Sql Developer Blog on 10 September 2015

We can do professional SQL Server deployments using SSDT

Really excited by my first post on medium, haven't really used it before but found it to be a really nice tool:

https://medium.com/@edelliott.the.agilesql.club/let-s-start-doing-profes...

Read more

0 comments, 475 reads

Posted in Ed Elliott's Sql Developer Blog on 2 September 2015