Someone changed the keyboard shortcuts in my SSMS 2012 at a conference. Here is how to reset keyboard shortcuts back to the default settings.
SQL SERVER – Denali – Startup Parameters Easy to Configure
SQL Server Denali makes startup parameters easy to change. Here is the quick path in SQL Server Configuration Manager to the startup parameters screen.
SQL SERVER – 2012 – Zoom Query Editor
The zoom query editor feature in SQL Server 2012 makes code large enough for presentations, group discussions or anyone who prefers big fonts.
SQL SERVER – Denali – Clipboard Ring – CTRL+SHIFT+V
SQL Server Denali brings the clipboard ring from Visual Studio to SSMS. Copy a few items, then press CTRL+SHIFT+V to cycle through what you copied.
SQL SERVER – Change Database Access to Single User Mode Using SSMS
I showed before how to set single user mode with T-SQL before a backup. You can also set single user mode using SSMS, from the database properties page.
SQL SERVER – Upper Case Shortcut SQL Server Management Studio
Want an upper case shortcut in SSMS? Select a keyword and press CTRL+SHIFT+U to make it upper case, or CTRL+SHIFT+L to make it lower case.
SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan
Want to share a graphical execution plan? Save it as a .sqlplan file and send it. Anyone can open it in SSMS without the tables or indexes behind it.