I have SQL experience with OS/400; Cognos; MS Query. I now wish to learn SQL Server initially for ETL roles then for management reporting.

Currently I have installed SQL Server 2008 Enterprise and the AdventureWorks db's in the last 48 hours. I've used Management Studio and Reporting Studio briefly and I think that those are the core apps I need to learn to carry out the roles I will want to do.

I'm very happy working through a book page by page to understand the features and carry them out but the question is which is the book to buy. Does anyone have any recommdations please?