Posts by
Steve Jones

23 October 2015

23 October 2015

DLM S4 – Release Management

Deploying database changes to new environments is a very stressful activity. Many organizations and their employees dread migrating changes to a production database because of the potential for problems or downtime. There are ways to minimize the potential issues and build more reliable deployment processes. In fact, many organizations do this, but they do... Read more

19 October 2015

19 October 2015

DLM S3 – Continuous Integration

 In this post, we take a big step forward in engineering the database development process by looking at Continuous Integration (CI) for your database and the characteristics of a software pipeline that begins to implement a repeatable process. This is the S3 stage, named for, and characterized by, the use of CI. S3 –... Read more

16 October 2015

16 October 2015

DLM S2 – Automated Version Control

 In my last post, I looked at the first stage of our maturity model, the Manual level. In this post we move to the S2 level, which is characterized by the use of a formal Version Control System (VCS) and process. S2 – Automated Version Control Many software development organizations have implemented a VCS... Read more

12 October 2015

12 October 2015

DLM S1 – The manual stage

At Redgate Software, we’ve been trying to build tools that help developers work with software better. One of our areas of focus in the last few years has been streamlining database development and deployment. To help customers migrate to a smoother workflow and a better engineered software development pipeline, we’ve built our own maturity... Read more

8 October 2015

8 October 2015

An overview of Database Lifecycle Management

One of the ways in which many software development teams have tried to improve the quality of their output is by examining what has worked in other organizations and projects in the past. They look to experiment with new techniques and ideas, and implement those items that work. This practice has allowed Agile, Scrum,... Read more

23 June 2015

23 June 2015

Quick extended properties with SQL Prompt

I’ve been experimenting with Extended Properties, and I found myself slightly annoyed by the syntax of adding and updating Extended Properties. I decided to take advantage of SQL Prompt to store the commonly used code for adding and updating properties. Adding Properties I’m a big fan of naming the snippets the first thing that comes to... Read more

28 May 2015

28 May 2015

DLM training workshops

As I’ve been speaking and training people on Database Lifecycle Management (DLM), I’ve learned one thing. Trying to implement version control, and Continuous Integration (CI), and automated releases of code is hard. The concept is simple, but all of the various processes, tools, and links that need to be connected can be hard. I’ve... Read more