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

The Virtual Lab

By Steve Jones,

Over a decade ago, when the startup company that I worked for went bankrupt, I received a few servers and some other hardware as a partial severance. At the time it seemed like a good idea, and it was nice to have a few spare servers on hand. I would later use some of that hardware to work on SQLServerCentral. My wife, however, wasn't thrilled since spare hardware, even powerful hardware, doesn't buy groceries.

These days the pace of technology change is high. SQL Server is a stable platform that many companies might install and use for a decade, but it seems we have new features to learn every 18-24 months as new versions are released. I think more and more of us have to understand a wider variety of features and platforms all the time, even if we use them sparingly. For many of us, that means some sort of lab if we want to gain any sort of skill with the products.

One of the best things about virtualization, in my mind, is that it enables the average professional working with technology to build a huge lab for a fraction of the cost that it would have cost a decade ago. A relatively modestly priced laptop, something in the $600-800 range, will run most any technology you need, including Windows 2008 R2 Data Center in a VM. If you wonder how you can do this on a budget, check out Denny Cherry's article on building a lab with VMWare or the Virtual Server series on SSC. You could do the same thing with Hyper-V or Virtual Box, and a subscription to MSDN or TechNet, something many of us get from our employers. If you don't have access to those programs, there are evaluation editions of almost all software you can use.

With an external hard drive, you could even have a portable lab that you can take with you anywhere.

Steve Jones

The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there. Overall RSS Feed: or now on iTunes!

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.

You can also follow Steve Jones on Twitter:

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

Give us all the features

The mix of hardware and feature limits in SQL Server varies by edition. Steve Jones thinks it should...


SQL Server Podcasts

Great news, I have decided to do some podcasts on the fundamentals of SQL Server, my aim is to help....


Development server configuration(hardware)

Development server configuration(hardware)


Server Hardware Sizing

Guidelines for server hardware sizing


SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligen...