Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
ISBN: 0672327783
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 150
Pages: 150
Authors: Scalability Experts Inc.
- Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
- Table of Contents
- 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 IO 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
- SYMBOL
- A
- B
- C
- D
- E
- F
- G
- H
- I
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
Microsoft SQL Server 2005: Changing the Paradigm (SQL Server 2005 Public Beta Edition)
ISBN: 0672327783
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 150
Pages: 150
Authors: Scalability Experts Inc.