Click here to monitor SSC

Ben Rees


Ben Rees

Continuous Delivery for Databases – a Pipe Dream?

12 comments

“I’m a DBA for a large healthcare firm here in the US. You’d have to put a gun to my head before I let my developers run automatic database deployments through to production without me checking the release first“. I had just explained our ideas for running continuous integration, automated testing and automated release processes […]

19 June 2014 7:39 am by
Ben Rees

Towards Database Continuous Delivery – What Next after Continuous Integration? A Checklist

0 comments

DATABASE LIFECYCLE MANAGEMENT PATTERNS & PRACTICES LIBRARY Stage 4: Release Management If you’ve been fortunate enough to get to the stage where you’ve implemented some sort of continuous integration process for your database updates, then hopefully you’re seeing the benefits of that investment – constant feedback on changes your devs are making, advanced warning of […]

3 June 2014 7:23 am by
Ben Rees

How Mature is Your Database Change Management Process?

0 comments

Database Delivery Patterns & Practices Further Reading Organization and team processes How do you get your database schema changes live, on to your production system? As your team of developers and DBAs are working on the changes to the database to support your business-critical applications, how do these updates wend their way through from dev […]

12 May 2014 8:06 am by
Ben Rees

Automating Deployment of Database Projects with Red Gate Tools

0 comments

Update 15/10/2014 This article is now out of date, given the product development work over the last few months. In particular: We now have a TFS Build Template that simplifies the setup of Red Gate tools on TFS considerably. This can be downloaded as part of the SQL Automation Pack - http://www.red-gate.com/products/sql-development/sql-automation-pack/. Red Gate no longer […]

11 February 2014 8:26 am by
Ben Rees

Continuous Integration for SQL Server Part III – Deployment

0 comments

In this article, I’ll describe the next stage in implementing a full Continuous Integration and Deployment process for SQL Server databases: Deployment. This post follows on directly from my previous post on Continuous Integration and testing for SQL Server. Following the steps in this previous post is a pre-requisite to following the steps below. Deployment […]

10 July 2013 9:51 am by
Ben Rees

Continuous Integration for SQL Server Part II – Integration Testing

0 comments

My previous post, on setting up Continuous Integration for SQL Server databases using GitHub, Bamboo and Red Gate’s tools, covered the first two parts of a simple Database Continuous Delivery process: Putting your database in to a source control system, and, Running a continuous integration process, each time changes are checked in. However there is, […]

25 June 2013 10:56 am by
Ben Rees

Continuous Integration for SQL Server using Red Gate Tools, Atlassian Bamboo and GitHub

5 comments

Update 27/01/2015 This blog post is now out of date, as there have been some changes to the Red Gate products for database lifecycle management (DLM) since the post was first published. In particular, we now have a new version of Red Gate SQL CI which makes it easier to set up continuous integration to […]

21 March 2013 1:46 pm by