Recently Eric Hanson generated more than a dozen short demo screencasts highlighting the best new features in SQL Server 2008 specific to data warehousing. A couple of them are pertinent to earlier versions of SQL Server as well. If you can only view a few, try to watch the configuration ones and the pair on compression. Compression has been a favorite topic of DW customers. They all range from three to eight minutes. I'm posting them over the next couple of days as I encode them.
Channel 9 videos tagged with Data Warehousing
What other demos would you like to see? Email me, or post a comment here or on Channel 9.