LEADER 04946nam 2200661 a 450 001 9910789549503321 005 20200520144314.0 010 $a1-283-34950-7 010 $a9786613349507 010 $a1-84968-145-7 035 $a(CKB)2670000000094053 035 $a(EBL)950595 035 $a(OCoLC)797916697 035 $a(SSID)ssj0000524185 035 $a(PQKBManifestationID)11327014 035 $a(PQKBTitleCode)TC0000524185 035 $a(PQKBWorkID)10546168 035 $a(PQKB)11119963 035 $a(MiAaPQ)EBC950595 035 $a(Au-PeEL)EBL950595 035 $a(CaPaEBR)ebr10477258 035 $a(CaONFJC)MIL334950 035 $a(PPN)228041716 035 $a(EXLCZ)992670000000094053 100 $a20110708d2011 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMicrosoft SQL Server 2008 R2 Administration cookbook$b[electronic resource] $eover 70 practical recipes for administering a high-performance SQL Server 2008 R2 system /$fSatya Shyam K. Jayanty 210 $aBirmingham, U.K. $cPackt Enterprise Pub.$d2011 215 $a1 online resource (468 p.) 300 $aIncludes index. 311 $a1-84968-144-9 327 $aCover; 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 327 $apracticesImplementing 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 327 $aManaging 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 327 $aServer 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 327 $aPreparing 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 327 $atables and indexes 330 $aOver 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and eBook 606 $aClient/server computing 606 $aDatabase management 606 $aRelational databases 615 0$aClient/server computing. 615 0$aDatabase management. 615 0$aRelational databases. 676 $a005.75/85 676 $a005.7585 700 $aJayanty$b Satya Shyam K$01563347 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910789549503321 996 $aMicrosoft SQL Server 2008 R2 Administration cookbook$93831695 997 $aUNINA