Pro SQL Server 2005

by Robin Dewson, Adam Machanic, Jan D. Narkiewicz, Thomas Rizzo, Joseph Sack

Overview

SQL Server 2005 is a dramatically expanded and enhanced version of SQL Server 2000 that not only makes SQL Server a true enterprise-level RDBMS, but also changes how SQL Server professionals design databases and develop database applications.

Pro SQL Server 2005 provides in-depth coverage of new SQL Server features and enhancements. It focuses on what experienced SQL Server database administrators, developers, and business intelligence practitioners need to know to get up to speed with SQL Server 2005 as quickly as possible. It carefully presents each new feature and precisely illustrates the feature with examples that show you how to use it effectively.

The authors provide practical, in-depth coverage of the core topics that they specialize inall supported by realistic examples, so you'll be able to design and implement your own SQL Server 2005 solutions quickly and painlessly. This book is a roadmap for exploring and exploiting SQL Server 2005. So fasten your seatbelts, start your computers, and race to mastery of SQL Server 2005!

Product Details

ISBN-13:	9781590594773
Publisher:	Apress
Publication date:	11/07/2005
Series:	Pro Series
Edition description:	1st ed.
Pages:	704
Product dimensions:	7.01(w) x 9.25(h) x 0.06(d)

About the Author

Robin Dewson has been hooked on programming ever since he bought his first computer, a Sinclair ZX80, in 1980. He has been working with SQL Server since version 6.5 and Visual Basic since version 5. Robin is a consultant mainly in the city of London, where he has been for nearly eight years. He also has been developing a rugby-related website as well as maintaining his own site at Fat-Belly.com.

Table of Contents

SQL Server Overview and Installation.- SQL Server Management Technologies.- T-SQL Enhancements for Developers.- T-SQL Enhancements for DBAs.- .NET Integration.- Programming Assemblies.- SQL Server and XML.- SQL Server 2005 XML and XQuery Support.- SQL Server 2005 Reporting Services.- Analysis Services.- Security.- Service Broker.- Automation and Monitoring.- Integration Services.- Database Mirroring.- Notification Services.

Editorial Reviews

The Barnes & Noble Review
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 Read Only

bn.com