Microsoft SQL Server 2008 R2 Administration Cookbook. Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and - Ebook - Satya Shyam K Jayanty - Modern learning platform

E-book details

Log in, If you're interested in the contents of the item.

Microsoft SQL Server 2008 R2 Administration Cookbook. Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and

Satya Shyam K Jayanty

Ebook

Microsoft SQL Server 2008 R2 Administration Cookbook
- Table of Contents
- Microsoft SQL Server 2008 R2 Administration Cookbook
- Credits
- Foreword
- About the Author
- Acknowledgment
- About the Reviewers
- www.PacktPub.com
  - Support files, eBooks, discount offers and more
    - Why Subscribe?
    - Free Access for Packt account holders
    - Instant Updates on New Packt Books
- 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
    - SQL Server 2008 R2 Core Editions Enhancements
  - What you need for this book
  - Who this book is for
  - Conventions
  - Reader feedback
  - Customer support
    - Downloading the example code
    - Errata
    - Piracy
    - Questions
- 1. Getting Started with SQL Server 2008 R2
  - Introduction
  - Adding SQL Server 2008 R2 Service Pack features using Slipstream technology
    - Getting Ready
    - How to do it...
    - How it works...
    - Theres more...
  - Designing a best practice approach to upgrading to SQL Server 2008 R2
    - Getting Ready
    - How to do it...
    - How it works...
      - Backward CompatibilityDeprecate & Discontinued features
  - There's more.
  - Working with Data-Tier applications
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
  - Designing and adopting SQL Server 2008 R2 solutions
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
  - Designing applications to use federated servers
    - Getting ready
    - How to do it...
    - How it works...
- 2. Administrating the Core Database Engine
  - Introduction
  - Designing automated administration practices
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
    - See Also
  - Implementing Security feature enhancements
    - Getting ready
    - How to do it...
    - How it works...
    - See Also
  - Implementing Availability feature enhancements
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
    - See Also
  - Implementing, Monitoring, and Tuning for performance
    - Getting ready
    - How to do it...
    - How it works...
  - Administering SQL Server workloads with Resource Governor
    - Getting ready
    - How to do it...
      - How it works...
      - There's more...
  - Designing SQL Server Agent scheduled jobs for ETL processes
    - Getting ready
    - How to do it...
    - How it works...
    - There's more
  - Troubleshooting multi-server instances with utility administration
    - Getting ready
    - How to do it...
    - How it works...
  - Administering SQL Server Replication processes
    - Getting ready
    - How to do it...
    - How it works...
    - See Also
- 3. Managing the Core Database Engine
  - Introduction
  - Implementing Central Management feature enhancements
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
    - See Also
  - Designing Multi-server management from SQL Server 2008 R2
    - Getting ready
    - How to do it...
    - How it works...
  - Managing the Utility Control Point data warehouse database
    - How to do it...
    - How it works...
  - Implementing Utility & Non-utility collection sets
    - Getting ready
    - How to do it...
    - How it works...
  - Designing and refreshing a Scalable Shared database
    - Getting ready
    - How to do it...
    - How it works...
    - There's more
  - Managing SQL Server Replication processes
    - How to do it...
    - How it works
  - Implementing security for SQL Server Agent jobs management
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
    - See Also
  - Multiserver Management Using Utility Explorer
    - Getting ready
    - How to do it...
    - How it works...
- 4. Administering Core Business Intelligence Services
  - Introduction
  - Preparing and installing SQL Server Analysis Services
    - Getting ready
    - How to do it...
    - How it works...
    - There's more
  - Implementing Scale-Out of SQL Server Analysis Services
    - Getting ready
    - How to do it...
    - How it works...
  - Administering SQL Server Reporting Services
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
    - See Also
  - Implementing Scale-Out deployment of SQL Server Reporting Services
    - Getting ready
    - How to do it...
    - How it works...
    - There's more
    - See Also
  - Preparing and installing SQL Server Integration Services
    - Getting ready
    - How to do it...
    - How it works...
  - Managing the ETL process efficiently
    - How to do it...
    - How it works...
- 5. Managing Core SQL Server 2008 R2 Technologies
  - Introduction
  - Planning and implementing Self-Service Business Intelligence services
    - Getting ready
    - How to do it...
    - How it works...
    - There's more
  - Implementing Microsoft StreamInsight Technologies Platform
    - Getting ready
    - How to do it...
    - How it works...
  - Implementing SQL Azure connectivity features
    - Getting ready
    - How to do it...
    - How it works...
    - There's more
  - Installing and configuring a Master Data Services Solution
    - Getting ready
    - How to do it...
    - How it works...
  - Designing and deploying framework to use Master Data Services
    - Getting ready
    - How to do it...
    - How it works...
