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

AdventureworksCI Step 5 Adding tSQLt to the solution

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, 1,334 reads

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

AdventureworksCI Step 4 Pushing to GitHub

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, 1,528 reads

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

Keep your environments in-sync and your upgrade scripts fresh

Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are a few things that we should bear in mind to ensure we do not break existing databases.

Why is it important?

When you upgrade an application you just compile and…

Read more

0 comments, 326 reads

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

Pre-Compare & Pre-Deployment Scripts to SSDT

When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the dacpac and database has been deployed. The process looks like:

  • 1. sqlpackage.exe compares dacpac to database
  • 2. sqlpackage.exe generates a deploy script
  • 3. sqlpackage.exe runs pre-deployment script
  • 4. sqlpackage.exe runs…

Read more

0 comments, 813 reads

Posted in Ed Elliott's Sql Developer Blog on 20 July 2015

WaitForSql (to start)

In the spirit of having apps that do just one thing I have put a really small .net app on github that tries to create a connection to a SQL Server database and just keeps retrying until it is available:

https://github.com/GoEddie/WaitForSQL

What? Huh?

If you have a CI build and…

Read more

0 comments, 389 reads

Posted in Ed Elliott's Sql Developer Blog on 17 July 2015

Layer a database into a SQL Server container

In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net) products to start an instance of SQL Server without having to install it: https://the.agilesql.club/Blog/Ed-Elliott/Containers/Run-SQL-Server-In-A...

In this post I am going to talk about images and how to layer…

Read more

0 comments, 1,030 reads

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

AdventureworksCI Step 3 Handling data with SSDT

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

Posted in Ed Elliott's Sql Developer Blog on 7 July 2015

Run SQL Server In A Container Today July 2015

Containers are one of the big things at the moment, Microsoft has recently announced that they will be bringing official support to Windows. While this is great news it is unlikely to be something most IT departments can use in the near term mainly because it takes time for everyone…

Read more

0 comments, 646 reads

Posted in Ed Elliott's Sql Developer Blog on 3 July 2015