更新时间：2021-04-02 19:34:12
封面
版权信息
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
SQL Server 2008 R2 Prologue
SQL Server 2008 R2 new enhancements
SQL Server 2008 R2 DataCenter
SQL Server 2008 R2 Parallel Data Warehouse
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Getting Started with SQL Server 2008 R2
Introduction
Adding SQL Server 2008 R2 Service Pack features using Slipstream technology
Designing a best practice approach to upgrading to SQL Server 2008 R2
There's more.
Working with Data-Tier applications
Designing and adopting SQL Server 2008 R2 solutions
Designing applications to use federated servers
Chapter 2. Administrating the Core Database Engine
Designing automated administration practices
Implementing Security feature enhancements
Implementing Availability feature enhancements
Implementing Monitoring and Tuning for performance
Administering SQL Server workloads with Resource Governor
Designing SQL Server Agent scheduled jobs for ETL processes
Troubleshooting multi-server instances with utility administration
Administering SQL Server Replication processes
Chapter 3. Managing the Core Database Engine
Implementing Central Management feature enhancements
Designing Multi-server management from SQL Server 2008 R2
Managing the Utility Control Point data warehouse database
Implementing Utility & Non-utility collection sets
Designing and refreshing a Scalable Shared database
Managing SQL Server Replication processes
Implementing security for SQL Server Agent jobs management
Multiserver Management Using Utility Explorer
Chapter 4. Administering Core Business Intelligence Services
Preparing and installing SQL Server Analysis Services
Implementing Scale-Out of SQL Server Analysis Services
Administering SQL Server Reporting Services
Implementing Scale-Out deployment of SQL Server Reporting Services
Preparing and installing SQL Server Integration Services
Managing the ETL process efficiently
Chapter 5. Managing Core SQL Server 2008 R2 Technologies
Planning and implementing Self-Service Business Intelligence services
Implementing Microsoft StreamInsight Technologies Platform
Implementing SQL Azure connectivity features
Installing and configuring a Master Data Services Solution
Designing and deploying framework to use Master Data Services
Chapter 6. Improving Availability and enhancing Programmability
Preparing new Failover Cluster features
Installing and configuring Failover Cluster Services
Recovering and troubleshooting Failover Cluster Failure
Implementing Database Mirroring features and performance enhancements
Managing Database Mirroring in a Failover Cluster environment
Managing Log Shipping scenarios in a Database Mirroring environment
Improving Replication scalability at multiple sites
Implementing compressed storage features for tables and indexes
Designing a storage solution for unstructured data and new collations
Designing data partitioning solutions for tables and indexes
Implementing sparse columns and wide table features
Designing spatial data storage methods
Deploying and managing data-tier applications
Chapter 7. Implementing New Manageability Features and Practices
Implementing auditing and service level security features
Managing server-level securable and database-level permissions
Implementing backup compression for a VLDB environment
Designing change tracking methodology
Implementing Policy-Based Management features
Implementing and running PowerShell for SQL Server features
Implementing the SQL Server Best Practices Analyzer
Designing Transparent Data Encryption features
Chapter 8. Maintenance and Monitoring
Implementing performance baseline practices
Monitoring resource usage with Extended Events
Implementing Management Data Warehouse features
Designing maintenance tasks on a mission-critical environment
Implementing Piecemeal restore strategies
Planning and designing of a Disaster Recovery environment
Implementing sustainable index maintenance practices for a VLDB & 24/7 environment
Configuring a manageable database consistency and integrity process for multiple databases and a VLDB environment
Configuring a server storage system for scalability
Configuring SQL server storage architecture for quick recovery
