Matthew Skelton Database Version Control By placing under source control everything we need to describe any version of a database, we make it much easier... 24 March 2016 34 min read
Elizabeth Ayer The Comeback of Migrations-Based Deployments With database deployments, not all script-based processes are equal. Some use change scripts in a free-and-easy way, and some, which... 17 March 2016 11 min read
Matthew Skelton Database Lifecycle Management for ETL Systems Few databases are self-contained. They take data from other sources, and publish them to downstream consumers of data. These ETL... 16 March 2016 32 min read
Matthew Skelton Database Migrations: Modifying Existing Databases It should be simple to upgrade a database to a new version. It certainly can be, but if you need... 09 March 2016 34 min read
Matthew Skelton Issue Tracking for Databases Any database development project will be hard to manage without a system for reporting bugs in the code, anomalies and... 25 February 2016 20 min read
Grant Fritchey Better Ways to Build a Database The purpose of a database build is simple: prove that what you have in version control can successfully create a... 19 February 2016 40 min read
Peter Gerrard Jodie Beay and the Deployment of the Cross-Database Dependency When you use AdventureWorks as a practice database, have you ever looked at the code and thought 'what idiot did... 03 November 2015 13 min read
Sjors Takes Implementing Continuous Integration for Databases Continuous integration (CI) is becoming more and more common in application development. It ensures code and related resources are integrated... 02 November 2015 8 min read
Jason Crease Writing Build vNext tasks for Visual Studio Online Hosted TFS, now called Visual Studio Online (VSO), has a new way of writing build processes called Build vNext. Agent... 09 September 2015 9 min read
Frazier Kendrick Stumbling Towards Database Change Management The scale of change in the insurance and financial markets is such that there is little time for the application... 09 September 2015 22 min read
Edward Elliott Non-Breaking Online Database Deployments For an experienced database developer, the idea of doing non-breaking database deployments while the database is still online holds respect... 21 July 2015 11 min read
Tim Hidalgo Managing Test Data as a Database CI Component – Part 2 Once you're clear about what data the developers and testers need to be able to be effective, you have several... 28 May 2015 10 min read
Seb Rose What is Behaviour Driven (Database) Development? Behaviour Driven Development is not always clearly understood, and the term is particularly unfamiliar in database circles. Seb Rose introduces... 05 March 2015 16 min read
Tim Hidalgo Managing Test Data as a Database CI Component – Part 1 Constructing a test environment for your databases can be a difficult task at the best of times. Once you've actually... 03 February 2015 20 min read
Grant Fritchey Database Build Automation – The First Step to Continuous Integration So you're keen to take the first steps to the continuous integration of your database. You have to start by... 16 December 2014 10 min read
Karsten Kempe Who Broke the Build? Continuous Integration and automatic builds are fantastic tools for software teams, but only if developers take responsibility for their code.... 29 August 2014 15 min read
Greg Lucas Test-driven Database Development – Why Bother? Test-Driven Development is a practice that can bring many benefits, including better design, and less-buggy code, but is it relevant... 16 March 2012 12 min read
Blogs Phil Factor in Blogs Database Migration Scripts: Getting from place A to place B We’ll be looking at a typical database ‘migration’ script which uses an unusual technique to migrate existing ‘de-normalised’ data into... 28 February 2012 8 min read
Alex Kuznetsov Yet Another SQL Strategy for Versioned Data There is a popular design for a database that requires a built-in audit-trail of amendments and additions, where data is... 22 June 2011 11 min read
Database DevOps Troy Hunt in Database DevOps The 10 Commandments of Good Source Control Management Simple-Talk generally doesn't re-publish anything from another site, but Troy's popular blog post on the Ten Commandments of Source Control... 23 May 2011 19 min read