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

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 thing is that the description never matches the actual cause (if you desperate for the cause it is because you can't connect). The thing I like about the description is the…

Read more

0 comments, 232 reads

Posted in Ed Elliott's Sql Developer Blog on 12 June 2017

SSDT DevPack + Visual Studio 2017

I have upgraded the ssdt dev pack to support visual studio 2017 and fixed a couple of minor annoyances and have started to think about how to improve it going forward.

The first feature of sorts is the ability to clear the connection used by the quick deployer without having…

Read more

0 comments, 716 reads

Posted in Ed Elliott's Sql Developer Blog on 8 May 2017

SSDT Dev in Visual Studio Code

I have been quite interested by vs code and have been using it more and more recently. I use it for all my GO (#golang FTW) work and also powershell and I have been toying with the sql tools team's sql extension which is great. For a long time I…

Read more

0 comments, 1,678 reads

Posted in Ed Elliott's Sql Developer Blog on 27 April 2017

Updating TSqlModels (DacFx)

This one is for the DacFx nuts out there, it can't be a very big club but judging from the occasional emails I get about it, the quality is very high ha ha.

If you have a TSqlModel and you want to make a change to it, you have a…

Read more

0 comments, 196 reads

Posted in Ed Elliott's Sql Developer Blog on 26 April 2017

My SQL Server Development Team Maturity Levels

A teams maturity shows in its choice of tools.

I have seen quite a few different development teams in wildly different environments and the single fact that really stands out is that you can tell how good a team is by the tools that they use. It isn't always the…

Read more

0 comments, 1,202 reads

Posted in Ed Elliott's Sql Developer Blog on 24 April 2017

SQL Server Continuous Deployment "In a Box"

What is this?

Well if you read the name aloud "SQL Server Continuous Deployment in a box" then, if I have done my work correctly choosing the title for the blog, give a hint :)

what is the big idea?

There is really some great tooling for SQL Server -…

Read more

0 comments, 297 reads

Posted in Ed Elliott's Sql Developer Blog on 7 March 2017

ScriptDom parsing and NoViableAltExceptions

If you have ever tried to debug a program that used the TSql Script Dom to parse some T-SQL you will know that the process is extremely slow and this is due to the volume of NoViableAltExceptions (and others) that are thrown and then caught. Because these are first chance…

Read more

0 comments, 237 reads

Posted in Ed Elliott's Sql Developer Blog on 2 March 2017

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 and how the IgnoreWhitespace, IgnoreComments, IgnoreKeywordCasing and IgnoreSemiColonsBetweenStatements flags affected the comparison. To be fair I was only interested in IgnoreWhitespace but actually it turns out that those four are very closely related.

Read more

0 comments, 241 reads

Posted in Ed Elliott's Sql Developer Blog on 2 March 2017

SSDT Deploy / Publish Performance

Publishing dacpac's is a little bit of a pain when you have multiple databases, it can easily start to take minutes to hours to deploy changes depending on how many databases and the size of those databases. I wanted to understand more about the publish process and what we can…

Read more

0 comments, 247 reads

Posted in Ed Elliott's Sql Developer Blog on 1 March 2017

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 started then I would recommend it:

https://skillsmatter.com/skillscasts/9274-londondot-net-january-meetup

This was aimed at .net developers rather than DBA's so there isn't much talk about "why you should use…

Read more

0 comments, 260 reads

Posted in Ed Elliott's Sql Developer Blog on 10 February 2017

Devops without management buy in?

I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database but they had a number of issues, the main was that because management wasn't sold on the idea and the DBA's had complete control to push back on all and…

Read more

0 comments, 343 reads

Posted in Ed Elliott's Sql Developer Blog on 10 February 2017

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 different from my normal style as originally it was going to be published else but rest assured it is written by myself

What is refactoring?

In programming , the term ‘refactoring’ essentially…

Read more

0 comments, 541 reads

Posted in Ed Elliott's Sql Developer Blog on 27 September 2016

Database Deployments in Uncontrolled Environments

The ideal is to make a change and see that change deployed to production, in a perfect world we would be told to work on something, write the code + tests, deploy to a test environment, prove it works and deploy - this is the cycle time and the faster…

Read more

0 comments, 1,191 reads

Posted in Ed Elliott's Sql Developer Blog on 20 September 2016

Controlling a dacpac deployment

I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to deploy dacpac's. In particular I am talking about how to control the deployment, what tool is used to deploy the dacpac, what connection details are passed in, which of the…

Read more

0 comments, 339 reads

Posted in Ed Elliott's Sql Developer Blog on 21 August 2016

tSQLt Visual Studio Test Adapter

tSQLt Visual Studio Test Adapter

What is this?

This lets you use Visual Studio to run tSQLt tests easily. Visual Studio has a built in framework for finding and executing tests so that if you have tSQLt tests in an SSDT project for example, although this just requires you have…

Read more

0 comments, 1,581 reads

Posted in Ed Elliott's Sql Developer Blog on 17 August 2016

DacFxed - Powershell Nugetized DacFx wrapper

Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open a dacpac, compare to a database and either create a script or get the database to look the same as the dacpac but there are a couple of problems with…

Read more

0 comments, 448 reads

Posted in Ed Elliott's Sql Developer Blog on 2 August 2016

SQLCover v 0.2 - Bug fixes and Azure V12 Support

I have released a new version of SQLCover which is a code coverage tool for T-SQL (let's you identify where you need to focus when writing tests).

This includes a few minor fixes but also support for SQL Azure so if you run your test in a v12 database or…

Read more

0 comments, 410 reads

Posted in Ed Elliott's Sql Developer Blog on 5 May 2016

Where do you put your business logic? In stored procedures?

There seems to be two trains of thought and I think this is mainly down to who and where your developers are. The first is that a stored procedure or a function is a great place to put all the business logic that an application needs. The second is that…

Read more

0 comments, 3,802 reads

Posted in Ed Elliott's Sql Developer Blog on 5 May 2016

How do you audit automatically generated sql deployment scripts?

I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because of the restirctions put on them by the requirements for auditing and the ability to be able to demonstrate exactly what was deployed at what time.

When automating deployments it…

Read more

0 comments, 690 reads

Posted in Ed Elliott's Sql Developer Blog on 3 May 2016

Newer posts

Older posts