Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

Chapter 5. Managing the Enterprise

• Using SQL Server Management Studio

• Managing SQL Server Groups

• Managing Servers

• Using Windows PowerShell for SQL Server Management

• Starting, Stopping, and Configuring SQL Server Agent

• Starting, Stopping, and Configuring Microsoft Distributed Transaction Coordinator

• Managing SQL Server Startup

• Managing Server Activity

Microsoft SQL Server Management Studio is the primary tool you use to manage database servers. Other tools available to manage local and remote servers include SQL Server Configuration Manager, Performance Monitor, and Event Viewer. You use SQL Server Configuration Manager to manage SQL Server services, networking, and client configurations. Performance Monitor is available to track SQL Server activity and ...