Upcoming T-SQL Toolbar and Context menu changes

  • Article

For our upcoming release, we made some changes to our connected SQL editor toolbar based on feedback from the MSDN forums, SQL Pass, and Microsoft Connect. We hope you like the new design.

Our design goals:
  • Streamlined experiences putting the most important things on the toolbar from left to right, then the context menu, then the main menus
  • Attempting to minimize relearning the user experience between SSMS and SSDT
New Toolbar

New Toolbar

 

Changes
  • Added “Parse” button (blue check box)
  • Change icon for “Display Executed Query Plan” and grouped it with Execute/Parse buttons
  • Added “The Results To…” fly out button.
  • Added “Display execution plan"
  • Added The SQLCMD mode button

We also changed the context menus to match, with similar design goals.

 
New Context Menu:

New Context Menu

Changes
  • Grouping Connection and Execution Settings as top-level items separate items.
  • Change icon for “Display Executed Query Plan” and grouped it with Execute/Parse buttons
  • Added The Results To… flyout
  • Added The SQLCMD mode button and Actual Execution options

 

In the screenshots above, I’ve shown what happens when you edit a connected query. While this illustrates the majority of changes, the other change is that you will also see this in non-build project files. Both project-focused  (refactor, etc.) and script-focused (Parse, plans, etc.) commands are supported in that scenario.