Profile cover photo
Profile photo
SSMSBoost Add-In
SSMSBoost productivity Add-in for SQL Server Management Studio
SSMSBoost productivity Add-in for SQL Server Management Studio


Post has attachment
SSMSBoost v2.18 is released !!

-Results Grid aggregates: SUM, AVG, MIN, MAX and COUNT are shown for 
 selected range of cells in Results Grid.
-Copy Results Grid data as XML spreadsheet (Excel). Right-click selected data range in Results Grid
 and choose "Copy selection as XML Spreadsheet".

Region start (-#region) and end (--#endregion) tokens can be customized to meet your 
 team's standards.
-Wildcards (*,?) are now allowed in "Find column in Results Grid". + improved user experience.
-"Match full cell" option added to "Find Data in Results Grid". + improved user experience.
-"Grid Scripting", "Find column in Results Grid", "Find Data in Results Grid" dialogs are now
 implemented as tool windows and can be docked in SSMS environment. This improves user experience,
 if you use them frequently.
-Improved "Fatal Actions Guard" output. Dialog can now show long list of warnings in usable form.
-Improved UI experience when creating first custom formatting template.
-"Features usage statistics" dialog shows now approximate time, SSMSBoost saved you. You can also sort by
 usage count and saved time. Use this dialog to find out if you are using all SSMSBoost features !
 Note, "saved time" values are approximate. See "SSMSBoost menu"->"Feature usage statistics".
-Improved resistance against corrupt config files.
-Fixed non-latin symbols export when scripting data for excel.
-Fixed "inconsistent end of line" issue in templates. Open/Save settings to update your templates.
-Fixed performance issues, when object explorer is connected to slow or unreacheable servers.
-Fixed installer to work after Windows 10 TH2 update.
Here is info about previous versions:
-Added possibility to use {Server},{Database} and {UserName} parameters in script execution history
-Added easy switching between search in results grid cells and column names
-Added possibility to specify "Exact match" when searching in results grid
-Fixed delimiting logic when copying column names from "find column" dialog
-Implemented Formatting option: SelectColumnsOptions.ListOptions.AlignAliases
-Fixed "Autoreplacement tigger" option persistence

-New possibilities in Grid Visualizers: now you can use cell contents directly as command line
 command or arguments. This allows you to call external applications passing ID's of your database
 objects, or even better: search Google or Wikipedia directly for strings from your database !
 2 new templates ("Search in google" and "Search in Wikipedia") will be added to your collection.

-Run your database query directly in Excel: select single SQL expression, press Excel button on the
 toolbar. SSMSBoost will export query and current connection information as Microsoft Database Query
 (.dby) format, which can be directly opened by Excel. Advantage is that data exported to Excel is
 not static: you can refresh it anytime from excel and use for reports or pivot tables. Note that
 this format has some limitations: only single SQL statement is supported and some other limitations
 may apply. Read (.dby) documentation to learn about this format. And yes, this feature can be used
 to restore your forgotten SQL Server Authentication passwords, if you still have connection
 "remembered" in SSMS. See SSMSBoost Settings->"Database Query (.dby)" for more information.

-Added "Copy Full Name to Clipboard" functionality in Object Explorer context menu for 
 Tables/View/Stored Procedures/Functions and some other objects. Object name is copied along with
 Schema and Database.

-Now you can place grid scripting results to clipboard and set one of 3 available clipboard formats:
 Text, HTML or XMLSpreadsheet. Default templates are updated, so you can script results to clipboard
 as XML Spreadsheet using default template and paste them directly to Excel. Same will work with 
 HTML Template: you can paste results directly to Outlook. Note, that scripting of HUGE volumes of
 data might be limited by available memory. This functionality is designed for reasonable amounts
 of data. UI for this functionality will be improved in coming versions. This is kind ob preview

-Improved Find Grid Column dialog: added display of datatypes, added short in-place help.
-Regions: added possibility to expand automatically all regions on document open. 
 See "Regions" settings.
-Possibility to let SSMSBoost to try to keep database with the same name active, while switching
 between different servers (for example DEV and PROD servers). To allow this functionality to work
 you must use Quick Connections Switch to switch between Preferred Connections and destination
 Preferred Connection should not contain pre-set database name. See "Preferred Connections" settings
-Code Guard: added possibility to treat JOIN as WHERE (meaning that such expressions are not 
 "dangerous" anymore)
-Code Guard: added information about line number where dangerous expression was found.
-Fixed: Restored "Intellisense completion mode" option, that has disappeared in 2.14. This option
 allows to pre-define "Intellisense completion mode" for new windows. This possibility has
 disappeared in native SSMS settings since SSMS 2012.
-Fixed: Ctrl-F shortcut in Results Grid (sometimes Find in Grid form did not appear)
-Fixed {PASTE} token documentation in Autoreplacements dialog

-Columns finder. Allows to find column by name within current or all result grids.
 Right-click results grid and choose "Find column" to use this feature.
-New real-time SQL Formatting styles templates editor. 
 See SSMSBoost menu->"SQL Formatting styles templates editor". Changes are applied directly
 to currently opened document during the modification of formatting template. This is our 
 first release. Test it. Write us your comments/proposals.
-Updates checker. SSMSBoost can not automatically check for udpdates. Feature is disabled by 
 default, you can enable it under Settings->Updates check.

-Pressing Ctrl-F in Results Grid will activate "Find in Grid" dialog. It was not possible
 to re-assign this shortcut using common way, so we have implemented a workaround.
Added UPPERCASE/LOWERCASE option to formatting templates. See TextCase>KeywordCase parameter.
 Note, due to some limitations implementation of this function requires a lot of time and special
 handling for some keywords. If you find keywords not affected by this setting please report them
 in our formum.
-Now you can use regular expressions to search in Results Grid
A lot of improvements to Fatal Actions Guard. Open Settings>"Fatal Actions Guard" and
 have a look at new options. We have added the possibility to ignore particular tables, to
 disable the guard with custom "magic tokens", ignore temporary tables and variables.
Add a comment...

SSMSBoost v 2.14 released !

-Fatal Actions Guard: monitors executed batches and warns or blocks (configurable) 
 DELETE and UPDATE statements without WHERE clause, or TRUNCATE TABLE statements. Additionally you
 are free to define additional tokens that can be blocked or will cause warning to appear. Feature
 can be individually enabled or disabled for preferred connections as well as default state can be
 defined for all other connections. See settings dialog
-Edit Top N Rows: use this standard SSMS feature, previously available only from object explorer now
 directly in SQL Editor. Right-click any table and select "Edit Top N Rows". Standard table data
 editor will be opened. "N" - number of rows can be defines in Standart SSMS Settings under
 Tools->Options->SQL Server Object Explorer->"Value for Edit Top <n> Rows command.
-Fixed malfunction of SSMS connection option "Additional connection parameters". SSMS does not
 save this field correctly, so users who need to override current windows account or domain were
 doomed to re-enter "Additional connection parameters" over and over again. Now you can use
 "Preferred connections" to save required parameters permanently. Supported starting from SSMS 2012

-Grid Scripting: added "Open output files in SSMS or Assiciated application" option
-Grid Scripting: added "Paste result in New Script window" option (when scripting to clipboard)
-Grid Scripting: added "Close dialog after scripting" option
-Autoreplacements: added option to make replaced text selected after autoreplacement was triggered.
-Autoreplacements: added global option to trigger autoreplacement even if native SSMS Intellisense
 drop-down is shown
-GridVisualizers: added parameter to define default scripting folder for Grid Visualizers
-Editor History: new configurable trigger "write on on execute"
-Recent connections: added possibility to add recent connection to preferred connections
-Settings dialog: added "copy to clipboard" links for all template paths
-Settings dialog: settings tree has got keyword filter. Just type "connection", "delete", "grid" and 
 settings tree will be reduced to relevant pages
-UI Fixes: Worspaces are now sorted by name, restored ability to sort preferred connections
-Internal improvements to Installer, handling special security cases
Add a comment...

SSMSBoost v 2.13 Released !
SQL Server 2014 is now supported !
(please re-post !)

Important notes:
-Please update all local installations of SSMSBoost to latest version of the same time. 
 For example SSMSBoost 2008, SSMSBosst 2012 and SSMSBoost 2014 should be updated to latest v 2.13.
 Mixing with 2.12 is not allowed.

-SSMS 2014 is now supported
-New flexible SQL Formatter with user-customizable templates. Allows deep customization of 
 formatter options. Note, this is first release with some kind of preview status. Previous formatter
 is available through "Old fashion formatter style" option on the toolbar. We encourage all 
 enthusiasts to use new formatter and write us your feedback and maybe even send your formatting 
 templates. Further development will be based on your feedback.
-Recent Connections list (see "Recent" menu). Keeps record of last connections.

-Added "Max document size" for SQL Editor history feature. Customize this value if you do not want 
 to create history entries for BIG files (like data dumps).
-Added "Max script size" and "Detail level" parameters to optimize Script Execution History feature.
-Unified headers of Script Execution History and Editor History features. Additional information
 includes now (whenever it is available): original file name, connection, event, execution time,
 result, execution duration.
-Recent sessions and recent tabs are moved to specialized launchers (see "Recent" menu)
-Changed the way Autoreplacements, Grid scripting templates, workspaces and 
 recent connections were saved: instead of using one big settings file, each entry is now saved as
 separate XML file on disk. This enables you to easily customize, share and backup your data.
 You can copy, share, delete XML files if you feel more comfortable this way. Be careful with 
 modifications: do not corrupt the files. Settings dialog displays links to file locations whenever
 it is appropriate.
-Completely new settings dialog. You can use filter to search for config pages. Try typing 
 "connection", "template", etc.. Template based-features
-Management of Autoreplacements, Grid Scripting and Grid visualizers templates in settings
 has new command "Add defaults". Use it to restore templates, originally provided with SSMSBoost.
 You can do it anytime: if you have already templates with the same name, new templates will be
 appended with unique suffix. If you are long-time user of SSMSBoost we encourage you to add
 default templates now and compare them to old ones (you can do it, by comparing XML files on the
 disk using any merge application, like WinMerge). We have updated default templates several times 
 already and recommend to use new editions.
-Recent tabs has 2 separate counters now: additionally you can specify now how many 
 unsaved "QueryX.sql" files should be remembered as recent tab. Even if you do not save files
 they are still saved in SSMSBoost history.
-New "Grid Scripting" dialog. Grid scripting can be now launched from the toolbar or grid context
 menu. Note, there is a breaking change in this version: due to shift to new technology old
 possibility to create toolbar buttons for particular scripting templates is temporary unavailable.
 We have plans to restore it and are glad to receive your feedback with proposals about usage
-Overall SSMS startup speed was improved.
-Created "SSMSBoost" menu right after "Tools" menu. Cleaned-up SSMSBoost toolbar and moved some 
 commands there.
-Created custom icons for SSMSBoost commands for Toolbar, SQLEditor context menu and 
 grid context menu
Add a comment...

SSMSBoost v 2.12 released

-Added "Regions" functionality. SSMSBoost supports/reuses existing regions syntax 
--#region [Name]
 Additionally we have improved this functionality by adding an option to automatically scan for
 declared regions upon opening of file. "Regions" Menu on the toolbar includes commands: 
 "Create region", "Create named region" and "refresh regions". "Create region" commands can be
 executed when some part of code is selected to include selection into newly created region.
-Vertical Guidelines for both SSMS 2008 and SSMS 2012 environments. Now you can configure SSMSBoost
 to display vertical guidelines at one or more positions. This helps to keep lines width under 
 control. By default SSMSBoost comes with 3 vertical guidelines at positions 80,100 and 120. You are
 free do adapt this setting to your personal preference: define alternative column positions and 
 color. Please note, that due to implementation differences you need to restart SSMS 2008 
 for changes to take effect. Changes in SSMS 2012 are visible immediately.
-"Recover last closed tab" button added to toolbar. SSMSBoost allows you to recover even
 unsaved documents.
-SSMS 2012 always sets "IntelliSence autocompletion" to "On" whenever you open a new query window.
 This is unfixed bug confirmed by Microsoft. We have added the possibility to define global default
 setting for IntelliSense behaviour. See General Settings->"Intellisense enabled by default" option.

-When scripting objects to new window using SSMSBoost "script object" command (F2) the new 
 tab name is pre-initialized with configurable filename instead of "QueryN.sql". Filename can be
 customized in General Settings->Scripting->Filename Customizaion and can contain 
 object name and schema.
-Autoreplacements can be configured to be triggered not only by enter/tab/space but by any
 character as well, like "("
-Autoreplacements can be provided with optional Displayname, which can be helpful when scrolling
 through the list of existing autoreplacements.
-Autoreplacements can be disabled by setting "Autoreplacements trigger" to None
-Improved compatibility when working with SQL2000 databases
-Due to improvements of "Recent tabs" functionality we had to rename "Sessions" to "Workspaces".
 "Workspace" (old "Session") is a permanent set of documents and their connections that can be 
 loaded instantly loaded into SSMS. It is useful for daily recurring tasks, where you work with
 known set of documents.
-"Recent Tabs" functionality contains now list of recent documents including their connections. 
 "Recent tabs"->"Sessions" contains list of recent Sessions, where last working environment can be
 restored completely with all documents and their connections. SSMSBoost recovers documents even if
 they were not saved by user (unsaved QueryN.sql documents)
-Added "Max document size" parameter under "Editor Contents History".If document exceeds specified
 size in bytes neither it's contents history will be logged, nor the execution history will be
 saved. Set to 0 - to remove limitation. Default limit is 10MB. Used to prevent SSMSBoost from
 saving history of database content dumps loaded as huge .sql files, consuming disk space and
 decreasing performance.
-Objects Search form can now script/copy multiple objects selected in search results
-Selecting part of identifier and running locate/script command will force SSMSBoost to consider
 only selected sub-string.
-Editor Contents History: Added original file path, event and timestamp header to autosaved files.
-Improved GOTO BEGIN/END performance on large files
-Improved behaviour: to save start-up time SSMSBoost will not open documents mentioned in preferred
 connections (open at start-up) if SSMS is started with command-line parameters.
Add a comment...

Post has attachment
If you like SSMSBoost add-in for SSMS, please vote for us in SQLServer Pro yearly voting:

We are listed in categories #5 and #8.

Voting ends on 27-th of September !
Add a comment...

SSMSBoost v2.10 released

-Grid scripting engine is now disk-buffered and can script big amounts of data from 
results grid.
-Updated parsing engine. "Locate object" and "Script Object" functionality now support
objects in other databases and linked servers. Note, you should have enough rights at
least to see those objects in Object Explorer to have possibility to locate/script them.
-Following parameters can be used in Autoreplacements: {User}, {Server}, {Database},
{Connection}, {Timestamp} , {Timestamp:Format} (.Net datetime format). They will be
replaced by current values from connection/time when autoreplacement is triggered.
-added new standard autoreplacement token "now" (case sensitive) as 
'{Timestamp:yyyy-MM-dd HH:mm:ss.fff}'.
Use it whenever you need current time in
your scripts. The output will look like: '2013-07-29 12:43:45.487'. Users of previous
versions can add it themselves using values provided above.
-SSMS template parameters syntax <name, type, default value> can be used in 
autoreplacements. If autoreplacement has SSMS parameter the parameters replacement 
dialog will be shown automatically (this behavior can be changed using global setting)
-New grid scripting template added: INSERT INTO (scripts results grid as a set of 
INSERT INTO statements). Users of previous versions can get this template here:
-added new autoreplacement "sis" (search in sources): simple SQL code to perform search
in source code of database objects using own SQL Server capabilities. Users of previous
versions can get this autoreplacement here:
-When SSMS environment has no active SQL Editor window the Preferred Connections dropdown
on the toolbar is not disabled anymore. Instead if you choose any preferred connection
a new SQL Editor window will be opened and connected.

-Objects Search window would sometimes not display if database diagram window was active
-Other minor improvements and bugs fixed
Add a comment...

SSMSBoost v2.9 released on April, 15-th

(Please, re-post if you like it !)

-Editor contents history: SSMSBoost regularly makes backup copies of your work to disk.
 You can choose events when checkpoints should be made. No copy will be saved if 
 nothing was changed since last checkpoint to save disk space. You can search in history 
 using new search form or use standard "find in files" functionality. Pay attention that
 this feature is disabled by default and should be enabled in settings.
-Reсent Tabs: allows to save quickly current set of tabs. SSMSBoost remembers document
 names and their connections. If documents are new and were not saved they will be still
 remembered. This feature might help you recover lost work after SSMS crashes or restore
 last tabs on the next day. This feature is different to old "Sessions" functionality: 
 Sessions are kind of "Document sets" or "Projects", which are supposed to live a long 
 time. "Recent Tabs" is more like standard "Recent documents" functionality. Note: this
 feature is disabled by default, you will have to enable it in settings.
-Executed Statements Logging: Saves executed statements with information about execution
 results to specified folder. Allows you to find queries that you have run some time ago
 and reuse them. Note, that this is the PREVIEW of the feature. Currently only dumping of
 executed statements is implemented. In next version we are going to release search form. 
 Note that format of logging files might be changed.
-Added new command to toggle /comment/ of current selection
-New option for "Copy headers" Results Grid feature, allowing to specify if column [names]
 should be delimited: always, never or automatically.
-SSMS template parameters syntax <name, type, default value> can be now used in Results 
 grid scripting templates. We have added option allowing to show dialog for parameters
 replacement BEFORE scripting begins. If you want to specify parameters AFTER scripting,
 then you can use built-in Template Parameters replacement (Ctrl-Shift-M)
-SSMSBoost install files and .dll are now digitally signed with code-signing certificate.
 Hopefully this will make easier installing SSMSBoost in corporate networks.

-Added separate formatters for DATE and TIME types support to Results Grid 
 scripting templates
-Autoreplacements can now use case-sensitive tokens (can be configured per token)
-Autoreplacements can now use custom symbol to specify new cursor location after 
 replacement is done (can be different per Autoreplacement)
-Autoreplacement tokens can include now non alpha-numeric symbols except of ()<>"\'*+=/.,
-Multiline autoreplacements now keep indent of starting position
-Add {ProjectName} and {Connection} patterns to "Custom SSMS window title" feature
-"New query window" parameter will be now "false" by default when 
 adding Preferred connection.
-When searching in Editor Contents History it is possible to use external configurable 
 comparison tool to compare different versions or previous version against current file.
-More information is now shown if SSMSBoost fails to establish connection to dead server
-Improvements in "Find in Grid" functionality
-added case-sensivity
-add possibility to mask * and ? via \
-improved working with search results. Just check all available options there.
-Other minor fixes in functionality and usability

-Added missing "LF" in CR/LF in Autoreplacements editor
-Fixed focus behavior, after "Find in Grid" command
-Fixed situation when command sometimes will not appear on toolbar, even if explicitly configured in SSMSBoost.
-Remove SSMS Installation path checks from SSMSBoost installers
-Updated "F" to "G" formatting in standard scripting templates for numbers
-Other small and big fixes
Add a comment...

SSMSBoost v2.8 released on January, 11-th

-Improved Results Grid scripting performance x4 times
-Added "Max chars per value" parameter to Grid Scripting templates. Useful when generating documents, which can not hold large amount of data, or when it does not make any sense (like scripting BLOB data just to view the value). 
-Search in Results Grid: improved "Find all" results. Added possibility to select all matched cells in grid (single cells or whole rows). This allows to script selected rows/cells or perform subsequent search within new selection.
-Added Spatial data types support to scripting templates.
Add a comment...

Post has attachment
In yearly SQL Server Pro voting
SSMSBoost got Bronze Community Choice Award in
Best Database Development Product category !
We were also mentioned as "Other Hot Product" in "Best Free Tool", Community Choice.
We thank all users who voted for our product !
Add a comment...

SSMSBoost v2.7 released on December, 4-th

-Added "Find in Results Grid" functionality. Search for strings in results grid using wildcards,
 Search for single values or output all results using "Find All" option. 
 (Accessible via right-click on the Results Grid)
-improved settings editor: multiline text is now easier to edit.
-updated default scripting templates formatting.

-object explorer would sometimes not navigate to "located" object
-other minor fixes
Add a comment...
Wait while more posts are being loaded