Microsoft SQL Server 2008 R2 Administration Cookbook

More Information
  • Discover best practice solutions for upgrading to SQL Server 2008 R2
  • Employ the new enhancements in SQL Server 2008 R2
  • Build a strategic multi-server management
  • Automate administration tasks
  • Implement the inter-operability of SQL Server Analysis Services and SQL Server Reporting Services with SharePoint 2010 services
  • Manage and administer core SQL Server 2008 R2 Business Intelligence Services
  • Implement and manage essential Availability and Programmability enhancements
  • Implement best practices and build troubleshooting techniques on a multi-instance and multi-database environment

Microsoft SQL Server is a powerful relational database engine, widely used to store and maintain data in Enterprises of various levels – be they small, medium, or large. SQL Server delivers a rich set of integrated services and reporting features that enable you to do more with your data such as query, search, synchronize, report, and analyze. SQL Server 2008 R2 accelerates the capabilities to scale database operations and is a highly scalable data platform.

This practical cookbook will show you the advanced administration techniques for managing and administering a scalable and high-performance SQL Server 2008 R2 system. It contains over 85 practical, task-based, and immediately useable recipes covering a wide range of advanced administration techniques for administering a high-performance SQL Server 2008 R2 system and solving specific administration problems. It shows how the SQL Server 2008 R2 system can be taken further.

Packed with reusable, real-world recipes, the book starts by providing an overview of the server and specialized editions of SQL Server 2008 R2 technologies, features, and solutions. Next it covers database administration and management principles with real-world examples. The book then dives deep into topics such as administration of core Business Intelligence Services, management of core SQL Server 2008 R2 technologies, availability, security, and programmability, implementing new manageability features and practices, and maintenance and monitoring, amongst others.

  • Provides Advanced Administration techniques for SQL Server 2008 R2 as a book or eBook
  • Covers the essential Manageability, Programmability, and Security features
  • Emphasizes important High Availability features and implementation
  • Explains how to maintain and manage the SQL Server data platform effectively
Page Count 468
Course Length 14 hours 2 minutes
ISBN 9781849681445
Date Of Publication 23 May 2011


Satya Shyam K Jayanty

Satya Shyam K Jayanty is an Independent consultant working as a Principal Architect and Director for D Bi A Solutions Limited based in the UK. He has a Master's degree in Economics and Commerce from Osmania University, Hyderabad (India) and an MBA – Systems from the University of the West of England. Satya started his career in the IT industry in 1992, and he has been working with SQL Server (from version 4.2) for more than 15 years and has been an accomplished Microsoft SQL Server MVP for the last six years. Satya is a frequent speaker and SME volunteer at Microsoft Tech-Ed, SQL PASS, SQL Bits, Scottish Area SQL Server user group. He maintains a blog at and