there are a lot of books on the market. For a general overview about the concepts I would suggest to read the books from Kimball. There is also a special book for SQL Server 2005 on the market.
There are a lots of Webcasts available from Microsoft about their data warehouse technologies. You could check msdn or search by google.