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 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 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. |
Concepts
Other Resources