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!
