Microsoft SQL Server 2008 R2 Administration cookbook : over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system / Satya Shyam K. Jayanty.

Format:

Book

Author/Creator:

Jayanty, Satya Shyam K.

Language:

English

Subjects (All):

SQL server.

Client/server computing.

Database management.

Relational databases.

Physical Description:

1 online resource (468 p.)

Edition:

1st ed.

Place of Publication:

Birmingham, U.K. : Packt Enterprise Pub., 2011.

Language Note:

English

Summary:

Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and eBook

Contents:

Cover; Copyright; Credits; Foreword; About the Author; Acknowledgment; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; 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

practicesImplementing 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 datawarehouse 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 ServicesPreparing 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 featuresInstalling 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

Notes:

Includes index.

ISBN:

9786613349507

9781283349505

1283349507

9781849681452

1849681457

OCLC:

797916697