Table of Contents

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

		Copyright
		Foreword
		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
			History
			SQL Server 2005 and Database Administrators
			Summary
		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
			Summary
		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
			Summary
		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
			Summary
		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
			Summary
		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
			Summary
		Chapter 7.  SQL Server 2005 Security
			An Introduction to Security in SQL Server 2005
			Authentication
			Authorization
			Auditing Enhancements
			Cryptography Support
			Surface Area Configuration (SAC)
			SQL Server Agent Security Overview
			SQLCLR Security Overview
			Service Broker Security Overview
			Summary
		Chapter 8.  Reliability and High Availability in the Database Engine
			Reliability Enhancements
			Availability Enhancements
			Summary
		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
			Summary
		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
			Summary
		Chapter 11.  SQL Server 2005 and .NET Integration
			What Is the .NET Framework?
			.NET Framework Integration
			SQLCLR Integration Examples
			Summary
		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
			Summary
		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
			Summary
		Chapter 14.  SQL Server Service Broker
			An Introduction to Asynchronous Messaging
			Understanding Service Broker
			Service Broker Operations and Troubleshooting
			Service Broker Security Overview
			Summary
		Chapter 15.  SQL Sever 2005 Support for 64-Bit Processors
			64-Bit Processor Usage Scenarios
			SQL Server 2005 (64-Bit) in Detail
			Summary
		Index