- 6. Improving Availability and enhancing Programmability
  - Introduction
  - Preparing new Failover Cluster features
    - Getting ready
    - How to do it...
    - How it works...
  - Installing and configuring Failover Cluster Services
    - Getting ready
    - How to do it...
    - How it works...
  - Recovering and troubleshooting Failover Cluster Failure
    - Getting ready
    - How to do it...
    - How it works...
    - See also
  - Implementing Database Mirroring features and performance enhancements
    - Getting ready
    - How to do it...
    - How it works...
    - See also
  - Managing Database Mirroring in a Failover Cluster environment
    - Getting ready
    - How to do it...
    - How it works...
  - Managing Log Shipping scenarios in a Database Mirroring environment
    - Getting ready
    - How to do it...
    - How it works...
  - Improving Replication scalability at multiple sites
    - Getting ready
    - How to do it...
    - How it works...
  - Implementing compressed storage features for tables and indexes
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
  - Designing a storage solution for unstructured data and new collations
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
  - Designing data partitioning solutions for tables and indexes
    - Getting ready
    - How to do it...
    - How it works...
  - Implementing sparse columns and wide table features
    - Getting ready
    - How to do it...
    - How it works...
  - Designing spatial data storage methods
    - Getting ready
    - How to do it...
    - How it works...
  - Deploying and managing data-tier applications
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
    - See also
- 7. Implementing New Manageability Features and Practices
  - Introduction
  - Implementing auditing and service level security features
    - Getting ready
    - How to do it...
    - How it works...
  - Managing server-level securable and database-level permissions
    - Getting ready
    - How to do it...
    - How it works...
  - Implementing backup compression for a VLDB environment
    - Getting ready
    - How to do it...
    - How it works...
  - Designing change tracking methodology
    - Getting ready
    - How to do it...
    - How it works...
  - Implementing Policy-Based Management features
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
  - Implementing and running PowerShell for SQL Server features
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
  - Implementing the SQL Server Best Practices Analyzer
    - Getting ready
    - How to do it...
    - How it works...
  - Designing Transparent Data Encryption features
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
- 8. Maintenance and Monitoring
  - Introduction
  - Implementing performance baseline practices
    - Getting ready
    - How to do it
    - How it works...
    - There's more.
      - See Also
  - Monitoring resource usage with Extended Events
    - Getting ready
    - How to do it...
    - How it works...
    - There's more
  - Implementing Management Data Warehouse features
    - Getting ready
    - How to do it
    - How it works...
    - There's more...
  - Designing maintenance tasks on a mission-critical environment
    - Getting ready
    - How to do it...
    - How it works.
  - Implementing Piecemeal restore strategies
    - Getting ready
      - How to do it...
      - How it works...
      - There's more...
  - Planning and designing of a Disaster Recovery environment
    - Getting ready
    - How to do it...
    - How it works...
  - Implementing sustainable index maintenance practices for a VLDB & 24/7 environment
    - Getting ready
    - How to do it...
    - How it works...
  - Configuring a manageable database consistency and integrity process for multiple databases and a VLDB environment
    - Getting ready
    - How to do it...
    - How it works...
  - Configuring a server storage system for scalability
    - Getting ready
    - How to do it...
    - How it works...
  - Configuring SQL server storage architecture for quick recovery
    - Getting ready
    - How to do it...
    - How it works...
  - Managing a storage system for analyzing bottlenecks
    - Getting ready
    - How to do it...
    - How it works...
- 9. Troubleshooting
  - Introduction
  - Implementing systematized monitoring methods for data platform optimization
    - Getting ready
    - How to do it...
    - How it works...
  - Designing a filtered indexes and statistics feature
    - Getting ready
    - How to do it...
    - How it works...
  - Implementing table hints for advanced query tuning performance
    - How to do it...
    - How it works...
  - Implementing query hints for optimized performance
    - How to do it...
    - How it works...
  - Designing sustainable locking methods to improve concurrency
    - How to do it...
    - How it works...
  - Implementing parallel query processing methods
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
    - See also
  - Implementing the plan guide to enhance compile-time and run-time execution plans
    - How to do it...
    - How it works...
    - There's more...
  - Configuring and managing storage systems for optimized defragmentation processes
    - Getting ready
    - How to do it...
    - How it works...
  - Building best usage processes of Dynamic Management Views
    - How to do it...
    - How it works...
  - Implementing a benchmarking framework on multiple instances
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
- 10. Learning the Tricks of the Trade
  - Introduction
  - Automated administration across an enterprise
    - Getting ready
    - How to do it...
    - How it works...
    - There's more...
    - See also
  - Administrating resource health policies
    - Getting ready
    - How to do it...
    - How it works...
  - Administrating multiple Analysis Services using Tools
    - How to do it...
    - How it works...
  - Managing events capture to troubleshoot problems
    - How to do it...
    - How it works...
    - See also
- A. More DBA Manageability Best Practices
- Index

Title: Microsoft SQL Server 2008 R2 Administration Cookbook. Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and
Author: Satya Shyam K Jayanty
Original title: Microsoft SQL Server 2008 R2 Administration Cookbook. Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and eBook
ISBN: 9781849681452, 9781849681452
Date of issue: 2011-05-24
Format: Ebook
Item ID: e_3bj8
Publisher: Packt Publishing

select a language

Categories

E-book details