Електронні книги Serwery internetoweДеталі електронної книги: Microsoft SQL Server 2008 R2 Administration...

Деталі електронної книги

Увійти якщо вас цікавить зміст видання.

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

EЛЕКТРОННА КНИГА

Купуйте видання на ebookpoint.pl

This book offers practical, task-based, and immediately usable recipes covering a wide range of advanced techniques for administering a high-performance SQL Server 2008 R2 system. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, its explanations go into great detail, which makes it good learning material for everyone who has experience in SQL Server and wants to improve. The book is designed in such a way that you can either read it chapter by chapter or refer to recipes that you want in no particular order. Although the book is focused on specific Microsoft SQL Server 2008 R2, most of the concepts and explanations are also applicable to SQL Server 2008. If you are an experienced database administrator and database architect who wants to design, administer, and manage a scalable and high-performance SQL Server 2008 R2 system, then this book is for you. The book assumes that you have a good understanding of database management systems, specifically experience in Microsoft SQL Server 2008 administration.

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

Назва: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
Оригінальна назва: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
Дата видання:2011-05-24
Формат:Eлектронна книга - EPUB
Ідентифікатор видання: e_3bj8
Видавець: Packt Publishing