SQL SERVER – 2008 – Management Studio New Features

Pinalkumar Dave describes the top 5 features of SQL Server Management Studio 2008.

This article describes the top 5 features of SQL Server Management Studio 2008. With the release of SQL Server 2008 Microsoft has upgraded SSMS with many new features as well as added tons of new functionalities requested by DBAs for long time.

SQL Server 2008 has been released for a year now. In SQL Server 2000, DBA had to use two different tools to maintain the database as well as the query database, specifically SQL Server Enterprise Manager and SQL Server Query Analyzer. With the release of SQL Server 2005 both of these tools are combined into one tool: SQL Server Management Studio. For a while DBA who were fan of Query Analyzer requested to bring it back but as they keep on using SQL Server Management Studio (SSMS) they realized that it was much more convenient if every task related to SQL Server could be accomplished using SSMS. With the release of SQL Server 2008 Microsoft has upgraded SSMS with many new features as well as added tons of new functionalities requested by DBAs for long time.

Let us go over a few of the important new features of the SSMS 2008. The list of SQL Server 2008 SSMS improvements is very long. I have selected my favorite 5 features and we will go over them.

  1. IntelliSense for Query Editing
  2. Multi Server Query
  3. Query Editor Regions
  4. Object Explorer Enhancements
  5. Activity Monitors

Read Complete article here.

, , ,
Previous Post
SQL SERVER – Mirrored Backup and Restore and Split File Backup
Next Post
SQL SERVER – Logical Query Processing Phases – Order of Statement Execution

Related Posts

1 Comment. Leave new

  • Hello sir,
    IntelliSense for Query Editing is really nice features,
    It will save our time.
    Multi server Query are also great features.

    Reply

Leave a Reply

Menu