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


Tools and Utilities are very useful for any data platform deployment, management, and administration. SQL Server includes a complete set of graphic tools and command-line utilities that are equipped with an impressive collection of management interfaces and services. These utilities allow all kinds of users to manage the day-to-day and essential tasks.

SQL Server Management Studio (SSMS) is the master of all the tools where many of the tools and utilities have been consolidated into SSMS. Also, the majority of the administrative tasks can be managed using a SQLCMD, PowerShell, and TSQL method, which requires SSMS to invoke these utilities. Inside the SSMS, we can invoke other tools such as SQL Server Profiler, Database Engine Tuning Advisor, or add other external tools in-house that are developed within the enterprise. During the installation of SQL Server, when we choose the Shared Features option, the setup will install various tools, such as Business Intelligence Development...