Learning the Tricks of the Trade - Microsoft SQL Server 2008 R2 Administration - page 403

10

Learning the Tricks of
the Trade

In this chapter, we will cover:

F Automated administration across an enterprise
F Administrating resource health policies
F Administrating Analysis Services using Tools
F Managing events capture to troubleshoot problems

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 Studio (BIDS), Client Tools Connectivity, Integration Services, Client Tools
Backwards Compatibility, Client Tools SDK, SQL Server Books Online, Management Tools
Basic, or Management Tools Complete that will include SQL Server Management Studio
(SSMS), SQL Server Connectivity SDK and Microsoft Sync Framework. For the configuration
and management of SQL Server services, we will use the SQL Server Configuration Manager.