Data Warehouse Creation
I would recommend Building a Data Warehouse With Examples in SQL Server by Vincent Rainardi, as this covers SQL Server specifics.  The Data Warehouse Toolkit is also an excellent and practical guide, but isn't platform specific.