Microsoft SQL Server 2005: The Complete Reference Full Coverage of all New and Improved Features

by Shapiro, Jeffrey

• ISBN13: 9780072261523
• ISBN10: 0072261528
• Edition: 2nd
• Format: Paperback
• Copyright: 2006-12-08
• Publisher: McGraw-Hill Education

Summary

SQL Server 2005 is Microsoft's next-generation data management and analysis software designed to deliver increased scalability, availability, and security to enterprise data and analytical applications while making them easier to create, deploy, and manage. Filled with practical solutions and real-world examples, this resource includes full details on: Enterprise data management capabilities, including security and clustering Powerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0 Business Intelligence features, such as Integration Services, data warehousing, and reports

Author Biography

Jeffrey Shapiro is the author of SQL Server 2000: The Complete Reference, and the lead architect for Royal Palm Technology Group.

Steven Bowman is the lead SQL Server DBA for Lasalle Bank, and specializes in high availability solutions.

Table of Contents

Part I: SQL Server 2005 Operational Reference

Chapter 1: Security

Chapter 2: Disaster Recovery

Chapter 3: Scale Out, Scale Up

Chapter 4: Clustering SQL Server

Chapter 5: Operations Management

Chapter 6: Databases and Indexes

Part II: SQL Server 2005 Development Reference

Chapter 7: Advanced Transact-SQL

Chapter 8: Binding in Manage Code

Chapter 9: XML

Chapter 10: Service Broker

Chapter 11: Web Services

Chapter 12: Real Exception Handling

Part III: SQL Server 2005 Solution Reference

Chapter 13: Integration Services

Chapter 14: Data Mining

Chapter 15: Business Intelligence and Analysis

Chapter 16: Beyond the One-Click Cube

Chapter 17: Report Controls, Notifications, and More