SSMS & Azure Data Studio
SQL Server Management Studio & 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 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-ver15SSMS Shortcuts
Generic
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+
SQL2008+
Ctrl+L - Display the estimated execution plan
SQL2019+
Many of the keyboard shortcuts have changed with the release of SQ2019.SQL2019+
Ctrl+Shift+Alt+L - Display the estimated execution plan
Azure Data Studio - SQL Notebooks
Azure Data Studio - SQL Notebooks
Bibliography
Bibliography
https://learn.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssmshttps://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts?view=sql-server-ver15
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/
http://www.e-squillace.com/ssms-tricks-shortcuts/https://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
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/
http://www.e-squillace.com/ssms-tricks-shortcuts/https://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