SSMSBoost SSMS add-in: connection management, flexible grid results scripting, code navigation

Last Post 03 Aug 2012 03:16 PM by Andrei. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Andrei
New Member
New Member

--
03 Aug 2012 03:16 PM
Introducing SSMSBoost add-in for SQL Server Management Studio. (2008, 2008R2, 2012)
Main slogan: improve productivity, save clicks=save time

Features list (v 2.4)


-Locate object: quickly find object located at cursor position in object
explorer. Shortcut: [Ctrl-F2]. If you select part of the identifier - SSMSBoost
will use selection as identifier (must be done in comments).

-Script object located at cursor position directly from SQL Editor. Shortcut:[F2].
If you select part of the identifier - SSMSBoost will use selection as identifier
(must be done in comments).

-QuickConnection Switch combobox on SSMSBoost toolbar allows you to switch
current connection in SQLEditor window at a glance - including switching
between databases on different SERVERS ! (Native SSMS combobox can switch between
databases on current server only.)

-Format SQL Statements using built-in SQL Formatter feature.
Thanks for Tao Klerk and his Open Source "Poor Man's T-SQL Formatter"
(http://architectshack.com/PoorMansT...tter.ashx)

-Preferred connections: "remember" frequently used server/databases
-define connections to different servers/databases in SSMSBoost settings.These
connections will be also shown in QuickConnection Switch combobox on
SSMSBoost toolbar
-If Server names, you are working with, are too long and have no meaning, like
customerserver823127.hosteddomainsample.com you can define display name, like
customerserver823127.hosteddomainsample.com-> DEVELOPMENT
customerserver823555.hosteddomainsample.com-> PRODUCTION
-assign color for each connection that will be used in SQLEditor window
footer. It will help you to quickly distinguish for example between
development (=green) and production databases (=red). Important: works when
switch active window connection using QuickConnection Switch combobox.
-define if SSMSBoost should automatically connect object explorer to that
database at start-up
-define if SSMSBoost should automatically open empty script window at start-up
-You can quickly add any database displayed in object explorer to preferred
connections by clicking on it and selecting "Add to preferred connections".
Later - to go Settings->Preferred connections and fill-in remaining
properties, if you need.

-ResultsGrid scripter. Allows to script Results grid contents using
user defined templates. After scripting is done results can be placed to clipboard,
saved to file or saved to file&opened by specified application. For example, to
open results grid contents in Excel you only need a few clicks: Select desired rows
or Ctrl-A (select all) -> right click grid selection -> "Copy Data as" ->
-> "XML (Excel tweak)" -> "Save & Open". Done. Templates can be customized & added
by user. Feature is shipped with 7 pre-defeined templates

-GridResults visualizer. Allows to save contents of single cell to
disk and open with specified program. Applications: if your database keeps
Word documents, Excel files, pictures and other files in tables, you can open
these files directly from results grid. Just right-click the cell and
choose "Visualize as". Visualizers list is configurable. You can add your own
datatypes. Feature is pre-configured with visualisers for Excel, Word, Pictures,
Text.

-'Important' Database/Server Alert: Some users wanted to have additional
warning, when they have worked with "very important database". If you switch on
this feature for Preferred Connection, a permanent tooltip will appear at desired
position in SQL Editor window, showing you Informational/Warning message, that
you can customize. This is per-connection setting. You can choose color, font,
location.

-Copy results grid headers (column names)

-Copy grid cell contents 1:1 (preserving linebreaks and without truncation)

-Quickly Save and restore sessions (all open documents and their connections).
Auto-open chosen documents at start-up


-Customize caption of main SSMS window: add connection information and filename
of script being edited. This helps to distinguish between several instances of
SSMS when switching between them in task manager.

-Track current database in ObjectExplorer. Once or permanently: Whenever you
switch current connection in SQL Editor, current database will be focused in
Object Explorer

-Search for objects using wildcards: SSMSBoost has advanced Object Search dialog
that allows you to use wildcards when searching for objects

-Sometimes you want "Execute to Grid", sometimes "Execute to Text". Previously
you had to use mouse to switch between output modes, with SSMSBoost just press
[F5] - Execute to Grid,
[F6] - Execute to Text
Shortcuts can be redefined -see next feature

-Assign new keyboard shortcuts, change existing shortcuts.

-Define macros with existing commands. (Sample: [Execute to Grid] is configured
as a sequence of 2 commands: Query.ResultsToGrid, Query.Execute and assigned
Shortcut [F5]). In command Extras->Trace SSMS commands and Shortcuts will
make a full dump of all commands registered in SSMS. You can use all of them to
create own macros. Be creative, help yourself!

-Auto replacements allow you to write most used SQL commands more quickly. Type
"sel" and press space - it will be replaced by "select * from". "upd" will be
replaced by "update # set where". "#" defines, where cursor will be placed
after replacement is done. Add your own Auto-replacements !

-Scripting options: redefine standard scripting options. Be careful - you get
full access to all options. Some of them might not work. For experts use.


Acceptable Use Policy
---