2/25/2012 3:29:00 PM
Amit Bansal -
I had the privilege of attending the SQL BareMetal 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
More pictures are here: http://www.facebook.com/media/set/?set=a.10150625255679347.403726.525339346&type=3
If you liked this post, do like us on FaceBook at http://www.FaceBook.com/SQLServerGeeks
Have a SQL Server question? Join the fastest growing SQL Server facebook group at: http://www.facebook.com/groups/458103987564477/
Regards, Amit Bansal
http://www.twitter.com/A_Bansal http://www.twitter.com/SQLServerGeeks http://www.amitbansal.net/ Visit my FaceBook page at http://www.facebook.com/AmitRSBansal Contribute on SQLServerGeeks.com: visit http://www.sqlservergeeks.com/default-category/write-for-us
Amit Bansal (Member since: 3/12/2011 4:59:54 PM)
Follow Amit at Twitter @A_Bansal : Amit Bansal is the CTO of eDominer Systems & Peopleware India. He is a consultant, trainer, writer, speaker & evangelist on SQL Server & Business Intelligence. A seasoned speaker; he speaks at major summits and conferences of Microsoft worldwide including TechED, MCT Summits, MSDN & TechNet conferences. Over the last 8 years, he has consulted, trained & mentored more than 6000 IT professionals on SQL Server & Business Intelligence and worked with top notch blue chip companies worldwide including Microsoft, Infosys, Wipro, RBS, HCL, HP, Siemens, IBM, Accenture, etc. He has delivered more than 400 workshops on SQL Server & Business Intelligence. Apart from holding many Microsoft credentials, he is also a Microsoft Most Valuable Professional (MVP) awardee on SQL Server. He is also one of the first Microsoft Certified Trainer in India. Amit has worked with Microsoft in India and US as a Subject Matter Expert in various capacities participating in OD sessions, technical reviewing, etc. He is also a very active community lead in Asia Pacific. Visit www.amitbansal.net to know more. Subscribe to Amit’s blog and be a member of his technical forum at www.SQLServerGeeks.com - an exclusive SQL Server portal. Visit www.peoplewareindia.com for Corporate Training solutions.
FaceBook – http://www.facebook.com/people/Amit-Bansal/525339346
LinkedIn – http://www.linkedin.com/pub/amit-bansal/7/121/755
View Amit Bansal 's profile
Great Sir ...
Leave a comment