Cargando…
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.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2011.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Microsoft SQL Server 2008 R2 Administration Cookbook; 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 forConventions; 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.