If you’ve built or managed SQL Server applications before, here’s your fastest route to SQL Server 2005 mastery. Apress’s team of SQL Server experts cover every significant enhancement that’s relevant to application developers, designers, and administrators, from its improved management tools to its built-in .NET common language runtime.
DBAs will especially appreciate the authors’ coverage of new T-SQL commands that’ll simplify their lives: notably DDL triggers for auditing database object changes, as well as new metadata views (goodbye system tables, and good riddance). Meanwhile, developers will simply devour the authors’ coverage of .NET integration, programming with assemblies, and XML support.
That’s not all: This book contains thorough introductions to SQL Server 2005’s souped-up reporting, analysis, and integration services; new ways to streamline and automate monitoring; and a full chapter on security, from permissions to encryption. Bill Camarda, from the December 2005
Chapter 1 SQL Server overview and installation
Chapter 2 SQL Server management technologies
Chapter 3 T-SQL enhancements for developers
Chapter 4 T-SQL enhancements for DBAs
Chapter 5 .Net integration
Chapter 6 Programming assemblies
Chapter 7 SQL Server and XML
Chapter 8 SQL Server 2005 XML and XQuery support
Chapter 9 SQL Server 2005 reporting services
Chapter 10 Analysis services
etc.