Before I went on vacation, I mentioned I was downloading some of the MCM videos from Technet.I had grabbed 4 or 5 before I left, dropping the MP3s on my iPhone, and I listened to a few of them on the drive to Steamboat Springs.
That worked out so well, while I was on vacation, I tweeted that I was downloading more MP3s for the ride home, but Aaron Nelson (blog | @sqlvariant) sent me a script he was working on to automatically download them. I finally got around to trying it when I returned to get the video formats of the videos (some are demos) and after a little mucking around with paths, I got it to work.
It's a great script that runs from Windows Powershell, and you can get it from Aaron's blog. Even if you don't want to take the MCM test, watch the videos. Lots to learn in there.
Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest