Microsoft SQL Server 2005: The Complete Reference, 2/e (Paperback)

Jeffrey Shapiro

  • 出版商: McGraw-Hill Education
  • 出版日期: 2006-12-08
  • 售價: $1,760
  • 貴賓價: 9.5$1,672
  • 語言: 英文
  • 頁數: 672
  • 裝訂: Paperback
  • ISBN: 0072261528
  • ISBN-13: 9780072261523
  • 相關分類: MSSQLSQL





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


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