Chapter 3. Working with SQL Server Tools

SQL Server 2008 provides a number of tools designed to make it easier for you to configure and manage your databases in a fashion comfortable to you. These tools include the graphical interfaces of SQL Server Configuration Manager and SQL Server Management Studio and the command-line utility SQLCMD.

In addition to these tools, SQL Server provides two important tools to help you tune and troubleshoot database server performance: Database Engine Tuning Advisor (DETA) and SQL Profiler. I discuss these latter two tools in Chapter 14.

In this chapter, you find out how to use SQL Server Configuration Manager, SQL Server Management Studio, and SQLCMD to take control of your SQL Server databases.

Using SQL Server Configuration Manager

SQL Server Configuration Manager is a lightweight tool that allows you to perform basic configuration of a SQL Server instance. You can use this tool to

  • Start and stop services

  • Change the service account used to start a service

  • Change the start mode of a service

  • Change the network protocols used by SQL Server

  • Change the IP addresses and TCP ports used by SQL Server

Launching SQL Server Configuration Manager

You can start SQL Server Configuration Manager by selecting it from the Start menu, as follows:

  1. Click the Windows button (or the Start button in Windows XP) in the lower-left corner of your screen.

  2. Click the All Programs item.

  3. Click the SQL Server 2008 folder.

  4. Click the Configuration Tools folder.

  5. Click the SQL Server Configuration ...

Get Microsoft® SQL Server® 2008 For Dummies® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.