SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Change Management

By Steve Jones,

Hurry up and wait.

In a couple of the large enterprises I've worked in, that might have been the IT motto. It seemed as though the internal developers were always under pressure to get applications finished as soon as possible. However we often found that when applications were finished, there would be a delay in deploying the new code to the production servers, usually because of a strict change control process that required documentation and testing of the changes on related systems. In many smaller companies I've worked in, we had no change control process at all and could deploy updates at any time. 

I'm not sure which of those two systems I prefer. In general, I prefer to have some change management process to ensure that I can easily determine what changes were made at any time. However I've found that any change management quickly becomes a bottleneck devoid of common sense and full of bureaucratic nonsense. This Friday, I decided to ask a question about change management, but not about your opinion of whether it's good or not. The question this week is: 

Do you follow a change control process 90+% of the time?

By this question, I mean is change control a habit, an ingrained sense of the way you work and deploy updates to a live environment. I'm not asking if you have a formal process, if it's a team process, or anything about the details, but rather do you actually follow some methodology to track and manage changes?

I'd like to think most of us would, if for no other reason than to answer the common "what changed?" question that always comes up when something breaks. However I'm curious to see the results.

Steve Jones

The Voice of the DBA Podcasts

Everyday Jones

We are still having hosting issues with the podcasts. We hope to resolve this and be back to releasing the podcast versions of the editorial next week.

The podcast feeds are available at sqlservercentral.mevio.com. You can also follow Steve Jones on Twitter:

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com. They have a great version of Message in a Bottle if you want to check it out.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

Total article views: 227 | Views in the last 30 days: 1
Related Articles

Manage, Control, store changes done to SQL Server

Is there any software or a process that can be used to manage and control changes to SQL server?


Change Management

This article looks at change management from the perspective of the DBA, including how to use source...


Podcast Upgrades

A minor change for the podcasts next week. I got my wireless microphone, and I'm working with it a b...


Get RAAS WorkFlow Manager For Free

For a limited time Highwire Development is offering free site licenses for their RAAS Workflow Manag...


DBAs Change Management Best Practice.

DBAs Change Control Best Practice

friday poll