Microsoft SQL Server 2005 New Features (Database Series)

Overview

Take Full Advantage of The Database and Analysis Potential of SQL Server 2005

Get full details on all the innovative features and benefits available in the upcoming release of 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 the new release 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

About the Author: Michael Otey is Senior Technical Editor of SQL Server Magazine, Technical Director of Windows IT Pro Magazine, and co-author of SQL Server 2000 Developer’s Guide and SQL Server 7 Developer’s Guide, both from McGraw-Hill/Osborne. He is the presidentof TECA, Inc., a software development and consulting firm.

Read More