Microsoft SQL Server 2005 New Features

Book Title: Microsoft SQL Server 2005 New Features Author: Michael Otey Publisher: McGraw-Hill/Osborne Year: 2005

Table of content

• Chapter 1 - Database Architecture and Storage Engine Features
• Chapter 2 - Database Administration and Development Tools
• Chapter 3 - Availability and Recovery Features
• Chapter 4 - Programmability Features
• Chapter 5 - Notification Services
• Chapter 6 - SQL Server Service Broker
• Chapter 7 - XML Integration
• Chapter 8 - Reporting Services
• Chapter 9 - Integration Services
• Chapter 10 - Analysis Services
• Appendix A - Installation and Upgrading
• Appendix B - Quick Facts

Description

Get full details on all the innovative features and benefits available in SQL Server 2005. This authoritative guide explains the new and improved enterprise data management capabilities, developer functions, and business intelligence tools. You’ll see how it offers enhanced scalability, availability, and security, as well as ease-of-use. Written by the Senior Technical Editor of SQL Server Magazine, this is an ideal resource for decision-makers, developers, and DBAs preparing for upgrades or migration.

Covers new and improved capabilities including:

• All news tools such as SQL Server Management Studio and Business Intelligence Development Studio
• .NET Common Language Runtime (CLR) integration
• Enhanced availability and recovery features including Database Mirroring and Snapshot Isolation
• T-SQL enhancements and new data types
• Improved XML integration and the new native XML data type
• The new Reporting Services and SQL Server Broker subsystems
• The new Unified Dimensional Model and Data Mining algorithms
• Security enhancements such as secure default settings and Schema ownership
• The enterprise-ready Integration Services
• All new development models: AMO, SMO, ODL, XMLA