Configuring SQL Server 2008 R2

After you have installed SQL Server, you can further configure SQL Server by using graphical and command-prompt utilities. The following table describes support for tools that are used to manage an instance of SQL Server:

Tool or utility

Description

SQL Server Management Studio

SQL Server Management Studio is used to edit and execute queries, and to start standard wizard tasks. For more information, see Using SQL Server Management Studio.

SQL Server Profiler

SQL Server Profiler provides a graphical user interface to monitor an instance of the SQL Server Database Engine or an instance of Analysis Services. For more information, see Introducing SQL Server Profiler.

Database Engine Tuning Advisor

The Database Engine Tuning Advisor helps you to create optimal sets of indexes, indexed views, and partitions. For more information, see Using Database Engine Tuning Advisor.

Business Intelligence Development Studio

Business Intelligence Development Studio is an integrated development environment for Analysis Services and Integration Services solutions. For more information, see Introducing Business Intelligence Development Studio.

Command Prompt Utilities

You can manage SQL Server objects from the command prompt. For more information, see Command Prompt Utilities.

SQL Server Configuration Manager

You can manage server and client network configuration settings. For more information, see SQL Server Configuration Manager.

Import and Export Data

Integration Services provides graphical tools and programmable objects to move, copy, and transform data. For more information, see Overview (Integration Services).

SQL Server Setup

Install, upgrade to, or change components in an instance of SQL Server. For more information, see Installation How-to Topics.