Publisher Description

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!

Notes

Pro SQL Server 2005 Special Edition is for every SQL Server user and programmer. No other single book more comprehensively yet concisely covers the many powerful new features of SQL Server 2005. The Special Edition expands on the original by adding chapters on encryption, full-text search, LINQ, and the ADO.NET 3.0 Entity Data Model, bringing it up to date for .NET 3.5, and making it even more attractive than ever to readers.

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.

Long Description

This book gets straight to the point and gives you the desired insight into the new functionality of SQL Server 2005. -- Frank Kalis, SQL-Server-Performance.com I really like this book and it definitely has value, especially as a survey of new technology. -- Sean McCown, ITBookworm Purchase this book and you'll get the free, fully searchable eBook--a $25 value! (Details are printed inside the book.) 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 DBAs, 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. This book offers incisive, expert guidance on all of the major new functionality of SQL Server 2005, covering topics that are essential for all SQL Server professionals, including Transact-SQL enhancements SQL Server Management Studio CLR integration and programming stored procedures in C# SQL Server Reporting Services enhancements SQL Server Analysis Services enhancements The new XML datatype and XQuery support Security enhancements and Service Broker SQL Server Integration Services for data extraction, transformation, and loading The authors provide practical, in-depth coverage of the core topics that they specialize in--allsupported 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!

Feature

First book to provide comprehensive, deeply practical coverage on all major new SS2005 features Lead author (Tom Rizzo) is a key member of the SQL Server team at Microsoft and a respected author and blogger Gets the DBA and developer up and running with SS2005 in the fastest possible time The facts, not the evangelism

Description for Sales People

Pro SQL Server 2005 Special Edition is for every SQL Server user and programmer. No other single book more comprehensively yet concisely covers the many powerful new features of SQL Server 2005. The Special Edition expands on the original by adding chapters on encryption, full-text search, LINQ, and the ADO.NET 3.0 Entity Data Model, bringing it up to date for .NET 3.5, and making it even more attractive than ever to readers.

Details