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

• Record Nr.: UNINA9910789549503321
• Autore: Jayanty Satya Shyam K
• Pubbl/distr/stampa: Birmingham, U.K., : Packt Enterprise Pub., 2011
• ISBN: 1-283-34950-7; 9786613349507; 1-84968-145-7
• Descrizione fisica: 1 online resource (468 p.)
• Disciplina: 005.75/85; 005.7585
• Soggetti: Client/server computing; Database management; Relational databases
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• 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