Export (0) Print
Expand All

Configuring SQL Server "Denali"

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

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).

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft