This book is not much about SQL, but more about Microsoft’s tools for data ‘mining’, ‘warehousing’, OLAP, and such. Learn about the ‘cube’ which can contain denormalized data. The tools provide much more than report formatting. This book is big and heavy, at 750 pages.
Microsoft Office PerformancePoint server 2007 / Elaine Andersen, Wiley, 2008
This book is for the business executive who needs a Business Intelligence solution considerably more powerful than an excel spreadsheet. There is also some info for the admin, but only 15 pages out of 400.
Data mining with Microsoft SQL server 2008 / Jamie MacLennan, Wiley, 2009
Here is an introduction to Microsoft’s business intelligence tools. Microsoft has provided many features in their product, and this book covers them in 600 pages. This is not a programmer’s book, and there is not much about SQL.