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

Getting SSMS onto your machine and tailoring it to your workflow is the natural starting point. Since SSMS 21 the installer rides on the Visual Studio shell, which is why you'll see command-line layouts, release channels, and the same Tools > Options surface that VS users know — plus newer touches like color themes and Presenter Mode for sharing your screen.

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+).