SQL Server 2005 Developer Guide

Author: He Yujie
Publisher:
Publish Date: 2007-01-01
Features: This book is written by two experts in the SQL Server field, combining clear descriptions and numerous examples to comprehensively introduce new features in SQL Server 2005 that are useful for developers. It also provides valuable best practices and guidance to help developers quickly master these new features and choose the appropriate features to develop next-generation database applications at the right time. The book consists of 17 chapters, with content entirely based on the official version of SQL Server 2005 and thoroughly discussed and selected, making it highly valuable for SQL Server developers.
Few technologies are as anticipated as SQL Server 2005. Now, two experts in the SQL Server field have brought us an authoritative reference guide, accurate, rich in content, and filled with numerous examples. SQL Server 2005 Developer Guide explains details not covered in Microsoft's reference documentation, white papers, and online documentation, guiding developers on how to fully leverage the key innovative features of SQL Server 2005. Since the earliest alpha release of SQL Server 2005, the authors have extensively engaged with SQL Server developers, sharing their experiences and techniques, and listening to their feedback. The book practically introduces the new data model of SQL Server 2005, built-in .NET hosting, enhanced programmability, compliance with SQL:1999, and more. Almost every key concept is illustrated with example code. These codes have been fully updated and tested according to the final released version of the product.
Key Topics:
· Hosting SQL Server 2005 as a .NET runtime: Further extending the server's capabilities while enhancing security, reliability, and performance
· Writing procedures, functions, triggers, and types in .NET languages
· Leveraging enhanced T-SQL features for more robust error handling, more efficient queries, and more readable syntax
· Implementing local SQL Server 2005 Web services
· Developing efficient and robust client applications for SQL Server 2005 using ADO.NET, classic ADO, and other APIs
· Fully utilizing user-defined types (UDT), query notifications, upgradeable transactions, and multiple result sets
· Building integrated applications using SQL Management Objects (SMO), SQL Service Broker, and SQL Server Notification Services
This book is written by two experts in the SQL Server field, combining clear descriptions and numerous examples to comprehensively introduce new features in SQL Server 2005 that are useful for developers. It also provides valuable best practices and guidance to help developers quickly master these new features and choose the appropriate features to develop next-generation database applications at the right time. The book consists of 17 chapters, with content entirely based on the official version of SQL Server 2005 and thoroughly discussed and selected, making it highly valuable for SQL Server developers.