04979nam 2200673 a 450 991046128440332120200520144314.01-283-34950-797866133495071-84968-145-7(CKB)2670000000094053(EBL)950595(OCoLC)797916697(SSID)ssj0000524185(PQKBManifestationID)11327014(PQKBTitleCode)TC0000524185(PQKBWorkID)10546168(PQKB)11119963(MiAaPQ)EBC950595(PPN)228041716(Au-PeEL)EBL950595(CaPaEBR)ebr10477258(CaONFJC)MIL334950(EXLCZ)99267000000009405320110708d2011 uy 0engur|n|---|||||txtccrMicrosoft 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. JayantyBirmingham, U.K. Packt Enterprise Pub.20111 online resource (468 p.)Includes index.1-84968-144-9 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 administrationpracticesImplementing 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 R2Managing 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 SQLServer 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; IntroductionPreparing 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 fortables and indexesOver 70 practical recipes for administering a high-performance SQL Server 2008 R2 system with this book and eBookClient/server computingDatabase managementRelational databasesElectronic books.Client/server computing.Database management.Relational databases.005.75/85005.7585Jayanty Satya Shyam K987841MiAaPQMiAaPQMiAaPQBOOK9910461284403321Microsoft SQL Server 2008 R2 Administration cookbook2258607UNINA