Pro SQL Server 2005

* First book to provide comprehensive, deeply practical coverage on all major new SS2005 features.

"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. TOC:Installation.- An Overview of SQL Server Management Studio.- T-SQL for Developers.- T-SQL for DBAs.- .NET Integration.- UDTs and Aggregates.- Using XML.- XQUERY and Xpath.- Reporting Services.- Analysis Services.- Security.- Automation and Monitoring.- SQL Server Integration Services.- Database Mirroring.- SMO.- Notification Services."

A table of contents is not available for this title.