MS SQL Server 2012 - DBA Articles

Management Tools of SQL Server 2012



Management Tools Description
SQL Server Management Studio SQL Server Management Studio is an integrated environment to access, configure, manage, administer, and develop components of SQL Server. Management Studio lets developers and administrators of all skill levels use SQL Server. Internet Explorer 6 SP1 or a later version is required for Management Studio installation.
SQL Server Configuration Manager SQL Server Configuration Manager provides basic configuration management for SQL Server services, server protocols, client protocols, and client aliases.
SQL Server Profiler SQL Server Profiler provides a graphical user interface to monitor an instance of the Database Engine or Analysis Services.
Database Engine Tuning Advisor Database Engine Tuning Advisor helps create optimal sets of indexes, indexed views, and partitions.
Data Quality Client Provides a highly simple and intuitive graphical user interface to connect to the DQS server, and perform data cleansing operations. It also allows you to centrally monitor various activities performed during the data cleansing operation. Internet Explorer 6 SP1 or a later version is required for the Data Quality Client installation.
SQL Server Data Tools SQL Server Data Tools (SSDT) provides an IDE for building solutions for the Business Intelligence components: Analysis Services, Reporting Services, and Integration Services.

(Formerly called Business Intelligence Development Studio).

SSDT also includes "Database Projects", which provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the enhanced Server Explorer in Visual Studio to easily create or edit database objects and data, or execute queries.

Internet Explorer 6 SP1 or a later version is required for SQL Server Data Tools installation.
Connectivity Components Installs components for communication between clients and servers, and network libraries for DB-Library, ODBC, and OLE DB.


More Reference URL: http://msdn.microsoft.com/en-us/library/ms144275%28v=sql.110%29.aspx

* * * * *


Email Your Comment To AUTHOR