One of my teammates Lynn Langit, just finished a new book on SQL. Very cool stuff Lynn! This book covers SSAS (OLAP cubes and Data Mining Structures), SSIS, SSRS and more. The target audience is .NET and database developers.
Learn more about the book from Lynn's post here:
The book will be available around September/October 2008 but you can pre-order now at Barnes and Noble: