If you are working with BI, check this aggregated information page on Channel 9 out - it's got references, links to sample code, screen casts and more - enjoy!

Channel9 Wiki: SQLServer