Loading Microsoft Connect Items To A Database–Intro
Wednesday, January 5, 2011 at 8:39PM Are you familiar with Microsoft Connect? It’s one of the ways that Microsoft solicits feedback from the community at large. In Connect you can submit bug reports and provide suggestions on a great many products including SQL Server.
Microsoft teams read and provide feedback on submitted items and frequently the bug-fixes that you find in Cumulative Updates and Service Packs come about thanks to the information provided on this site. I heartily encourage you to sign up and start submitting items yourself.
A few weeks ago Aaron Nelson (blog|twitter) contacted me wondering if I’d help with some data collection. The conversation morphed into one of those “hey what if…” situations. Upshot was that I worked on pulling data out of Connect and into a database. This data is now used being used over in one of the amazing Lobsterpot Pivot collections.
This data load is accomplished using Powershell. I’m going to break this down into four parts:
- Intro
- Part 1 – Database & Powershell setup
- Part 2 – Parsing the RSS & loading the data
- Part 3 – Keeping the data current
- Part 4 – Loading old data
Stay tuned for fun and goodness.
Reader Comments