SQL Server 2005 is next generation of SQL Server database and represents a massive leap forward for SQL Server developers in terms of programming options, productivity, database management and analysis. This book will take a deep look at the full range of SQL Server enhancements that will give meaningful and relevant examples that show not just how these new features work, but also how to architect their applications in order to exploit the new features most effectively.

This book is all about getting developers working on their own SQL Server 2005 solutions as quickly and painlessly as possible. Some of the core topics covered in the book are: Enhancements to database programmability features and languages, such as ADO.NET, XML, .NET assemblies, and T-SQL; New Servers, services and tools such as Reporting Services, and the Service Broker and DTS; Enhancements to the BI capabilities such as Analysis Services and Notification services.

Offering a comprehensive explanation for using ADO.NET, this title provides numerous practical code examples and extensive technical information. Specific topics include ADO.NET data architecture; data readers, adapters, and DataSets; safer development with XML Schemas; data relationships; ADO.NETUs built-in support, and performance optimization.