SQL Server 2012 Bare Metal workshop at Redmond in Jan 2012 – My experience

Hi Friends,

I had the privilege of attending the SQL Server 2012 Bare Metal workshop at Redmond in last week of Jan 2012 hosted by Dandy Weyn from Microsoft.

The workshop was primarily designed for trainers and consultants who frequently deliver workshops around SQL Server technologies. One of the challenges trainers/consultants face is to set up complex Hyper-V environment to demo SQL Server HA or BI technologies, that too with frequently expiring images due to the usage of evaluation editions. That was one of the most important things I learnt there; to ‘quickly’ create as many VMs as you want by using Power Shell scripting; 100% automation.

We kicked off by creating the base virtual machine using PowerShell scripting. PowerShell scripts created & configured a VM with full installation of Windows Server 2008 R2. We intended to use this as a BASE VM followed by creating differential VMs. We also did an automated setup of Windows Core (this one was just for practice). We then injected another VHD into the base that had all the software, tools, Service Packs, patches, feature packs, SharePoint, Office, PowerPivot, etc needed to do the entire set of labs. This again was done using PowerShell scripting. Infact, Dandy had created a PowerShell script to download all the required software.

Next, was the fun part, with just some ps files, we spun off about 5 VMs in no time – all installing Windows Server, configuring FC feature, followed by SQL installation, network configuration, etc. And this was done so quickly – in no time the entire class was installing more than 300+ instances of SQL Server. This was followed by some manual configurations, etc that was a prerequisite to do the Denali labs.

Then we carried on with Denali labs which was a standard stuff. But more importantly, the entire set of labs did require some troubleshooting, etc, probably because of some errors/typos in the labs, etc, since the labs did not pass full edit at MS.

We had many MVPs and MCMs in the class including Brent Ozar, Allen White, Kalen Delaney, Bob, Denny Cherry, Jeremiah Peschka, Grant Fritchey, Kendra Little, Edwin Sarmiento, Ross Mistry, Ron Talmage, Robert Davis, Dean Vitner, Aaron Nelson, Allan Hirt, Karen Lopez, Pawel Potasinski, Jason Strate, Rob Farley, Mattias Lind, Lynn Langit, just to name of few. We had a few presentations from the product team during the week and MVPs/MCMs also presented a few stuff in their own area of expertise.

Overall it was a great experience – the class made it worth, even more. Kudos to Dandy, he put great effort and packaged the stuff very nicely. And yes, I did realize the power of PowerShell scripting 🙂 – Just wanted to share this little bit with you all, some pics that I took 🙂 – met many old friends and made many new friends 🙂


With Robert Davis



with Ben Miller


With Brent Ozar, Jeremiah Peschka & Kendra Little


Party after the workshop…


with Allen White


with Kalen




About Amit Bansal

Amit Bansal is always brainstorming around SQL Server. Despite working with SQL since 1997, he is amazed that he keeps learning new things every single day. SQL Server is AB's first love, and his wife does not mind that. He tries to share as much and spreads the SQL goodness. Internals and Performance Tuning excites him, and also gives him sleepless nights at times, simply because he is not a genius, but quite a hard worker and does not give up. It has been a long and exciting journey since 1997, you can read here: http://sqlmaestros.com/amit-bansal/ He is on Twitter: https://www.twitter.com/A_Bansal

View all posts by Amit Bansal →

One Comment on “SQL Server 2012 Bare Metal workshop at Redmond in Jan 2012 – My experience”

Leave a Reply

Your email address will not be published.