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

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

Posted in Ed Elliott's Sql Developer Blog on 22 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, 6 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,677 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, 6 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, 6 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, 384 reads

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

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

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

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

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

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

Posted in Ed Elliott's Sql Developer Blog on 8 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 them together…

Read more

0 comments, 7 reads

Posted in Ed Elliott's Sql Developer Blog on 8 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 them together…

Read more

0 comments, 7 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, 634 reads

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

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

Older posts