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

by Jeffrey Shapiro, Steven Bowman

Overview

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.




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

Product Details

ISBN-13:	9780072261523
Publisher:	McGraw Hill LLC
Publication date:	11/17/2006
Series:	Essential Skills for Database Professionals Ser.
Edition description:	REV
Pages:	672
Product dimensions:	7.30(w) x 9.10(h) x 1.65(d)

About the Author

Jeffrey Shapiro, MCSE, MCTS, MCPD, is the author of SQL Server 2000: The Complete Reference as well as 11 other technology books. He is currently working on a variety of SQL Server business intelligence projects for Fortune 100 companies in Orlando, Florida.

Table of Contents

Part I: SQL Server 2005 System and Platform Architecture

Chapter 1: Getting to Know SQL Server 2005

Chapter 2: Database Architecture

Chapter 3: RDBMS Architecture

Chapter 4: Connecting to and Administering the Database Engine
Part II: Administering SQL Server 2005

Chapter 5: Security

Chapter 6: Databases, Tables, and Indexes

Chapter 7: SQL Server Disaster Recovery

Chapter 8: Distributed Database Architecture

Chapter 9: SQL Server 2005 High Availability
Part III: Programming SQL Server 2005

Chapter 10: Transact-SQL Primer

Chapter 11: Understanding the SQL Server Common Language Runtime

Chapter 12: Data Integrity

Chapter 13: Triggers

Chapter 14: Stored Procedures and Functions
Part IV: Working with SQL Server 2005

Chapter 15: Working with Operational Data

Chapter 16: Working with Tabular Data

Chapter 17: Working with Transactional Data

Chapter 18: Monitoring SQL Server
APPENDIX A: T-SQL REFERENCE
INDEX