[Originally written for the review column in .NET Developers Journal]
Written by Bob Beauchemin, Niels Berglund, Dan Sullivan
Addison-Wesley, ISBN 0-321-18059-3, $44.99
Databases are at the core of most software projects these days and there is a fair amount of competition between software vendors for a bigger share of a lucrative market. However, it would be fair to say that only DBAs really know what their database servers are capable of and maybe only half of them really everything that their software can do. One of the biggest arguments for this First Look At SQL Server 2005 book then is as a prospectus for all the developer-related features and functional nooks and crannies that the next incarnation of SQL Server (codename ‘Yukon’) will contain.
Split over seventeen chapters and two appendices, this very thorough book covers the ins and outs of four main topics - SQL Server as a CLR host, XML, enhancements to the existing features of SQL Server 2000 and notification services - that should be of interest to developers looking forward to a world of Whidbey and Yukon. Topics such as security and XQuery aren't exhaustive - they'd each take up a book on their own - but all the main points within the context of this book are covered. Indeed, with the exception of Chapter 14, which covers a feature since removed from SQL Server 2005 but is well written anyway, each chapter is clean, concise and packed with useful information.
The author team of three have produced a book that at times goes as deep into detail as Don Box’s Essential .NET does while treating ‘lighter’ topics such as Microsoft’s new enhancements to T-SQL, in no less detail but in an easier to read style. The main focus of this book are the new opportunities for developers to utilize Yukon but administrators can also take a lot away from this book having been made aware of areas that developers may focus on. In all, this is an excellent preview book on developing with SQL Server 2005 in mind and should be kept around until the revised version comes out for the actual release of this new database.
Buy it at Amazon UK