Books: Jump-Start Development With SQL Server 2005
A First Look at Microsoft SQL Server 2005 for Developers gives you a well-informed and grounded understanding of the new and advanced features in SQL Server 2005.
After many years, Microsoft is finally going to release a new version of SQL Server. SQL Server 2005 encompasses an explosion of capabilities, choices, and technologies that will engage and task the application developer throughout this decade like never before. Of course, incorporating these new technologies will require a well-informed and grounded understanding of the features and architecture. Fortunately, Bob Beauchemin, Niels Berglund, and Dan Sullivan, have written A First Look at SQL Server 2005 for Developers to help.
The enterprise application developer's bread-and-butter projects comprise integration of databases with either user or service interaction of data. The .NET integration, Web services, and service broker features in this new release of SQL Server has caused the database to evolve from a single tier in a multitier architecture to an "any tier, any time" system. The authors provide comprehensive coverage of the most important aspects of SQL Server 2005 and the ones in which developers will be most interested.
Topics include extending SQL Server using the .NET Common Language Runtime, connecting code internally within the database, user-defined types, language enhancements, ObjectSpaces, and Web services integration.
Of particular note are the discussions on enhanced security, including schemas. The XML data type and XQuery coverage is exceptional. If you're interested in getting an understanding of the integration of Web services or the Service Broker architecture, then this book is well worth your time.
With deft explanations and discourse, the authors provide extensive coverage of new, relevant features. Source code is available for download. However, note that this is not a "how-to" book for the new developer. But for advanced programmers who want to develop for SQL Server 2005, this book should be a cornerstone of their library.
A First Look at Microsoft SQL Server 2005 for Developers
by Bob Beauchemin, Niels Berglund, and Dan Sullivan
Quick Facts: This book is for experienced developers interested in new and advanced features in SQL Server 2005.
Pros: In-depth discussion and examples of new features and innovations in SQL Server 2005.
Cons: Requires strong understanding of databases, XML, object-oriented concepts, and .NET technologies.