Vai al contenuto principale della pagina
Autore: |
Jayanty Satya Shyam K
![]() |
Titolo: |
Microsoft SQL Server 2008 R2 Administration cookbook [[electronic resource] ] : over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system / / Satya Shyam K. Jayanty
![]() |
Pubblicazione: | Birmingham, U.K., : Packt Enterprise Pub., 2011 |
Descrizione fisica: | 1 online resource (468 p.) |
Disciplina: | 005.75/85 |
005.7585 | |
Soggetto topico: | Client/server computing |
Database management | |
Relational databases | |
Note generali: | Includes index. |
Nota di contenuto: | 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 | |
Sommario/riassunto: | Over 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and eBook |
Titolo autorizzato: | Microsoft SQL Server 2008 R2 Administration cookbook ![]() |
ISBN: | 1-283-34950-7 |
9786613349507 | |
1-84968-145-7 | |
Formato: | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione: | Inglese |
Record Nr.: | 9910789549503321 |
Lo trovi qui: | Univ. Federico II |
Opac: | Controlla la disponibilità qui |