Microsoft® SQL Server® 2012: Pocket Consultant

Chapter 1. Managing Your SQL Servers

• 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 MSDTC

• Managing SQL Server Startup

• Managing Server Activity

Microsoft SQL Server Management Studio is the primary tool you use to manage databases and servers. Other tools available to manage local and remote servers include SQL Server PowerShell, SQL Server Configuration Manager, Database Engine Tuning Advisor, and SQL Server Profiler. You use SQL Server Configuration Manager to manage SQL Server services, networking, and client configurations. Database Engine Tuning Advisor is available to help optimize ...