THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

Database Development Infrastructure

This blog has moved! You can find this content at the following new location:

Published Thursday, November 18, 2010 12:00 PM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Shannon Lowder said:

I suppose I'm lucky, I'm moving to virtualize several of our web servers (that are extremely under utilized), and as a result, several servers are now without a purpose.  I moved quickly to bring all those servers to our development location so I could set up a development and testing environment!  It was the easiest sale to management I ever made.

Funny how free is the acceptable price of testing, yet the substantial (and seemingly invisible) costs of not-testing is ok.

November 18, 2010 1:10 PM

Tracy McKibben said:

This is fine, providing none of your production data is considered sensitive.  In our environment, due to auditory, regulatory, and government restrictions, developers CANNOT have access to real, live production data, containing credit card numbers, SSNs, and other sensitive data.  We do maintain seperate development, QA, and UAT environments, and all DB object changes are promoted upwards through those environments, but no data is exchanged between them.

November 18, 2010 1:51 PM

andyleonard said:

Hi Tracy,

  That's a great point and I wasn't explicit in my post about this: I said nothing about copying the data, merely duplicating the environment. There are several tools available to obfuscate the existing data or generate dummy data.

  Thanks for pointing that out - you're absolutely correct.


November 18, 2010 2:09 PM

Greg Lucas said:

"I believe there are two categories for database infrastructures: Those who have a test environment and those who will"

I like that, gave me a smile on conld english Friday morning.  Sailors have a similar saying, there are those sailors who have run aground, and liars

November 19, 2010 3:21 AM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement