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
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 Introducing 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 Integration Services Overview.
SQL Server Setup
Install, upgrade to, or change components in an instance of SQL Server. For more information, see Installation How-to Topics.