Click here to monitor SSC

Jonathan Hickford


Jonathan Hickford

Tackling the problem of database version drift

7 comments

It is known as ‘database version drift’ or ‘database version creep’. For the best of reasons, the version of the metadata in production no longer matches what is in source control. Usually, the most serious consequences would be the loss of the changes that were made to vitalize a moribund production system, but it always […]

23 October 2014 2:33 pm by
Jonathan Hickford

Setting up continuous integration for your database with Red Gate and AppVeyor

0 comments

In this post I’ll walk through setting up a hosted continuous integration (CI) system for your SQL Server database. We’ll be using AppVeyor, a cloud hosted CI system with a focus on easy setup for .NET development. On AppVeyor we’ll use Redgate’s SQL CI utility (part of the DLM Automation Suite ) which makes it easy […]

8 July 2014 4:44 pm by
Jonathan Hickford

How to Automate your Database Documentation

2 comments

In my previous post, “Automating Deployments with SQL Compare command line” I looked at how teams can automate the deployment and post deployment validation of SQL Server databases using the command line versions of Red Gate tools. In this post I’m looking at another use for the command line tools, namely using them to generate […]

30 May 2014 11:26 am by
Jonathan Hickford

Automating deployments with the SQL Compare command line

0 comments

In my previous article, “Five Tips to Get Your Organisation Releasing Software Frequently” I looked at how teams can automate processes to speed up release frequency. In this post, I’m looking specifically at automating deployments using the SQL Compare command line. SQL Compare compares SQL Server schemas and deploys the differences. It works very effectively […]

7 May 2014 2:03 pm by