Denali — Day 11: SSMS enhancement

Denali — Day 11: SSMS enhancement

SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA to manage the system efficiently.

Like IntelliSense/Debug is introduced in sql server 2008 now in Denali it has improved.

Following are some of the new features added in management studio:

  1. snippet – templates

now you can easily insert the snippets like if you want to create function/trigger/index/table… just insert the snippet syntax will automatically inserted for it.

Just right click the cursor and select “insert snippet” or Ctrl+K+X    

You can add your own Snippets using “Tools-> Code Snippets Manager…” or Ctrl+K+B

  1. Surround With

This is another great feature of management studio where if you want to write a script and use surround with conditional statement like Begin, if, while.etc you can use the surround with option where the template of the script will be automatically set.

Just right click the cursor and select ” Surround With:” or Ctrl+K+S

This makes new bee very handy scripts /template and no need to remember the syntax of particular command.

  1. Cycle Clipboard Ring:

Most of the time you want to keep more than one text/commands to be copied and pasted if required but you could only copy last copied object and paste it, but now Denali introduced “Cycle Clipboard Ring” where you could copy multiple text and paste clipboard with Ring just press Ctrl+Shift+V (Edit – > Cycle Clipboard Ring)

  1. IntelliSense improvement:

    Till now IntelliSense is provide you the help on the first character, but now you could get the help for any related character

    Eg. If you press

    Select * from physical

    It will show you dm_db_index_pysical_stats

    This way it is very easy for you to get the dmv instead of remembering the dmv’s.


  2. Quick Info

    You can get the quick information about the objects by just moving the cursor on an object and it will show.

  1. Page Restore:

    Till now page restore is only available using T-Sql now from Denali you can use page restore using SSMS, with GUI it is easy to use.

    Just goto database and right click and select Task->Restore->Page

This entry was posted in Denali, Tool and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.