|
|
-
|
|
Few users are used to shortcuts in SSMS, where as users coming from Visual Studio background, might be used to certain shortcuts, which might be different from SSMS. Now for the users, who are used to Visual Studio, SQL Server 2012 allows to change the ...
|
|
-
|
|
Often in stored procedures/queries, we will use IF, BEGIN..END, WHILE statements. Now, In SQL Server 2012, SSMS provides an option “Surround with”, which simplifies in enclosing query statements with these blocks.
1. Right Click and choose “Surround w...
|
|
-
|
|
SQL Server 2012 SSMS has a new node “Sequences” in object explorer under Database-> programmability. This will allows you to create new sequences or update existing sequences by using GUI.
1. Go to Object Expolorer -> Expland database -> Programmabil...
|
|
-
|
|
Before SQL Server 2012, SSMS already provided a feature to debug the queries. In SQL Server 2012, this has been enhanced more to provide more rich experience.
1. Conditional Hit breakpoints ? Break point will hit only when the specified condition met...
|
|
-
|
|
Extended events provides very detailed information about, what is going inside in SQL Server. But before SQL Server 2012, there is not much UI support to create extended event sessions or configuring these sessions. There were some add-ins, which provid...
|
|
-
|
|
The default font in the query editor has been changed to Consolas in SQL Server Denali. Before denali, default font was Courier New....
|
|
-
|
|
Until SQL Server 2012, in SSMS, we were able to open only one query window. 2 or more query windows can't share the same screen. Only one query window can be visible on the screen.
Now SQL Server 2012 SSMS provides the option to open multiple query win...
|
|
-
|
|
Often in presentations, there is requirement of increasing size of content in SSMS. Until now, we used to use some third party softwares. Now SQL Server 2012 provides an option to increase/decrease the size.
We can individually configure the font-size ...
|
|
-
|
|
We often use some external tools to manage our task list, where we will add our tasks and will follow the tasks according to the task list. Now with SQL Server 2012, external tool is no longer required.
SQL Server 2012 provides task list, where we can ...
|
|
-
|
|
Code snippets is one of the very important feature that has been added in SQL Server 2012 SSMS, which greatly improves productivity. In SQL Server 2012, now you can create your own snippets and insert that snippets in your queries/stored procedures by u...
|
|