Microsoft SQL Server 2008 R2 Administration Cookbook Table of Contents


Table of Contents

Preface
Chapter 1: Getting Started with SQL Server 2008 R2
Chapter 2: Administrating the Core Database Engine
Chapter 3: Managing the Core Database Engine
Chapter 4: Administering Core Business Intelligence Services
Chapter 5: Managing Core SQL Server 2008 R2 Technologies
Chapter 6: Improving Availability and enhancing Programmability
Chapter 7: Implementing New Manageability Features and Practices
Chapter 8: Maintenance and Monitoring
Chapter 9: Troubleshooting
Chapter 10: Learning the Tricks of the Trade
Appendix: More DBA Manageability Best Practices
Index

  • 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
    • 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
      • Introduction
      • 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
        • Introduction
        • 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
          • Introduction
          • 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
            • Introduction
            • 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
              • Introduction
              • 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
                • Introduction
                • 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
                  • Introduction
                  • 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
                  • Managing a storage system for analyzing bottlenecks
                  • Chapter 9: Troubleshooting
                    • Introduction
                    • Implementing systematized monitoring methods for data platform optimization
                    • Designing a filtered indexes and statistics feature
                    • Implementing table hints for advanced query tuning performance
                    • Implementing query hints for optimized performance
                    • Designing sustainable locking methods to improve concurrency
                    • Implementing parallel query processing methods
                    • Implementing the plan guide to enhance compile-time and
                    • run-time execution plans
                    • Configuring and managing storage systems for optimized defragmentation processes
                    • Building best usage processes of Dynamic Management Views
                    • Implementing a benchmarking framework on multiple instances
                    • Chapter 10: Learning the Tricks of the Trade
                      • Introduction
                      • Automated administration across an enterprise
                      • Administrating resource health policies
                      • Administrating multiple Analysis Services using Tools
                      • Managing events capture to troubleshoot problems

                      Code Download and Errata
                      Packt Anytime, Anywhere
                      Register Books
                      Print Upgrades
                      eBook Downloads
                      Video Support
                      Contact Us
                      Awards Voting Nominations Previous Winners
                      Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                      Resources
                      Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software