Microsoft SQL Server 2008 R2 Administration Cookbook

Over 70 Practical Recipes for Administering a High-performance SQL Server 2008 R2 System

By: Satya Shyam KJayanty

Write A Review

eText | 24 May 2011 | Edition Number 1

At a Glance

Format
ePUB

eText

$74.79

or 4 interest-free payments of $18.70 with

Instant online reading in your Booktopia eTextbook Library *

Why choose an eTextbook?

Instant Access *

Purchase and read your book immediately

Read Aloud

Listen and follow along as Bookshelf reads to you

Study Tools

Built-in study tools like highlights and more

* eTextbooks are not downloadable to your eReader or an app and can be accessed via web browsers only. You must be connected to the internet and have no technical issues with your device or browser that could prevent the eTextbook from operating.

Book Description

This book offers practical, task-based, and immediately usable recipes covering a wide range of advanced techniques for administering a high-performance SQL Server 2008 R2 system. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, its explanations go into great detail, which makes it good learning material for everyone who has experience in SQL Server and wants to improve. The book is designed in such a way that you can either read it chapter by chapter or refer to recipes that you want in no particular order. Although the book is focused on specific Microsoft SQL Server 2008 R2, most of the concepts and explanations are also applicable to SQL Server 2008. If you are an experienced database administrator and database architect who wants to design, administer, and manage a scalable and high-performance SQL Server 2008 R2 system, then this book is for you. The book assumes that you have a good understanding of database management systems, specifically experience in Microsoft SQL Server 2008 administration.

What you will learn

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