New Features in SSMS Denali

Article
05/10/2011

1. Surround With Feature

This feature allows us to select a set of T-SQL statements and enclose them into Transactional, Conditional, & Looping etc. constructs like Begin-End, If-Else, & While etc.

Steps:

i) Open SSMS and open Query Editor

ii) Enter the query and select the query

iii) On selecting Surround With... from context menu, this brings up the Surround With menu with a list of options like Begin, while etc

iv) Select the appropriate one from the drop down came in the above step to enclose your statement to result as follows:

BEGIN

SELECT NAME, DEPARTMENT FROM EMPLOYEE

END

2. Insert Snippet Feature

This feature adds code snippet from the template explorer to the query window without opening the Template Explorer.

Steps:

i) Open SSMS and Open Query Editor

ii) Right Click in the query window and select "Insert Snippet".

iii) On selecting the insert snippet, it will show the folders present in the Insert Snippet. Select the one which is needed for you as follows:

iv) On selecting the appropriate folder, it will present you with the list of templates under the selected folder as follows:

v) Appropriate code snippet for the selected script will be inserted in the query window

3. Multiple Monitor Support

If you have multiple monitors you can drag a query window to another monitor. This is really useful for the people who have two or more SSMS running at a time.

4. SSISDB

You can deploy your Integration Services projects to the Integration Services server. The Integration Services server enables you to manage packages, run packages, and configure runtime values for packages by using environments.

Steps:

i) Open Object Explorer -> Integration Services folder

ii) Right Click the node and select "Create Catalog from the context menu as follows: