Table of Contents

book cover
Microsoft® SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
By  Scalability Experts, Inc. 
Publisher: Sams
Pub Date: August 30, 2005
ISBN: 0-672-32778-3
Pages: 504

Table of Contents  | Index

   About the Author
   We Want to Hear from You!
        Chapter 1.  Changes in the Database Paradigm: How SQL Server 2005 Redefines the Role of a DBA
      SQL Server Philosophy
      SQL Server 2005 and Database Administrators
        Chapter 2.  SQL Server 2005 Database Engine Architectural Changes
      The SQL Server Operating System (SQLOS)
      Non-Uniform Memory Access (NUMA) Architecture Support
      Query Optimization and Execution
      Row Versioning
      System Metadata Access and the Security Architecture
      Storage Engine and I/O Changes
        Chapter 3.  SQL Server 2005 Setup and Deployment
      SQL Server 2005 Editions
      Hardware and Software Requirements for Installing SQL Server 2005
      SQL Server 2005 Setup Enhancements
      Upgrading to SQL Server 2005
        Chapter 4.  A Tour of New Features in SQL Server 2005
      Setup Enhancements
      Database Administration and Management
      Database Engine Enhancements
      T-SQL Enhancements
      SQL Server 2005 Security
      Performance Monitoring and Tuning Enhancements
      High-Availability Features
      Business Intelligence Redefined
      Notification Services
      Full-Text Search Enhancements
      Documentation Improvements
        Chapter 5.  SQL Server 2005 Tools and Utilities
      Tools and Utilities Overview
      Management and Authoring
      Performance Monitoring, Tuning, and Optimization Tools
      Operations and Configuration
      Management APIs
        Chapter 6.  Transact-SQL Enhancements
      T-SQL Versus SQLCLR
      The TOP Operator
      The TABLESAMPLE Clause
      Common Table Expressions (CTEs)
      Large Object Data Type Enhancements
      T-SQL Error Handling
      DDL Triggers
      Event Notifications
      Snapshot Isolation
      Ranking Functions
      New Relational Operators: PIVOT, UNPIVOT, and APPLY
      The OUTPUT Clause
      The BULK Rowset Provider
      New Declarative Referential Integrity Actions
      Metadata Views and Dynamic Management Views
      Miscellaneous T-SQL Enhancements
        Chapter 7.  SQL Server 2005 Security
      An Introduction to Security in SQL Server 2005
      Auditing Enhancements
      Cryptography Support
      Surface Area Configuration (SAC)
      SQL Server Agent Security Overview
      SQLCLR Security Overview
      Service Broker Security Overview
        Chapter 8.  Reliability and High Availability in the Database Engine
      Reliability Enhancements
      Availability Enhancements
        Chapter 9.  Performance Analysis and Tuning
      Physical Database Design, Analysis, and Tuning
      Troubleshooting Locking and Blocking
      Query Performance Tuning
      Designing Applications for Performance
      Performance Monitoring and Tuning Tools
        Chapter 10.  XML and Web Services Support in SQL Server 2005
      XML Primer
      The xml Data Type
      FOR XML Enhancements
      Native XML Web Services Support
        Chapter 11.  SQL Server 2005 and .NET Integration
      What Is the .NET Framework?
      .NET Framework Integration
      SQLCLR Integration Examples
        Chapter 12.  SQL Server Integration Services Overview
      New SSIS Features
      The SSIS Architecture
      The SSIS Toolkit
      Designing SSIS Packages
      The World of Wizards
      SSIS and Data Warehousing
        Chapter 13.  What's New in SQL Server Analysis Services 2005
      OLAP, Data Warehousing, Business Intelligence, and Data Mining
      Analysis Services Fundamentals
      Analysis Services 2005 Enhancements
      Performance Tuning for Analysis Services
      Administering Analysis Services
      Analysis Services Security Overview
      Migrating from SQL Server 2000 Analysis Services to SQL Server 2005 Analysis Services
      SQL Server 2005 Reporting Services (SSRS) Overview
        Chapter 14.  SQL Server Service Broker
      An Introduction to Asynchronous Messaging
      Understanding Service Broker
      Service Broker Operations and Troubleshooting
      Service Broker Security Overview
        Chapter 15.  SQL Sever 2005 Support for 64-Bit Processors
      64-Bit Processor Usage Scenarios
      SQL Server 2005 (64-Bit) in Detail

Microsoft SQL Server 2005(c) Changing the Paradigm
Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
ISBN: 0672327783
EAN: 2147483647
Year: 2005
Pages: 150 © 2008-2017.
If you may any questions please contact us: