We have released SSMSBoost v3.3 Beta today.
Link:
http://www.ssmsboost.com...stInstaller_3.3.6690.msi Changelog:
-Post-Execution handlers are now powerful tool, allowing you to trigger different actions in SSMS,
after query execution is finished. SSMSBoost can be configured to execute command line
(or PowerShell) script, if query execution exceeds specific time-limit. Script can reference
executed query text, execution result, ResultsGrid data. Handlers can be triggered manually, using
Post-Exection handlers tool window (see new icon on the toolbar). Possible usage scenarios:
-Configure SSMS to send you the e-mail via outlook, when very-long queries finish execution.
Start long-running db maintenance query and go home. Receive execution result per e-mail when
it is finished.
-For debugging or educational purposes: save long-running queries source text to some specific
file location or database table for later analysis and improvement
-Pre-configure automatic steps for manual post-execution, like: script ResultsGrid to File as
Excel / Send it per E-mail as attachment
-Send "query execution complete" to yourself using your favorite messaging system, if it allows
to send messages from command line.
NOTE:here we provide only a couple of examples of possible usage of the functionality. We would be
glad to hear about your usage cases and receive your scripts. NONE of default Post-Execution
handlers is enabled for automatic triggering. Please review the list and set your preferred
parameters / triggering limits.
-Added support for SSMS 17.5
-Improved preferred connection switching logic: connection will be completely closed and re-opened,
if one of these parameters differ from the current connection: Server, User credentials, Additional
connection parameters. If not - only a database context is performed ("USE DATABASE")
Update 30.04.2018 (link above was updated as well).
Final Release uploaded, additional improvements:
-Improved compatibility with the latest version of SQL Server Azure Locate/Script object, Switch connection
and other functionality.
-Added "Trace" button, that allows to preview/copy to clipboard Post-Execution handler command in
live environment (mostly required to test newly created handlers)
-Autoreplacements now have new "{TrueServer}" parameter, that will return real SQL Server name when used
-Grid Visualizers support now multi-row operations: Previously it was possible to export cell contents
to file and preview it in associated viewer only in one-by-one mode. Now you can select multiple values,
select same visualizer and export all cells to separate files at once. Even more: you will be asked for the
column, that should provide filename for the exported files. For example, if you have database table that
stores PDF Invoices in one column, you can export them all to separate files, and have files named by value
provided in ID column.
-Floating messages, that SSMSBoost shows in the right-top corner now have "copy" button, that allows to
quickly save their contents to the clipboard.
-Fixed Aggregates functionality, that did not show "count" for binary values.
-Tested with SSMS 17.6
We will appreciate your feedback !
Edited by user
Monday, April 30, 2018 4:53:19 AM
|
Reason: Not specified