I received my copy of A First Look at SQL Server 2005 for Developers yesterday (written by Bob Beauchemin, Niels Berglund, Dan Sullivan, three of the most knowledgable SQL Server guys on the planet!), and I can't put the book down! This is an excellent resource for all SQL Server developers (the T-SQL variety) as well as all .NET developers who interact in some way with SQL Server. There is something for everyone in this book.
My favorite chapter (so far) is on CLR hosting, the internals of what allows the new SQL Server (aka Yukon) to host managed code assemblies. I will be talking about secure hosting at WIN-DEV, and this chapter provides a great inside look at the changes the CLR team and SQL Server team had to make in order for hosting in .NET 2.0 to work much better than before.
As soon as I am done with the book, I will post a review. In the meantime, you owe yourself a look at this great resource.