-->
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, 725 reads

Posted in Ed Elliott's Sql Developer Blog on 30 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, 59 reads

Posted in Ed Elliott's Sql Developer Blog on 30 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, 54 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, 699 reads

Posted in Ed Elliott's Sql Developer Blog on 23 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, 8 reads

Posted in Ed Elliott's Sql Developer Blog on 23 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, 7 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, 612 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, 8 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, 8 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, 468 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, 8 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, 9 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, 590 reads

Posted in Ed Elliott's Sql Developer Blog on 15 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, 9 reads

Posted in Ed Elliott's Sql Developer Blog on 15 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, 9 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,152 reads

Posted in Ed Elliott's Sql Developer Blog on 10 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, 8 reads

Posted in Ed Elliott's Sql Developer Blog on 10 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, 9 reads

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

Slides for my pass virtualisation virtual chapter talk on how sql fits into a containered world

The slides are up: https://github.com/GoEddie/SQL-Server-Containers Any questions shout!

Read more

0 comments, 8 reads

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

Older posts