Blog Post

SQL Server 2005 Management Tools

,

SQL Server 2005 includes a set of graphical tools and most of these are new with SQL Server 2005, there si a brief information of them:

  •  SQL Server Management Studio (SSMS)

It is an integrated environment for accessing, configuring, administering and developing all components and objects of SQL Server. SSMS combines the feature of Enterprise Manager & Query Analyzer ( from SQL Server 2000) into a single environment.

  • Business Intelligence Development Studio

Is an integrated development environment for Analysis Services, Reporting Services and Integration Services solutions that is based on Visual Studio. Visual Studio has templates that provides access for building business intelligence projects.

  • SQL Server Configuration Manager

Provides basic configuration management for the SQL Server Windows services, server protocols, client protocols and client aliases.

  • SQL Server Profiler

Provides a graphical user interface for monitoring an instance of the Database Engine or an instance of Analysis Services.

  • Database Engine Tuning Advisor

Helps to create optimal sets of indexes, indexed views, and partitions to improve database performance!

 

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating