Brilliant
Inventions

Brilliant Inventions  /  Software

Two free tools for SQL Server Management Studio.

SSMS forgot two things: how to move a dozen open query tabs to another server at once, and how to give back the query you closed by accident. Brill Inventions for SSMS adds both, in one small extension.

Free, no account, no license key. Works with SSMS 18–20 and SSMS 21–22+. The setup program is not code-signed yet, so Windows SmartScreen may ask you to confirm on first run.

Tool 01

Change Connection for Multiple Tabs

Pick the tabs you want, connect once, and every one of them moves. Each tab is put back in the database it was using, on the new server — including on Azure SQL DB, where SSMS usually leaves tabs stranded in master.

Everything lives under Tools › Brill Inventions, and both commands are on a query tab’s right-click menu.

  • The tab picker follows your tab strip — left to right, with each tab’s server, database and login. Check all, check none, or check every tab on the same server.
  • Link Tabs saves a group, so the next time you open the dialog that group is already checked.
  • One Connect dialog, not twelve — SSMS asks for credentials once, then reconnects the rest silently.
  • Keep each tab’s current database is the default, and it works in SSMS 21 too.
  • A summary, not a wall of dialogs — results go to the status bar, and any tab that couldn’t follow is named once, with the log path.

Tool 02

Tab History

Every query tab is saved as it closes — including untitled ones and the ones where you answered No to “Save changes?”. Search everything you have ever closed and open it again in a new query window.

Nothing to switch on: it records in the background from the moment SSMS starts.

  • Search the whole text, or match on tab name, server or database. Several words must all match.
  • Reopen Closed Tab brings back the last one — bind it to Ctrl+Shift+T and it behaves like a browser.
  • Preview before you open, then double-click or press Enter to load it into a new query window.
  • Plain files, not a database — one .sql and one .meta per closed tab, in your own profile folder, kept for 60 days.
  • Copy, delete, open the folder — and if a reload loses the Connect dialog, the text goes to the clipboard instead of vanishing.

Install

Close SSMS before you start.

1 — Run the setup
Brill-Inventions-SSMS-Setup-2.0.0.exe asks for admin rights and lists every SSMS install it finds on the Ready page.
2 — Let it copy
It puts the right build into each SSMS (the VS 2017 shell for 18–20, the VS 2022 shell for 21+), and cleans up the old SsmsBulkConnectionChanger folder.
3 — Restart SSMS
Both tools appear under Tools › Brill Inventions. Uninstall from Add/Remove Programs; your saved Tab History is kept.
SSMS versionShellStatus
SSMS 18, 19, 20VS 2017 shellBuild included
SSMS 21, 22+VS 2022 shellBuild included
Silent install/VERYSILENT /SUPPRESSMSGBOXES

Your data stays on your machine. The extension writes a decision log and your closed tabs into your own profile folder. The log records no server, database or login names and no query text.

Building from source: the project ships with a PowerShell build for both shells and an Inno Setup script. Installing on other machines is what the setup program is for; the script is for the build machine.

← All software