logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Andrei  
#1 Posted : Monday, March 26, 2018 1:32:56 PM(UTC)
Rank: Administration
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(UTC)  | Reason: Not specified

thanks 3 users thanked Andrei for this useful post.
Random Penguin on 3/27/2018(UTC), Alex T on 3/29/2018(UTC), Exabyte on 3/31/2018(UTC)
joid  
#2 Posted : Tuesday, March 27, 2018 9:05:37 AM(UTC)
Rank: Newbie
Thanks!
Tested "go to definition(f2)" functionality using ssms 17.6 - no problems
erikg  
#3 Posted : Wednesday, March 28, 2018 8:34:15 AM(UTC)
Rank: Newbie
works! Awesome job!
Exabyte  
#4 Posted : Saturday, March 31, 2018 1:39:28 PM(UTC)
Rank: Newbie
Right-click SCRIPT OBJECT AS CREATE/ALTER working now. BigGrin
Exabyte  
#5 Posted : Saturday, March 31, 2018 2:09:11 PM(UTC)
Rank: Newbie
What a great idea with the post-execution Email functionality for SQL executing for longer than defined time! This has great value but I would like to suggest 2 things perhaps:
1) This newly available functionality must be clear to users as most will not delve into settings under "Query Post-Execution Handlers" unless they know what to look for. But you main page is excellent with great examples of offerings so I am sure you will illustrate this there.
2) Even knowing about the functionality from reading the version history (which most don't do), I still struggled quite a bit to find out where to define Email recipient until I eventually copied and pasted contents of "Query Post-Execution Handlers" > "Handlers List" > "Status File path" into an editor making it easier to read. I would recommend separate input field for this.
Great job!!!
thanks 1 user thanked Exabyte for this useful post.
Andrei on 4/12/2018(UTC)
David Billingham  
#6 Posted : Monday, April 9, 2018 12:00:43 PM(UTC)
Rank: Newbie
Hi

The search function seems to be broken in this release (against Azure dbs) - it looks like the load of the objects from the current db fails. The database selected shows "loading" quickly (quicker than normal), but then nothing is searchable.

Was hoping that the script function (CREATE/ALTER) from the editor window would be working, but that still appears to be broken against Azure databases (get erroneous Linked Server error message).

Running 3.3.6659 with SSMS version 14.0.17213.0

Regards

David


Andrei  
#7 Posted : Thursday, April 12, 2018 5:26:10 AM(UTC)
Rank: Administration
Thank you very much for all the input, we are working on the second beta. Keep posting your notes.
Andrei  
#8 Posted : Monday, April 30, 2018 4:53:04 AM(UTC)
Rank: Administration
Update 30.04.2018 (link above was updated as well).
Today we release final Beta. Please post your comments/issues and if nothing serious will be found, we will post it as a release on 07.05.2018.
Link:
http://www.ssmsboost.com...stInstaller_3.3.6690.msi

Additional improvements made:

-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
Eduardo Junior  
#9 Posted : Monday, May 28, 2018 1:54:10 PM(UTC)
Rank: Newbie
404 - File or directory not found.
The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.
Micle  
#10 Posted : Wednesday, June 6, 2018 9:10:26 PM(UTC)
Rank: Newbie
Hi.
With last version SSMS crashed on queries with special characters.

Try:

select char(1)

/*copy result to clipboard*/

select '/*insert result from clipboard*/'

/*execute*/

SSMS 11.0.6607.3

Edited by user Thursday, June 7, 2018 8:47:02 PM(UTC)  | Reason: Not specified

codeowl  
#11 Posted : Wednesday, June 13, 2018 6:41:52 AM(UTC)
Rank: Newbie
I get the following error when I try to download:

Server Error

404 - File or directory not found.
The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable.

When I click on the link:
http://www.ssmsboost.com...stInstaller_3.3.6690.msi

Is there a newer link that works?
SSMSBoost  
#12 Posted : Friday, August 10, 2018 6:20:30 AM(UTC)
Rank: Administration
Quote:


Hi.
With last version SSMS crashed on queries with special characters.

Try:

select char(1)

/*copy result to clipboard*/

This is fixed in v3.4.
SSMSBoost  
#13 Posted : Friday, August 10, 2018 6:21:15 AM(UTC)
Rank: Administration
Please note, as soon as final release is done, all beta-links become obsolete.
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2018, Yet Another Forum.NET
This page was generated in 0.174 seconds.