SQL Server Management Studio is still the tool most production DBAs live in day to day, and it has changed more in the last couple of years than the previous decade. There is a new install and update model, a different default connection security posture, and enough quality-of-life settings buried in menus that most people never find them.
This page collects the SSMS setup, scripted-install, and troubleshooting posts on this site, plus the settings and shortcuts that never earned their own post but are worth knowing anyway, organized by what you’re actually trying to do: get it installed, configure it the way you want, or fix the thing that just broke.
Installation & Maintenance
The manual walkthrough for a one-off install on your own workstation, or the scripted version below when you’re setting up more than one machine.
Silent by default, detects which installer framework is already on the box, and adds SSMS to PATH when it’s done. Built for fleet installs and repeat jump-host setups, not a one-off click-through.
Troubleshooting & Configuration
Which One You Need
- Fresh machine or SSMS won’t update: start with Install & Update, or the scripted version if you’re setting up more than one box.
- Suddenly can’t connect after an SSMS upgrade: it’s almost always the certificate chain trust error.
- Need to test as another account: Open as a Different Domain User.
- A query’s output looks cut off, or you can’t see something you expect in Results to Text: the 256-character limit.
- Coming back to SSMS after a few years away: start with What Changed in SSMS 21 and 22 below.
What Changed in SSMS 21 and 22
If you stepped away around SSMS 18 or 19, the tool you come back to is different in kind, not just in version number. SSMS 21 moved onto the Visual Studio 2022 shell: 64-bit at last, installed and updated through the Visual Studio Installer, with the first official dark theme and git built in. SSMS 22, the current line, sits on the Visual Studio 2026 shell and has been shipping updates roughly monthly (tracked in What’s New in SSMS 22 for DBAs). These are the changes that matter on a production estate; version-by-version download detail lives in the Install & Update post.
| Change | Why it matters |
|---|---|
| Modern connection dialog | The default since 22.0. Recent and favourite connections now go up to 60, and 22.9 added connection import and export, which finally makes a jump-host rebuild painless. |
| Execution plan in a new tab | Right-click a plan and choose Show Execution Plan in New Tab (22.0). Comparing two plans stops being a window-juggling exercise. |
| Results grid, grown up | A JSON viewer for JSON columns, independent zoom, the column’s data type on hover (22.6), and Save Results as Excel, JSON, Markdown or XML (22.4.1). No more paste-into-a-spreadsheet detour. |
| Group by schema in Object Explorer | Added in 22.4.1, the toggle sits between Refresh and Show Policy Health. On a database with hundreds of objects across schemas this is the single biggest navigation win in years. |
| Git, built in | Native since SSMS 21: clone, branch, commit and push from the Git menu, against GitHub or Azure DevOps. More on what that means for a DBA below. |
| GitHub Copilot | Generally available since 22.4.1 as the optional AI Assistance workload: chat, code completions, and an Agent Mode preview that gained DBA-shaped skills in 22.8, wait category analysis, slow-query investigation and IO pressure among them. |
| A native T-SQL formatter | In preview since 22.7, and by 22.9 the comma style, JOIN line breaks and alias style are all configurable, with a before-and-after preview in the settings. |
| SSIS is back | SSMS 21 shipped without it. 22.0 reinstated SSISDB catalog management, package execution and the Import Export Wizard. |
Git, for a DBA specifically: the practical win is your scripts folder finally living under version control on the same jump host you query from, without installing anything else. It versions files and SQL projects, not the database itself; schema-as-source workflows are what the separate Database DevOps workload (still in preview) is building towards. Clone your script repo once, and the diff before you run a changed script is one click instead of an act of faith.
Copilot, with your governance hat on: it needs SSMS 22 and a GitHub account (a free tier exists), and it installs as a separate workload, so it is opt-in per machine rather than something that arrives with an update. The defaults are sensible for production work: code completions ship disabled since 22.5.2, and as of 22.9 Ask mode can no longer execute arbitrary queries against the connected server. Treat it like any other tool with a connection string: useful for drafting and explaining T-SQL, and not something that should be pointed at production unreviewed.
Go Deeper on 21 and 22
Keyboard Shortcuts Worth Knowing
The handful that save real time every single session, not the exhaustive list: Query-window keys get their own deep dive in SSMS Query Shortcuts.
| Shortcut | What it does |
|---|---|
F5 |
F5, Ctrl+E, and Alt+X all execute. Alt+X is the one I use. |
Ctrl+R |
Toggle the Results pane, useful to reclaim screen space while writing a long query |
Alt+F1 |
Run sp_help against whatever object name the cursor is sitting on |
Ctrl+L / Ctrl+M |
Display the estimated execution plan / include the actual plan with the next execute. The two shortcuts a DBA uses more than anyone else |
Ctrl+F5 |
Parse the query without running it, the cheap sanity check before executing against production |
Ctrl+1 / Ctrl+2 |
Run sp_who / sp_lock against the current connection |
Ctrl+K, Ctrl+C |
Comment out the selected lines |
Ctrl+K, Ctrl+U |
Uncomment the selected lines |
Ctrl+Shift+U / Ctrl+Shift+L |
Uppercase / lowercase the selected text, handy for normalizing keyword casing |
Shift+Alt+Arrow |
Column (box) selection, select a vertical block instead of full lines, useful for editing a list of similar values in place |
Ctrl+Shift+R |
Refresh the IntelliSense local cache, the fix when IntelliSense is showing objects that no longer exist or missing ones that do |
Ctrl+1 and Ctrl+2 are query shortcuts, and the mechanism behind them is configurable: you can map Ctrl+3 through Ctrl+9 to any procedure you like, sp_whoisactive on Ctrl+3 is the classic. The settings live under Tools > Options > Environment > Keyboard > Query Shortcuts, and from SSMS 22.6 they moved into the new Unified Settings experience.
Frequently Asked Questions
Is SSMS still being actively updated?
Yes, more actively than it has been in years. It ships as a separate download from the SQL Server engine with its own release cadence, and the SSMS 22 line has been updating roughly monthly. See Install & Update above for where to get it and how the update checks work, and What Changed in SSMS 21 and 22 for the features worth knowing about.
Does SSMS have a dark theme?
Yes, officially, at last. SSMS 21 shipped the first supported dark theme and SSMS 22 extended theming further, adding new themes (and retiring the old Blue one) and bringing more of the dialogs into line. Pick a theme under Tools > Options and expect the odd unthemed dialog at the edges, the coverage has improved with each 22.x release.
What do I need to use Copilot in SSMS, and does it cost anything?
SSMS 22 or later, the AI Assistance workload ticked in the Visual Studio Installer, and a GitHub account. A free Copilot tier exists, so trying it costs nothing. It is opt-in per machine, code completions ship disabled by default, and as of 22.9 Ask mode cannot execute arbitrary queries against the connected server, which is the right default for anything production-shaped.
Can I use git without leaving SSMS?
Yes, since SSMS 21. The Git menu covers clone, branch, commit, push and stash against GitHub or Azure DevOps, which is enough to keep your scripts folder under version control on the jump host you already work from. It versions files, not the database; schema-as-source is what the separate Database DevOps workload (preview) is for.
What replaced Azure Data Studio?
Visual Studio Code with the MSSQL extension. Azure Data Studio was retired on 28 February 2026 and no longer gets updates or security fixes, and Microsoft’s guidance is to move to VS Code, where existing queries, scripts and database projects open without conversion. For production DBA work it still isn’t an SSMS replacement: the object-level dialogs, SQL Server Agent management and the Maintenance Plan designer are only in SSMS.
Why does SSMS suddenly refuse to connect after an update?
Almost always the certificate chain trust error, current SSMS versions default to encrypting the connection and validating the server’s certificate, which older instances running a self-signed cert weren’t set up to satisfy. See Fix the Certificate Chain Trust Error above for the actual cause and fix.
Can I install or remove SSMS across several machines without clicking through each one?
Yes, see the scripted Install & Update and Uninstall links above. Both are silent by default, log what they did, and are built for fleet or repeat jump-host setups rather than a single interactive install.
Can I run SSMS on Linux or macOS?
No, SSMS itself is Windows-only. From Linux or macOS the supported option is now Visual Studio Code with the MSSQL extension, since Azure Data Studio was retired in February 2026, or a plain sqlcmd session for anything scriptable.
If you work with an AI assistant alongside SSMS, the same reference behind these pages is available to it directly through the sqldba MCP server, so a question about an error number or a patch level gets a checked answer rather than a plausible one.
Where To Go Next
SSMS set up and behaving is the starting line, not the finish. Three directions from here, depending on what today actually is:
F5 runs it, Ctrl+R reclaims the screen, and Ctrl+Shift+R fixes IntelliSense when it lies to you. Jump back up for the full table.
Leave a Reply