Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Introduction


Manageability is highly essential to optimize database management. Since SQL Server 2005, manageability has been integrated as a management tool suite with support for the automation of day-to-day tasks. There are multiple features within the core database engine, and the SQL Server Management Studio tool provides integrated management, proactive health monitoring, and improved performance techniques.

SQL Server 2008 and SQL Server 2008 R2 have a flurry of manageability features in the database administration arena. In this chapter, we will go through the important features such as auditing, security, compression, change tracking, policy-based management, data-tier applications, and SQL Server PowerShell Provider Cmdlets.