Features list / SSMSBoost version comparison

This page lists all functionality, provided by SSMSBoost add-in for SQL Server Management Studio. Table below provides some digest descriptions. Clicking on the name of the specific feature you will get more details about it's functionality. Note, that there are some differences between functionality of Free and Professional versions. See table below for reference. Licensing terms are additionally described at the bottom of the table.

The best way to learn SSMSBoost functionality is to install it and study SSMSBoost menu, that will appear on the SSMS Menu bar. We also recommend checking SSMSBoost settings, as far as they contain settings almost on every function provided by SSMSBoost.

Features	Community (Free)	Professional
Preferred connections Connection aliases Connection coloring Active and passive protection of important databases by visual warning and blocking of critical DML without WHERE clause Fixed SSMS issue with "Additional connection parameters" Automatically connect Object Explorer at startup Automatically open empty script window at startup Note, that in Community Edition the number of preferred connections is limited to 2
Quick Connection Switch Drop-down on toolbar, allowing to switch connections between servers
Connection Coloring Adjust Status Bar color depending on the current connection
Important Database alert Get additional visual alert when you connect to important databases
Auto-connect to databases at startup SSMSBoost connects Object Explorer to your preferred databases at startup
Auto-open new query window(s) at startup You can start SSMS with Object Explorer connected to your favorite databases
Set Connection from Object Explorer Set active SQL Editor connection directly from Object Explorer
Copy full object name from Object Explorer Copy full object name from Object Explorer to clipboard
Script Object Open source code of object located at cursor position in sql editor. Shortcut: [F2] Equal to "Go To Definition" function in Visual Studio. Object script is opened in "well-named" tab, containing object name and other information (customizable)
Edit Top N Table Rows Open table data editor directly from SQL Editor. Native SSMS function used in Object Explorer is now available in context menu of SQL Editor.
Locate Object Quickly find an object located at cursor position in Object Explorer. Shortcut: [CTRL+F2]
Track current database Focus current database in Object Explorer
Autoreplacements Auto replacements or "snippets" allow you to write frequently used SQL commands much faster
Custom SSMS window title Show filename, server/database of current document in SSMS title - template is customizable
Advanced objects search Search for objects across databases and servers using wildcards
Search for Object by Token Search for objects across multiple connections using text as filter string. Shortcut: [SHIFT+F2]
Select Current Statement You can quickly select and run current SQL Statement (SHIFT+F5)
Columns Organizer Columns Organizer
Pivot Builder Pivot Builder
Jump to BEGIN/END Quick navigation to BEGIN and END of the current block or between corresponding BEGIN/END tokens
Jump between brackets () Quick navigation between bracket pairs within statement
Jump between COLUMN/VALUE within INSERT statement Quick navigation between corresponding COLUMNs and VALUEs within INSERT statement
Comment/Uncomment selection using /**/ Comment/Uncomment selected SQL code using /**/ syntax in one click
Regions You can re-use well-known syntax: --#region [Name] --#endregion
SQL code formatting Format SQL Code using 2 different formatting engines:   SSMSBoost formatting engine: feature rich, multi-template   Old, but popular "Poor Man's T-SQL Formatter" as external formatting engine
Results Grid Scripting Flexible Template-based Results Grid Scripting useing pre-defined templates. Script as Excel document, JSON, XML, HTML, SQL Values List. Create your own scripting templates if you have special needs."
Copy Results Grid data to Excel Copy data from Results grid and paste it to Excel preserving data type information
Find in Results Grid Search for values in Results grid using wildcards and regular expressions
Find Columns in Results Grid Find column in Results grid Flexible search for columns in all Result sets
Copy Results Grid Headers Allows you to copy column names (all or selected) directly from Results grid
Copy cell data from ResultsGrid 1:1 Copies strings and data from Results grid preserving line breaks and full length
Copy as SQL values List Copy as comma-separated list which can be used in WHERE statement
Results Grid data Visualizers Visualize any data saved in cells: Pictures, Office Documents, PDF Files, etc
Recent connections SSMSBoost keeps track of last used databases/servers and allows to restore previous connections.
Recent Tabs Autorecovery of recent tabs, including unsaved documents and their connections. Includes "Restore last closed tab" feature known from Internet browsers
Recent Sessions Autorecovery of recent sessions, including unsaved documents and their connections
SQL Editor contents history Keep snapshots of SQL Editor contents while working on SQL Scripts. It is a much better feature than the built-in UNDO as it is permanently saved to your disk and can be opened anytime later
Executed SQL Statements History Keep track of executed SQL Statements, including additional information about execution context, result and duration.
Workspaces management Grouped frequently used documents info Workspaces (or Projects)
Vertical guidelines Display one or more vertical lines in SQL Editor to keep the length of your code lines under control
Fatal actions guard Protects you from running DML statements (UPDATE,DELETE) without WHERE clause. TRUNCATE TABLE is handled as well.
Run as Database Query (.dqy) in Excel One-click export of SQL query to MS Excel for further processing
Intellisense Completion Fix Fixes SSMS 2012 "Intellisense autocompletion" option persistence.
Results Grid Aggregates Calculate inplace SUM, MIN, MAX, COUNT, NULLs, Distinct Count, AVG and Data Lengths over selected cells in Results Grid
Post-Execution Handlers Stay notified when long-running queries execution completes.
Transactions Guard Displays a warning whenever SQL Editor has uncommitted transactions
Macros Define simple sequences of using existing SSMS and third-party commands and assign shortcuts to them
Manage keyboard shortcuts Define/Re-Define keyboard shortcuts   In SSMS Versions 2008-2014 using our custom Shortcut editor   In SSMS Versions 2016 and later using integrated editor
Dump all SSMS commands and shortcuts Outputs full list of native SSMS and third-party commands along with their shortcuts. Saves you a lot of time when looking for some specific command or all commands related to a specific keyword (like "regions").
Update Checker Automatically check for new SSMSBoost versions
Supported versions of SQL Server Management Studio	SSMS 2018 32 and 64 bit editions SSMS 2017 32 and 64 bit editions SSMS 2016 32 and 64 bit editions SSMS 2014 32 and 64 bit editions SSMS 2012 32 and 64 bit editions SSMS 2008 R2 32 and 64 bit editions SSMS 2008 32 and 64 bit editions
Licensing Professional license offers following benefits: One time activation, no limits, you are free to decide when to make upgrades. One year of updates is included with your purchase. New on-line licenses management platform is ready for small and large team needs. As Licensing administrator you will get separate token for every purchased license. You can distribute tokens in your team, without distributing master account information. Possibility to deactivate already activated licenses for migration purposes (hardware upgrades, passing the license to other employee) SSMSBoost team keeps releasing the add-in on constant basis since 2012, in average publishing new version every 3 months. There are over 40.000 users in more than 15.000 companies worldwide using our software. Here is link to EULA Free Community Edition mode has following conditions: Trial mode lasts for 30 days and does not require any activation All features are available in trial mode To continue usage after trial mode expiration you can request Free community license or buy the Professional License Users with community license need to download fresh version at least every 4 months (120 days) Whenever we release new version, trial mode restarts from the beginning, even if it was expired. This means, that free community license users get full access to all SSMSBoost features for 30 days after every release