-->
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: April 2015

Approaches to deploying Sql Server database code

When you deploy your Sql Server code, there are two approaches, there is the manual way and the automated "compare & deploy" way.

Manual

The manual way is where you track what changes you have made and when you want to release, build a script or set of scripts which…

Read more

0 comments, 463 reads

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

BIML is better even for simple packages

BIML, you either love it or hate it - either you use it to totally generate hundreds of packages or a bucket load of data flow components all at the push of a button or you are perfectly happy using the SSIS editor, you can see how the package is…

Read more

0 comments, 7,216 reads

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

Sql Saturday Talk

I had the honour of talking at the excellent Sql Saturday Exeter this morning and wanted to share my slides and say thanks to the organisers, sponsors and everyone who came along to my session - I really enjoyed it and I hope you did to.

The slides are available:

Read more

0 comments, 386 reads

Posted in Ed Elliott's Sql Developer Blog on 25 April 2015

What Permissions do I need to generate a deploy script with SSDT?

It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or still automatically but at a later date plus you may not want to give the user or process that does this sysadmin permissions just so that it can generate a…

Read more

0 comments, 380 reads

Posted in Ed Elliott's Sql Developer Blog on 21 April 2015

HOWTO-Get-T-SQL-Into-SSDT

Ok so you have created an SSDT project and are currently congratulating yourself on how awesome and cool you are but then you realise that your project is like an empty void, completely devoid of any emotion, love or joy - there is no schema and code in the project…

Read more

0 comments, 450 reads

Posted in Ed Elliott's Sql Developer Blog on 8 April 2015

Generating tSQLt tests from a dacpac

Generating tSQLt tests from a dacpac

I use SSDT and tSQLt in my work and I am always interested in productivity tools to help speed up development and make it more streamlined, if there is something that can help us develop better or faster then we should use it.

I…

Read more

0 comments, 830 reads

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

SSDT Myths #1 - SSDT only works with TFS

I was reading a white paper from a Sql Server tools vendor about how to integrate their tools with SSDT and while it was very interesting there were a couple of inaccuracies and I wanted to clear one of them up and also to help people understand that although SSDT…

Read more

0 comments, 369 reads

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