http://technet.microsoft.com/en-us/magazine/cc434693.aspx

It covers some of the new features in SQL 2008 w.r.t. Data Warehousing.

Conor Cunningham