There have been some major changes to the Microsoft Certified Master (MCM) SQL 2008 certification (you can see more details on this at http://www.microsoft.com/learning/en/us/certification/master-sql-path.aspx)
What I consider a HUGE plus alongside the changes is the posting of MCM readiness videos (recorded by acknowledged experts in the field). These videos are free for download and have been posted out on Technet.
There has been a lot of talk on Twitter about simple ways to download all of the videos. Today Aaron Nelson (blog|twitter) gave a presentation called “Powershell Grab Bag” as a part of the Powershell Virtual Chapter. In this presentation he provided a script to download all the PASS Summit videos (this will only work for the Summit attendees as you have to have a login, just think of it as encouragement to attend next year). Aaron’s script did the job awesomely and I was able to download 165 Summit videos easily just by kicking off the Powershell script.
I reworked Aaron’s script for my own nefarious purposes and with his kind permission I give you a process to download all the MCM videos.
It will create a new directory C:\Temp\MCMVids and download all the current videos. One thing you might want to change in the script is:
$url = $File.Zipped
Depending upon what you want to download you can change Zipped to Zune, WMV or MP3 to download in that format.
The only downside is that the MCMList needs to be manually maintained. This isn’t a lovely elegant solution, but it does work (I used it to download videos today).
As more MCM readiness videos get uploaded I will update the csv file so that it’s always current.
If you decide to use this please let me know how it works for you, also if you want me to add the other video/audio formats let me know and I’ll update the scripts accordingly.
An updated version of the CSV has been uploaded containing links to the remaining videos.