Free Sample
+ Collection

Microsoft SQL Server 2008 R2 Administration Cookbook

Satya Shyam K Jayanty

Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and eBook
RRP $32.99
RRP $54.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849681445
Paperback468 pages

About This Book

  • Provides Advanced Administration techniques for SQL Server 2008 R2 as a book or eBook
  • Covers the essential Manageability, Programmability, and Security features
  • Emphasizes important High Availability features and implementation
  • Explains how to maintain and manage the SQL Server data platform effectively

Who This Book Is For

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 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.

<!--Session data-->


<!--Session data-->

Table of Contents

Chapter 1: Getting Started with SQL Server 2008 R2
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
Managing a storage system for analyzing bottlenecks
Chapter 9: Troubleshooting
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
Automated administration across an enterprise
Administrating resource health policies
Administrating multiple Analysis Services using Tools
Managing events capture to troubleshoot problems

What You Will Learn

  • Discover best practice solutions for upgrading to SQL Server 2008 R2
  • Employ the new enhancements in SQL Server 2008 R2
  • Build a strategic multi-server management
  • Automate administration tasks
  • Implement the inter-operability of SQL Server Analysis Services and SQL Server Reporting Services with SharePoint 2010 services
  • Manage and administer core SQL Server 2008 R2 Business Intelligence Services
  • Implement and manage essential Availability and Programmability enhancements
  • Implement best practices and build troubleshooting techniques on a multi-instance and multi-database environment

In Detail

Microsoft SQL Server is a powerful relational database engine, widely used to store and maintain data in Enterprises of various levels – be they small, medium, or large. SQL Server delivers a rich set of integrated services and reporting features that enable you to do more with your data such as query, search, synchronize, report, and analyze. SQL Server 2008 R2 accelerates the capabilities to scale database operations and is a highly scalable data platform.

This practical cookbook will show you the advanced administration techniques for managing and administering a scalable and high-performance SQL Server 2008 R2 system. It contains over 85 practical, task-based, and immediately useable recipes covering a wide range of advanced administration techniques for administering a high-performance SQL Server 2008 R2 system and solving specific administration problems. It shows how the SQL Server 2008 R2 system can be taken further.

Packed with reusable, real-world recipes, the book starts by providing an overview of the server and specialized editions of SQL Server 2008 R2 technologies, features, and solutions. Next it covers database administration and management principles with real-world examples. The book then dives deep into topics such as administration of core Business Intelligence Services, management of core SQL Server 2008 R2 technologies, availability, security, and programmability, implementing new manageability features and practices, and maintenance and monitoring, amongst others.

<!--Session data-->


<!--Session data-->

<!--Session data-->

<!--Session data-->

<!--Session data-->

<!--Session data-->

<!--Session data-->


Read More