SSMS & Azure Data Studio

SQL Server Management Studio & Azure Data Studio

Beginning in the 18.7 release of SQL Server Management Studio, Azure Data Studio is installed alongside SSMS automatically.

Install SSMS on your desktop or laptop (and/or jumpbox), AND on the SQL Server itself, BUT only run it on the SQL Server in an emergency. In fact, aim to only ever connect via RDP in an emergency. Starting an RDP session affects server performance. Starting SSMS affects server performance. Running SSMS from somewhere else and making a connection to SQL Server, in comparison, has minimal overhead.
SSMS runs on Windows only.
Azure Data Studio runs on Windows, MacOS and Linux and also supports plugins for PostgreSQL and Idera SQLdm

SSMS Shortcuts

Only my favourites are included here. For the full list visit: https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts?view=sql-server-ver15

Generic

  • F5 - Execute (query in query window)

  • F6 - Toggle between Query and Results panes

  • CTRL+1 - Run sp_who

  • CTRL+2 - Run sp_lock

  • ALF+F1 - Run sp_help

  • Shift-Alt-Enter - Toggle Fullscreen

SQL2008+

  • Ctrl+L - Display the estimated execution plan

SQL2019+

Many of the keyboard shortcuts have changed with the release of SQ2019.

  • Ctrl+Shift+Alt+L - Display the estimated execution plan


Azure Data Studio - SQL Notebooks

Bibliography


https://www.brentozar.com/archive/2020/07/how-to-get-started-with-sql-server-management-studio/https://am2.co/2020/04/should-i-install-ssms-on-a-server-running-sql-server/
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15http://www.e-squillace.com/ssms-tricks-shortcuts/https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts?view=sql-server-ver15https://am2.co/2018/02/updated-cheat-sheet/https://am2.co/wp-content/uploads/ShortcutsCheatSheet_18.1.pdfhttps://www.brentozar.com/archive/2014/01/ssms-trick-edit-large-procedures-with-the-splitter-bar/
https://sqlperformance.com/latest-builds/sql-server-management-studio
Snippetshttps://itsalljustelectrons.blogspot.com/2020/11/transact-sql-code-snippets.html
Activity Monitorhttps://stackoverflow.com/questions/51823868/activity-monitor-always-paused-in-ssms-17-8-1
Registered Servershttps://www.brentozar.com/archive/2016/04/one-weird-trick-for-managing-a-bunch-of-servers/
Central Management Server
18.7https://cloudblogs.microsoft.com/sqlserver/2020/10/20/sql-server-management-studio-18-7-now-generally-available/
Azure Data Studiohttps://cloudblogs.microsoft.com/sqlserver/2020/10/14/the-october-2020-release-of-azure-data-studio-is-now-available/https://www.brentozar.com/archive/2020/07/how-to-install-azure-data-studio-to-work-with-sql-server/https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15https://www.wiseowl.co.uk/blog/s2736/azure-data-studio-ssms.htmhttps://azure.microsoft.com/en-gb/updates/azure-data-studio-is-now-available/
Drawing in SSMShttps://www.linkedin.com/pulse/simple-guide-drawing-sql-server-ssms-technical-article-sullivan