万本电子书0元读

万本电子书0元读

顶部广告

Microsoft SQL Server 2008 R2 Administration Cookbook电子书

售       价:¥

45人正在读 | 0人评论 9.8

作       者:Satya Shyam K Jayanty

出  版  社:Packt Publishing

出版时间:2011-05-24

字       数:270.1万

所属分类: 进口书 > 外文原版书 > 电脑/网络

温馨提示:此类商品不支持退换货,不支持下载打印

为你推荐

  • 读书简介
  • 目录
  • 累计评论(0条)
  • 读书简介
  • 目录
  • 累计评论(0条)
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...

There's more...

Designing a best practice approach to upgrading to SQL Server 2008 R2

Getting Ready

How to do it...

How it works...

Backward Compatibility—Deprecate & 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

累计评论(0条) 0个书友正在讨论这本书 发表评论

发表评论

发表评论,分享你的想法吧!

买过这本书的人还买过

读了这本书的人还在读

回顶部