I spent the last two evenings reading one of the latest SQL Server 2005 books - Programming Microsoft SQL Server 2005. The book was written by Andrew Brust and one of my closest friends in the industry, one and only Stephen Forte (if you know Stephen, you know what I am talking about). The book is really very good and I highly recommend getting it. It has great coverage of major 2005 features, especially the new stuff and useful real-life scenario code samples. I will be using the Business Intelligence part of the book a lot for my own learning since this is the area I haven't worked much with, but we see an increasing interest and demand from our customers.
Please note that I may be a little biased with my recommendation since I was one the technical reviewers for the book. While I really have no time, patience, discipline or desire to write a book, I did enjoy providing feedback and it was nice to see that some of my suggestions and code samples made it into the book. If any of you are working on a SQL book and need a tech reviewer, feel free to get in touch with me and I'll be glad to help out.