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

Download SSMS, SSDT or SSDT-BI

It is a constant source of frustration for some people that it is hard to download SSDT or SSDT-BI or you download the wrong thing.

This is an example of some frustration: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c82354d0-2f88-4...

Anyway, this is now sorted as there is a single page to download SSMS or SSDT:

https://msdn.microsoft.com/en-us/library/mt238365.aspx?f=255&MSPPError=-...

Read more

0 comments, 943 reads

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

Why does sqlpackage.exe not compare after the pre deployment script has run?

It isn't a Pre compare script

When you use SSDT to deploy your dacpac, a pre deployment script lets you run some T-SQL scripts before the script which brings your database up to date with your dacpac.

The important thing to note is that the process is:

  • sqlpackage compares the…

Read more

0 comments, 643 reads

Posted in Ed Elliott's Sql Developer Blog on 24 June 2015

AdventureWorksCI Step 2 From MDF to Dot Sql Files

This is part of a series on how to take the Adventureworks database and bring it in line with modern standards. How do we put a legacy SQL Server database into source control? What issues do we face and how hard is it? Then how do we build a continuous…

Read more

0 comments, 702 reads

Posted in Ed Elliott's Sql Developer Blog on 22 June 2015

AdventureWorksCI Step 1 planning

This is part of a series on how to take the Adventureworks database and bring it inline with modern standards. How do we put a legacy SQL Server database into source control? What issues do we face and how hard is it? Then how do we build a continuous integration…

Read more

0 comments, 1,199 reads

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

A reference implementation of a continuous integration pipeline for legacy SQL Server databases

What am I doing?

Creating a publically available version of the adventureworks 2012 oltp database but by putting it under source control, implementing unit tests and improving the design and code to fit modern development guidelines.

Why?

There are two aims, firstly to show how to take an existing database…

Read more

0 comments, 408 reads

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

Why is SSDT so slow?

I see the same question again and again "I am using SSDT but it takes a long time to publish changes, how do I make it faster?" or the ever useful "SSDT is too slow".

Anyone who has used SSDT knows that doing a publish can take time, how much…

Read more

0 comments, 4,835 reads

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