Microsoft SQL Server 2005: The Complete Reference: Full Coverage of All New and Improved Features （2ND）

Shapiro, Jeffrey

McGraw-Hill Companies（2006/12発売）

• 製本 Paperback:紙装版/ペーパーバック版／ページ数 672 p.
• 言語 ENG
• 商品コード 9780072261523
• DDC分類 005.758

Full Description

Publisher's Noteguaranteed 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 clusteringPowerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0Business Intelligence features, such as Integration Services, data warehousing, and reports

Contents

Part IGetting to Know SQL Server 2005Chapter 2: Database ArchitectureChapter 3: RDBMS ArchitectureChapter 4: Connecting to and Administering the Database EnginePart II: Administering SQL Server 2005Chapter 5: SecurityChapter 6: Databases, Tables, and IndexesChapter 7: SQL Server Disaster RecoveryChapter 8: Distributed Database ArchitectureChapter 9: SQL Server 2005 High AvailabilityPart III: Programming SQL Server 2005Chapter 10: Transact-SQL PrimerChapter 11: Understanding the SQL Server Common Language RuntimeChapter 12: Data IntegrityChapter 13: TriggersChapter 14: Stored Procedures and FunctionsPart IV: Working with SQL Server 2005Chapter 15: Working with Operational DataChapter 16: Working with Tabular DataChapter 17: Working with Transactional DataChapter 18: Monitoring SQL ServerAPPENDIX A: T-SQL REFERENCEINDEXNER(01): WOW