SQL Server Management Studio (SSMS) Cheat Sheet

Updated 2026-04-21

SQL Server Management Studio (SSMS) is Microsoft's primary GUI for connecting to and managing SQL Server, Azure SQL, Microsoft Fabric SQL, and Azure Synapse Analytics, combining Object Explorer, administrative dialogs, a full-featured query editor, and integrated GitHub Copilot AI assistance. Starting with SSMS 21 (May 2025), the tool is built on the Visual Studio 2022 shell as a 64-bit application, and SSMS 22 (November 2025) adds ARM64 support, visual color themes, native Git integration, Database DevOps (SQL Projects), a Query Hint Recommendation Tool, and generally available GitHub Copilot with code completions and chat. Practitioners use SSMS to run and tune queries, script repeatable changes, perform maintenance tasks like backup/restore, monitor live workloads, and leverage AI code completions. A useful mental model is that most UI actions either generate T-SQL behind the scenes or act as a front-end over engine features (plans, Query Store, Agent, Extended Events). Keep your work reproducible by leaning on scripting features (Generate Scripts, templates, solutions/projects, SQL Projects) and by understanding the editor/connection options that change execution and results behavior.

What This Cheat Sheet Covers

This topic spans 17 focused tables and 160 indexed concepts. Below is a complete table-by-table outline of this topic, spanning foundational concepts through advanced details.

Table 1: Install, Update, and Configure SSMSTable 2: Connect, Authenticate, and Manage Server ContextTable 3: Object Explorer, Properties, and Object ManagementTable 4: Query Editor and Query Execution WorkflowTable 5: Editing, Search, Formatting, and Code AssistanceTable 6: Templates, Solutions, Projects, and Database DevOpsTable 7: Scripting and Script GenerationTable 8: Data Movement and Data-tier (BACPAC)Table 9: Backup and RestoreTable 10: Maintenance PlansTable 11: Monitoring and Performance TuningTable 12: Tracing, Diagnostics, and Visual DesignersTable 13: SQL Server Agent JobsTable 14: Git Integration and Source ControlTable 15: GitHub Copilot and AI AssistanceTable 16: Migration and ModernizationTable 17: Keyboard Shortcuts Reference

Table 1: Install, Update, and Configure SSMS

Setting	Example	Description
Install SSMS	`Download vs_SSMS.exe → Run → Install`	• Installs SSMS using the Visual Studio Installer • SSMS 21+ requires the VS 2022 shell and runs as a 64-bit application.
Update SSMS	`Help > Check for Updates`	Updates SSMS to a newer servicing or release build via the Visual Studio Installer notification.
Release channels	`Choose Preview vs Release channel`	Chooses how SSMS receives previews and general releases.
Release history	`Compare versions before upgrading`	Lists SSMS versions with links to their release notes.
Offline installation	`vs_SSMS.exe --layout C:\SSMSLayout`	Creates an offline layout folder for installing SSMS on machines without internet access.
Command-line parameters	`vs_SSMS.exe --add <workloadId> --passive`	Controls the installer from the command line — add/remove workloads, set language, create layouts, run silently.
SSMS configuration	`Tools > Options`	Central place for customizing SSMS environment and editor behavior.
Import/Export settings	`Tools > Import and Export Settings...`	Imports/exports SSMS environment settings (profiles, options) to share or back up configurations.
Color theme	`Tools > Options > Environment > General > Color theme`	Switches SSMS visual theme between Blue, Dark, Light, and other options (SSMS 21+).

Table 1: Install, Update, and Configure SSMS

Setting	Example	Description
Install SSMS	`Download vs_SSMS.exe → Run → Install`	• Installs SSMS using the Visual Studio Installer • SSMS 21+ requires the VS 2022 shell and runs as a 64-bit application.
Update SSMS	`Help > Check for Updates`	Updates SSMS to a newer servicing or release build via the Visual Studio Installer notification.
Release channels	`Choose Preview vs Release channel`	Chooses how SSMS receives previews and general releases.
Release history	`Compare versions before upgrading`	Lists SSMS versions with links to their release notes.
Offline installation	`vs_SSMS.exe --layout C:\SSMSLayout`	Creates an offline layout folder for installing SSMS on machines without internet access.
Command-line parameters	`vs_SSMS.exe --add <workloadId> --passive`	Controls the installer from the command line — add/remove workloads, set language, create layouts, run silently.
SSMS configuration	`Tools > Options`	Central place for customizing SSMS environment and editor behavior.
Import/Export settings	`Tools > Import and Export Settings...`	Imports/exports SSMS environment settings (profiles, options) to share or back up configurations.
Color theme	`Tools > Options > Environment > General > Color theme`	Switches SSMS visual theme between Blue, Dark, Light, and other options (SSMS 21+).