SSMS & Azure Data Studio

SQL Server Management Studio & Azure Data Studio

Databases

SQL Server

MSSQL Client Tools

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 & ADS Install

SQL Server

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://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

Page updated

Google Sites

Report abuse