I was looking over the Microsoft Virtual Academy recently, and went through one of the courses they have on SQL Server for the private cloud. I was curious how this solution is being both implemented and presented. It was interesting, and I learned a few things, including the fact that Microsoft is looking to build self-service into this idea of a private cloud. Users can build a virtual machine from a template, with Windows, SQL Server, and more already setup. They receive a SQL Server they can use as long as they like, and can delete it when they are done with it.
There are a few problems here, and they are similar problems that we've seen in the past as we pushed out more capabilities to individual users. The first one is that allowing people to create their own SQL Server instances can be problematic as they don't do a good job of setting up maintenance. SQL Server is easy to set up, but a little more complicated to manage over time. I suppose templates could potentially have backups and maintenance built in, but if you do this with any scale, you might end up with storage and space issues as well. There's only so much automation can do with limited resources, and I could see this ending up causing more infrastructure problems over time for IT staffs.
The second issue is that people just don't manage data well. How many people would delete a virtual machine without a final backup? How many people would create machines, load data, and then forget they had data out there? Apart from security concerns, there are likely to be efficiency concerns. How many people might create their own database server for financial data, even though the person in the next office might have already done the same thing? How many reconciliation problems will be brought to the DBA when people load different data sets into their servers, run reports, and then try to compare the results?
I think IT self-service is a good idea in many ways, but it's not the answer for all problems, and without some controls, I can see it easily causing as many issues as it solves.
Steve Jones
The Voice of the DBA Podcasts
We publish three versions of the podcast each day for you to enjoy.
- Watch the Windows Media Podcast - 25.7MB WMV
- Watch the iPod Video Podcast - 20.5MB MP4
- Watch the MP3 Audio Podcast - 4.1MB MP3
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:
