Are you over 18 and want to see adult content?
More Annotations
A complete backup of www.mediasetplay.mediaset.it/article/chivuolesseremilionario/la-frase-di-little-richard-sono-la-regina-del-
Are you over 18 and want to see adult content?
A complete backup of www.bbc.com/news/entertainment-arts-51487371
Are you over 18 and want to see adult content?
A complete backup of www.almasryalyoum.com/news/details/1470987
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of goinginternational.eu
Are you over 18 and want to see adult content?
A complete backup of protorit.blogspot.com
Are you over 18 and want to see adult content?
A complete backup of hearclearhearing.com
Are you over 18 and want to see adult content?
A complete backup of huntermacros.org
Are you over 18 and want to see adult content?
Text
SSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers DOWNLOAD LATEST VERSION OF SSMSBOOST: SQL SERVER Versions history of SSMSBoost add-in for SQL Server Management Studio ***** SSMSBoost v3.12 - NEW: Added support for the latest Release of SSMS 18.8 (15.0.18369.0) - COMING SOON: we have prepared 2 new features: -Pivoting assist (that will allow you to transform the standard SQL Query into PIVOT construct) -"Expand *" - will allow to "explode" the * into single fields in the select statements. LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. ACTIVATE SSMSBOOST ADD-IN FOR MICROSOFT SQL SERVER SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
FORMAT/RE-FORMAT SQL DOCUMENT OR SELECTED PART OF CODE SSMSBoost allows you to format SQL Code using two different formatting engines. SSMSBoost formatting engine SSMSBoost formatting engine offers you a wide variety of options. The best way to learn them is to use a built-in Templates editor which will apply changes to the formatting template while you're editing it. To create/edit a formatting template: COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVER Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. INTELLISENSE COMPLETION FIX Intellisense Completion Fix. SSMS 2012 always sets "Intellisense autocompletion" to "On" whenever you open a new query window. This is the unfixed bug confirmed by Microsoft. SSMSBoost adds the possibility to define global default setting for IntelliSense behavior. Go to Settings->Advanced->Intellisense "Completion Mode" enabled by defaultand
SSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers DOWNLOAD LATEST VERSION OF SSMSBOOST: SQL SERVER Versions history of SSMSBoost add-in for SQL Server Management Studio ***** SSMSBoost v3.12 - NEW: Added support for the latest Release of SSMS 18.8 (15.0.18369.0) - COMING SOON: we have prepared 2 new features: -Pivoting assist (that will allow you to transform the standard SQL Query into PIVOT construct) -"Expand *" - will allow to "explode" the * into single fields in the select statements. LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. ACTIVATE SSMSBOOST ADD-IN FOR MICROSOFT SQL SERVER SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
FORMAT/RE-FORMAT SQL DOCUMENT OR SELECTED PART OF CODE SSMSBoost allows you to format SQL Code using two different formatting engines. SSMSBoost formatting engine SSMSBoost formatting engine offers you a wide variety of options. The best way to learn them is to use a built-in Templates editor which will apply changes to the formatting template while you're editing it. To create/edit a formatting template: COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVER Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. INTELLISENSE COMPLETION FIX Intellisense Completion Fix. SSMS 2012 always sets "Intellisense autocompletion" to "On" whenever you open a new query window. This is the unfixed bug confirmed by Microsoft. SSMSBoost adds the possibility to define global default setting for IntelliSense behavior. Go to Settings->Advanced->Intellisense "Completion Mode" enabled by defaultand
LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. EXECUTED SQL STATEMENTS LOGGING: SSMSBOOST ADD-IN FOR SQL This feature can be configured in SSMSBoost Settings->Script Execution History. You can define storage path, file naming template + a couple of other fine-tuning options. Use History->Find in Execution History for archived statements search. Refine your search with the help of date filter, size filter, wildcards and regular expressions. AUTOREPLACEMENTS: SSMSBOOST ADD-IN FOR SQL SERVER AutoReplacements or "snippets" allow you to input frequently used SQL commands much faster.Type "sel" and press SPACE, ENTER or TAB (configurable in Settings) - and it will be replaced with "select * from". "upd" will be replaced with "update # set where". "#" defines where cursor will be placed after the replacement is done (this symbol is customizable with the help of AutoReplacement). WORKSPACES: SSMSBOOST ADD-IN FOR SQL SERVER MANAGEMENT STUDIO Workspaces are helpful when you need to open some set of files connected to individual databases. If you have changing tasks/customers it might be reasonable to create an individual Workspace for each customer to easily load all scripts connected to the right databases at the right time. The functionality of Workspaces is similar to that of Recent Sessions but with extra possibilities of RECENT SESSIONS/RESTORE LAST SESSION Recent Sessions / Restore last session. SSMSBoost keeps track of your working environment and opened documents. In case of an unexpected failure you have the possibility to restore the last session or one of the previous sessions completely or partially. This includes restoring all saved (with filename) and unsaved (QueryN.sql) documents AUTO-CONNECT OBJECT EXPLORER TO DATABASES AT STARTUP Auto-connect Object Explorer to databases at startup. If this function is enabled SSMS will start with Object Explorer connected to your preferred databases. To use this option go to: SSMSBoost => Settings => Preferred Connections => List. Select the database connection that you want Object Explorer to automatically initialize at startup, click RESULTS GRID SCRIPTER (FLEXIBLE TEMPLATE-BASED RESULTS Results Grid Scripter is a powerful tool that allows you to script data from Result Grid to disk or clipboard in different formats with the help of customizable scripting templates. It takes just a few clicks to export data from Results grid to Excel (as XML spreadsheet) or your Web browser (as HTML table). JUMP BETWEEN COLUMN/VALUE WITHIN INSERT STATEMENT The solution is to use " Jump between COLUMN and VALUE " command in SQL Editor context menu. You can also use universal "JUMP" shortcuts Ctrl+Shift+Up Arrow to navigate "UP" (from VALUE to COLUMN) or Ctrl+Shift+Down Arrow to navigate "Down" (from COLUMN to VALUE). For better visibility the corresponding COLUMN/VALUE pairs arehighlighted.
PREFERRED CONNECTIONS: "REMEMBER" FREQUENTLY USED SERVERS This functionality may be very convenient for those who have to deal with several servers on a daily basis. Preferred connections allow you to remember your favorite servers/databases and pre-configure several connection settings. Following options can be configured under SSMSBoost ->Settings->Preferred connections->List:. Connection alias NEW FORMATTER/OLD FORMATTTER Thursday, August 21, 2014 1:49:20 PM. You can select "old style formatting" on the toolbar to use old formatter. New formatter is very flexible but requires additional actions to configure it to suit your needs. Currently we accumulate user feedback andSSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers DOWNLOAD LATEST VERSION OF SSMSBOOST: SQL SERVER Versions history of SSMSBoost add-in for SQL Server Management Studio ***** SSMSBoost v3.12 - NEW: Added support for the latest Release of SSMS 18.8 (15.0.18369.0) - COMING SOON: we have prepared 2 new features: -Pivoting assist (that will allow you to transform the standard SQL Query into PIVOT construct) -"Expand *" - will allow to "explode" the * into single fields in the select statements. LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. ACTIVATE SSMSBOOST ADD-IN FOR MICROSOFT SQL SERVER SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
FORMAT/RE-FORMAT SQL DOCUMENT OR SELECTED PART OF CODE SSMSBoost allows you to format SQL Code using two different formatting engines. SSMSBoost formatting engine SSMSBoost formatting engine offers you a wide variety of options. The best way to learn them is to use a built-in Templates editor which will apply changes to the formatting template while you're editing it. To create/edit a formatting template: COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVER Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. INTELLISENSE COMPLETION FIX Intellisense Completion Fix. SSMS 2012 always sets "Intellisense autocompletion" to "On" whenever you open a new query window. This is the unfixed bug confirmed by Microsoft. SSMSBoost adds the possibility to define global default setting for IntelliSense behavior. Go to Settings->Advanced->Intellisense "Completion Mode" enabled by defaultand
SSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers DOWNLOAD LATEST VERSION OF SSMSBOOST: SQL SERVER Versions history of SSMSBoost add-in for SQL Server Management Studio ***** SSMSBoost v3.12 - NEW: Added support for the latest Release of SSMS 18.8 (15.0.18369.0) - COMING SOON: we have prepared 2 new features: -Pivoting assist (that will allow you to transform the standard SQL Query into PIVOT construct) -"Expand *" - will allow to "explode" the * into single fields in the select statements. LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. ACTIVATE SSMSBOOST ADD-IN FOR MICROSOFT SQL SERVER SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
FORMAT/RE-FORMAT SQL DOCUMENT OR SELECTED PART OF CODE SSMSBoost allows you to format SQL Code using two different formatting engines. SSMSBoost formatting engine SSMSBoost formatting engine offers you a wide variety of options. The best way to learn them is to use a built-in Templates editor which will apply changes to the formatting template while you're editing it. To create/edit a formatting template: COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVER Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. INTELLISENSE COMPLETION FIX Intellisense Completion Fix. SSMS 2012 always sets "Intellisense autocompletion" to "On" whenever you open a new query window. This is the unfixed bug confirmed by Microsoft. SSMSBoost adds the possibility to define global default setting for IntelliSense behavior. Go to Settings->Advanced->Intellisense "Completion Mode" enabled by defaultand
LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. EXECUTED SQL STATEMENTS LOGGING: SSMSBOOST ADD-IN FOR SQL This feature can be configured in SSMSBoost Settings->Script Execution History. You can define storage path, file naming template + a couple of other fine-tuning options. Use History->Find in Execution History for archived statements search. Refine your search with the help of date filter, size filter, wildcards and regular expressions. AUTOREPLACEMENTS: SSMSBOOST ADD-IN FOR SQL SERVER AutoReplacements or "snippets" allow you to input frequently used SQL commands much faster.Type "sel" and press SPACE, ENTER or TAB (configurable in Settings) - and it will be replaced with "select * from". "upd" will be replaced with "update # set where". "#" defines where cursor will be placed after the replacement is done (this symbol is customizable with the help of AutoReplacement). COMMENT/UNCOMMENT SELECTED CODE: SSMSBOOST ADD-IN FOR SQL Comment/Uncomment selection. SSMS has a standard feature that allows you to comment selected text, however, it uses "--" syntax, thus making it impossible to insert comments within the line. SSMSBoost added a smart /*comment selection*/ feature which does exactly what developers expect it to do: it puts /**/ marks at both sides of theselected
RECENT SESSIONS/RESTORE LAST SESSION Recent Sessions / Restore last session. SSMSBoost keeps track of your working environment and opened documents. In case of an unexpected failure you have the possibility to restore the last session or one of the previous sessions completely or partially. This includes restoring all saved (with filename) and unsaved (QueryN.sql) documents AUTO-CONNECT OBJECT EXPLORER TO DATABASES AT STARTUP Auto-connect Object Explorer to databases at startup. If this function is enabled SSMS will start with Object Explorer connected to your preferred databases. To use this option go to: SSMSBoost => Settings => Preferred Connections => List. Select the database connection that you want Object Explorer to automatically initialize at startup, click RESULTS GRID SCRIPTER (FLEXIBLE TEMPLATE-BASED RESULTS Results Grid Scripter is a powerful tool that allows you to script data from Result Grid to disk or clipboard in different formats with the help of customizable scripting templates. It takes just a few clicks to export data from Results grid to Excel (as XML spreadsheet) or your Web browser (as HTML table). JUMP BETWEEN COLUMN/VALUE WITHIN INSERT STATEMENT The solution is to use " Jump between COLUMN and VALUE " command in SQL Editor context menu. You can also use universal "JUMP" shortcuts Ctrl+Shift+Up Arrow to navigate "UP" (from VALUE to COLUMN) or Ctrl+Shift+Down Arrow to navigate "Down" (from COLUMN to VALUE). For better visibility the corresponding COLUMN/VALUE pairs arehighlighted.
PREFERRED CONNECTIONS: "REMEMBER" FREQUENTLY USED SERVERS This functionality may be very convenient for those who have to deal with several servers on a daily basis. Preferred connections allow you to remember your favorite servers/databases and pre-configure several connection settings. Following options can be configured under SSMSBoost ->Settings->Preferred connections->List:. Connection alias NEW FORMATTER/OLD FORMATTTER Thursday, August 21, 2014 1:49:20 PM. You can select "old style formatting" on the toolbar to use old formatter. New formatter is very flexible but requires additional actions to configure it to suit your needs. Currently we accumulate user feedback andSSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers AUTOREPLACEMENTS: SSMSBOOST ADD-IN FOR SQL SERVER AutoReplacements or "snippets" allow you to input frequently used SQL commands much faster.Type "sel" and press SPACE, ENTER or TAB (configurable in Settings) - and it will be replaced with "select * from". "upd" will be replaced with "update # set where". "#" defines where cursor will be placed after the replacement is done (this symbol is customizable with the help of AutoReplacement). CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVER Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. EXECUTED SQL STATEMENTS LOGGING: SSMSBOOST ADD-IN FOR SQL This feature can be configured in SSMSBoost Settings->Script Execution History. You can define storage path, file naming template + a couple of other fine-tuning options. Use History->Find in Execution History for archived statements search. Refine your search with the help of date filter, size filter, wildcards and regular expressions. AUTO-CONNECT OBJECT EXPLORER TO DATABASES AT STARTUP Auto-connect Object Explorer to databases at startup. If this function is enabled SSMS will start with Object Explorer connected to your preferred databases. To use this option go to: SSMSBoost => Settings => Preferred Connections => List. Select the database connection that you want Object Explorer to automatically initialize at startup, click SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. JUMP BETWEEN COLUMN/VALUE WITHIN INSERT STATEMENT The solution is to use " Jump between COLUMN and VALUE " command in SQL Editor context menu. You can also use universal "JUMP" shortcuts Ctrl+Shift+Up Arrow to navigate "UP" (from VALUE to COLUMN) or Ctrl+Shift+Down Arrow to navigate "Down" (from COLUMN to VALUE). For better visibility the corresponding COLUMN/VALUE pairs arehighlighted.
SCRIPT GRID DATA NOT WORKING 54.2% (Neutral) I just installed SSMSBoost (version info below) on a new computer that is using SSMS 2016. So far, I can not get the Script Grid Data feature to work. When I select the grid and click the Script Grid Data button, the screen blinks like it is trying to open a dialog, but nothing shows up. It's almost like the pop-up is blocked.SSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers AUTOREPLACEMENTS: SSMSBOOST ADD-IN FOR SQL SERVER AutoReplacements or "snippets" allow you to input frequently used SQL commands much faster.Type "sel" and press SPACE, ENTER or TAB (configurable in Settings) - and it will be replaced with "select * from". "upd" will be replaced with "update # set where". "#" defines where cursor will be placed after the replacement is done (this symbol is customizable with the help of AutoReplacement). CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVER Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. EXECUTED SQL STATEMENTS LOGGING: SSMSBOOST ADD-IN FOR SQL This feature can be configured in SSMSBoost Settings->Script Execution History. You can define storage path, file naming template + a couple of other fine-tuning options. Use History->Find in Execution History for archived statements search. Refine your search with the help of date filter, size filter, wildcards and regular expressions. AUTO-CONNECT OBJECT EXPLORER TO DATABASES AT STARTUP Auto-connect Object Explorer to databases at startup. If this function is enabled SSMS will start with Object Explorer connected to your preferred databases. To use this option go to: SSMSBoost => Settings => Preferred Connections => List. Select the database connection that you want Object Explorer to automatically initialize at startup, click SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. JUMP BETWEEN COLUMN/VALUE WITHIN INSERT STATEMENT The solution is to use " Jump between COLUMN and VALUE " command in SQL Editor context menu. You can also use universal "JUMP" shortcuts Ctrl+Shift+Up Arrow to navigate "UP" (from VALUE to COLUMN) or Ctrl+Shift+Down Arrow to navigate "Down" (from COLUMN to VALUE). For better visibility the corresponding COLUMN/VALUE pairs arehighlighted.
SCRIPT GRID DATA NOT WORKING 54.2% (Neutral) I just installed SSMSBoost (version info below) on a new computer that is using SSMS 2016. So far, I can not get the Script Grid Data feature to work. When I select the grid and click the Script Grid Data button, the screen blinks like it is trying to open a dialog, but nothing shows up. It's almost like the pop-up is blocked. EXECUTED SQL STATEMENTS LOGGING: SSMSBOOST ADD-IN FOR SQL This feature can be configured in SSMSBoost Settings->Script Execution History. You can define storage path, file naming template + a couple of other fine-tuning options. Use History->Find in Execution History for archived statements search. Refine your search with the help of date filter, size filter, wildcards and regular expressions. LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. WORKSPACES: SSMSBOOST ADD-IN FOR SQL SERVER MANAGEMENT STUDIO Workspaces are helpful when you need to open some set of files connected to individual databases. If you have changing tasks/customers it might be reasonable to create an individual Workspace for each customer to easily load all scripts connected to the right databases at the right time. The functionality of Workspaces is similar to that of Recent Sessions but with extra possibilities of FORMAT/RE-FORMAT SQL DOCUMENT OR SELECTED PART OF CODE SSMSBoost allows you to format SQL Code using two different formatting engines. SSMSBoost formatting engine SSMSBoost formatting engine offers you a wide variety of options. The best way to learn them is to use a built-in Templates editor which will apply changes to the formatting template while you're editing it. To create/edit a formatting template: RECENT SESSIONS/RESTORE LAST SESSION Recent Sessions / Restore last session. SSMSBoost keeps track of your working environment and opened documents. In case of an unexpected failure you have the possibility to restore the last session or one of the previous sessions completely or partially. This includes restoring all saved (with filename) and unsaved (QueryN.sql) documents COMMENT/UNCOMMENT SELECTED CODE: SSMSBOOST ADD-IN FOR SQL Comment/Uncomment selection. SSMS has a standard feature that allows you to comment selected text, however, it uses "--" syntax, thus making it impossible to insert comments within the line. SSMSBoost added a smart /*comment selection*/ feature which does exactly what developers expect it to do: it puts /**/ marks at both sides of theselected
PREFERRED CONNECTIONS: "REMEMBER" FREQUENTLY USED SERVERS This functionality may be very convenient for those who have to deal with several servers on a daily basis. Preferred connections allow you to remember your favorite servers/databases and pre-configure several connection settings. Following options can be configured under SSMSBoost ->Settings->Preferred connections->List:. Connection aliasFATAL ACTIONS GUARD
Fatal Actions Guard parses scripts executed in SSMS and checks for potentially dangerous statements like DELETE or UPDATE with missing WHERE clause or the usage of TRUNCATE statement which bypasses delete triggers. To get the overview of this feature go to SSMSBoost Settings -> Fatal Actions Guard: It is possible to set an action if critical INTELLISENSE COMPLETION FIX Intellisense Completion Fix. SSMS 2012 always sets "Intellisense autocompletion" to "On" whenever you open a new query window. This is the unfixed bug confirmed by Microsoft. SSMSBoost adds the possibility to define global default setting for IntelliSense behavior. Go to Settings->Advanced->Intellisense "Completion Mode" enabled by defaultand
RESULTS GRID SCRIPTER (FLEXIBLE TEMPLATE-BASED RESULTS Results Grid Scripter is a powerful tool that allows you to script data from Result Grid to disk or clipboard in different formats with the help of customizable scripting templates. It takes just a few clicks to export data from Results grid to Excel (as XML spreadsheet) or your Web browser (as HTML table).SSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers AUTOREPLACEMENTS: SSMSBOOST ADD-IN FOR SQL SERVER AutoReplacements or "snippets" allow you to input frequently used SQL commands much faster.Type "sel" and press SPACE, ENTER or TAB (configurable in Settings) - and it will be replaced with "select * from". "upd" will be replaced with "update # set where". "#" defines where cursor will be placed after the replacement is done (this symbol is customizable with the help of AutoReplacement). CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVER Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. EXECUTED SQL STATEMENTS LOGGING: SSMSBOOST ADD-IN FOR SQL This feature can be configured in SSMSBoost Settings->Script Execution History. You can define storage path, file naming template + a couple of other fine-tuning options. Use History->Find in Execution History for archived statements search. Refine your search with the help of date filter, size filter, wildcards and regular expressions. AUTO-CONNECT OBJECT EXPLORER TO DATABASES AT STARTUP Auto-connect Object Explorer to databases at startup. If this function is enabled SSMS will start with Object Explorer connected to your preferred databases. To use this option go to: SSMSBoost => Settings => Preferred Connections => List. Select the database connection that you want Object Explorer to automatically initialize at startup, click SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. JUMP BETWEEN COLUMN/VALUE WITHIN INSERT STATEMENT The solution is to use " Jump between COLUMN and VALUE " command in SQL Editor context menu. You can also use universal "JUMP" shortcuts Ctrl+Shift+Up Arrow to navigate "UP" (from VALUE to COLUMN) or Ctrl+Shift+Down Arrow to navigate "Down" (from COLUMN to VALUE). For better visibility the corresponding COLUMN/VALUE pairs arehighlighted.
SCRIPT GRID DATA NOT WORKING 54.2% (Neutral) I just installed SSMSBoost (version info below) on a new computer that is using SSMS 2016. So far, I can not get the Script Grid Data feature to work. When I select the grid and click the Script Grid Data button, the screen blinks like it is trying to open a dialog, but nothing shows up. It's almost like the pop-up is blocked.SSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers AUTOREPLACEMENTS: SSMSBOOST ADD-IN FOR SQL SERVER AutoReplacements or "snippets" allow you to input frequently used SQL commands much faster.Type "sel" and press SPACE, ENTER or TAB (configurable in Settings) - and it will be replaced with "select * from". "upd" will be replaced with "update # set where". "#" defines where cursor will be placed after the replacement is done (this symbol is customizable with the help of AutoReplacement). CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVER Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. EXECUTED SQL STATEMENTS LOGGING: SSMSBOOST ADD-IN FOR SQL This feature can be configured in SSMSBoost Settings->Script Execution History. You can define storage path, file naming template + a couple of other fine-tuning options. Use History->Find in Execution History for archived statements search. Refine your search with the help of date filter, size filter, wildcards and regular expressions. AUTO-CONNECT OBJECT EXPLORER TO DATABASES AT STARTUP Auto-connect Object Explorer to databases at startup. If this function is enabled SSMS will start with Object Explorer connected to your preferred databases. To use this option go to: SSMSBoost => Settings => Preferred Connections => List. Select the database connection that you want Object Explorer to automatically initialize at startup, click SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. JUMP BETWEEN COLUMN/VALUE WITHIN INSERT STATEMENT The solution is to use " Jump between COLUMN and VALUE " command in SQL Editor context menu. You can also use universal "JUMP" shortcuts Ctrl+Shift+Up Arrow to navigate "UP" (from VALUE to COLUMN) or Ctrl+Shift+Down Arrow to navigate "Down" (from COLUMN to VALUE). For better visibility the corresponding COLUMN/VALUE pairs arehighlighted.
SCRIPT GRID DATA NOT WORKING 54.2% (Neutral) I just installed SSMSBoost (version info below) on a new computer that is using SSMS 2016. So far, I can not get the Script Grid Data feature to work. When I select the grid and click the Script Grid Data button, the screen blinks like it is trying to open a dialog, but nothing shows up. It's almost like the pop-up is blocked. EXECUTED SQL STATEMENTS LOGGING: SSMSBOOST ADD-IN FOR SQL This feature can be configured in SSMSBoost Settings->Script Execution History. You can define storage path, file naming template + a couple of other fine-tuning options. Use History->Find in Execution History for archived statements search. Refine your search with the help of date filter, size filter, wildcards and regular expressions. LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. WORKSPACES: SSMSBOOST ADD-IN FOR SQL SERVER MANAGEMENT STUDIO Workspaces are helpful when you need to open some set of files connected to individual databases. If you have changing tasks/customers it might be reasonable to create an individual Workspace for each customer to easily load all scripts connected to the right databases at the right time. The functionality of Workspaces is similar to that of Recent Sessions but with extra possibilities of FORMAT/RE-FORMAT SQL DOCUMENT OR SELECTED PART OF CODE SSMSBoost allows you to format SQL Code using two different formatting engines. SSMSBoost formatting engine SSMSBoost formatting engine offers you a wide variety of options. The best way to learn them is to use a built-in Templates editor which will apply changes to the formatting template while you're editing it. To create/edit a formatting template: RECENT SESSIONS/RESTORE LAST SESSION Recent Sessions / Restore last session. SSMSBoost keeps track of your working environment and opened documents. In case of an unexpected failure you have the possibility to restore the last session or one of the previous sessions completely or partially. This includes restoring all saved (with filename) and unsaved (QueryN.sql) documents COMMENT/UNCOMMENT SELECTED CODE: SSMSBOOST ADD-IN FOR SQL Comment/Uncomment selection. SSMS has a standard feature that allows you to comment selected text, however, it uses "--" syntax, thus making it impossible to insert comments within the line. SSMSBoost added a smart /*comment selection*/ feature which does exactly what developers expect it to do: it puts /**/ marks at both sides of theselected
PREFERRED CONNECTIONS: "REMEMBER" FREQUENTLY USED SERVERS This functionality may be very convenient for those who have to deal with several servers on a daily basis. Preferred connections allow you to remember your favorite servers/databases and pre-configure several connection settings. Following options can be configured under SSMSBoost ->Settings->Preferred connections->List:. Connection aliasFATAL ACTIONS GUARD
Fatal Actions Guard parses scripts executed in SSMS and checks for potentially dangerous statements like DELETE or UPDATE with missing WHERE clause or the usage of TRUNCATE statement which bypasses delete triggers. To get the overview of this feature go to SSMSBoost Settings -> Fatal Actions Guard: It is possible to set an action if critical INTELLISENSE COMPLETION FIX Intellisense Completion Fix. SSMS 2012 always sets "Intellisense autocompletion" to "On" whenever you open a new query window. This is the unfixed bug confirmed by Microsoft. SSMSBoost adds the possibility to define global default setting for IntelliSense behavior. Go to Settings->Advanced->Intellisense "Completion Mode" enabled by defaultand
RESULTS GRID SCRIPTER (FLEXIBLE TEMPLATE-BASED RESULTS Results Grid Scripter is a powerful tool that allows you to script data from Result Grid to disk or clipboard in different formats with the help of customizable scripting templates. It takes just a few clicks to export data from Results grid to Excel (as XML spreadsheet) or your Web browser (as HTML table).SSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers DOWNLOAD LATEST VERSION OF SSMSBOOST: SQL SERVER Versions history of SSMSBoost add-in for SQL Server Management Studio ***** SSMSBoost v3.12 - NEW: Added support for the latest Release of SSMS 18.8 (15.0.18369.0) - COMING SOON: we have prepared 2 new features: -Pivoting assist (that will allow you to transform the standard SQL Query into PIVOT construct) -"Expand *" - will allow to "explode" the * into single fields in the select statements. LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. ACTIVATE SSMSBOOST ADD-IN FOR MICROSOFT SQL SERVER SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
FORMAT/RE-FORMAT SQL DOCUMENT OR SELECTED PART OF CODE SSMSBoost allows you to format SQL Code using two different formatting engines. SSMSBoost formatting engine SSMSBoost formatting engine offers you a wide variety of options. The best way to learn them is to use a built-in Templates editor which will apply changes to the formatting template while you're editing it. To create/edit a formatting template: COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVER Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. PREFERRED CONNECTIONS: "REMEMBER" FREQUENTLY USED SERVERS This functionality may be very convenient for those who have to deal with several servers on a daily basis. Preferred connections allow you to remember your favorite servers/databases and pre-configure several connection settings. Following options can be configured under SSMSBoost ->Settings->Preferred connections->List:. Connection aliasSSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers DOWNLOAD LATEST VERSION OF SSMSBOOST: SQL SERVER Versions history of SSMSBoost add-in for SQL Server Management Studio ***** SSMSBoost v3.12 - NEW: Added support for the latest Release of SSMS 18.8 (15.0.18369.0) - COMING SOON: we have prepared 2 new features: -Pivoting assist (that will allow you to transform the standard SQL Query into PIVOT construct) -"Expand *" - will allow to "explode" the * into single fields in the select statements. LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. ACTIVATE SSMSBOOST ADD-IN FOR MICROSOFT SQL SERVER SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
FORMAT/RE-FORMAT SQL DOCUMENT OR SELECTED PART OF CODE SSMSBoost allows you to format SQL Code using two different formatting engines. SSMSBoost formatting engine SSMSBoost formatting engine offers you a wide variety of options. The best way to learn them is to use a built-in Templates editor which will apply changes to the formatting template while you're editing it. To create/edit a formatting template: COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVER Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. PREFERRED CONNECTIONS: "REMEMBER" FREQUENTLY USED SERVERS This functionality may be very convenient for those who have to deal with several servers on a daily basis. Preferred connections allow you to remember your favorite servers/databases and pre-configure several connection settings. Following options can be configured under SSMSBoost ->Settings->Preferred connections->List:. Connection alias LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
EXECUTED SQL STATEMENTS LOGGING: SSMSBOOST ADD-IN FOR SQL This feature can be configured in SSMSBoost Settings->Script Execution History. You can define storage path, file naming template + a couple of other fine-tuning options. Use History->Find in Execution History for archived statements search. Refine your search with the help of date filter, size filter, wildcards and regular expressions. AUTOREPLACEMENTS: SSMSBOOST ADD-IN FOR SQL SERVER AutoReplacements or "snippets" allow you to input frequently used SQL commands much faster.Type "sel" and press SPACE, ENTER or TAB (configurable in Settings) - and it will be replaced with "select * from". "upd" will be replaced with "update # set where". "#" defines where cursor will be placed after the replacement is done (this symbol is customizable with the help of AutoReplacement). COMMENT/UNCOMMENT SELECTED CODE: SSMSBOOST ADD-IN FOR SQL Comment/Uncomment selection. SSMS has a standard feature that allows you to comment selected text, however, it uses "--" syntax, thus making it impossible to insert comments within the line. SSMSBoost added a smart /*comment selection*/ feature which does exactly what developers expect it to do: it puts /**/ marks at both sides of theselected
RECENT SESSIONS/RESTORE LAST SESSION Recent Sessions / Restore last session. SSMSBoost keeps track of your working environment and opened documents. In case of an unexpected failure you have the possibility to restore the last session or one of the previous sessions completely or partially. This includes restoring all saved (with filename) and unsaved (QueryN.sql) documents AUTO-CONNECT OBJECT EXPLORER TO DATABASES AT STARTUP Auto-connect Object Explorer to databases at startup. If this function is enabled SSMS will start with Object Explorer connected to your preferred databases. To use this option go to: SSMSBoost => Settings => Preferred Connections => List. Select the database connection that you want Object Explorer to automatically initialize at startup, click RESULTS GRID SCRIPTER (FLEXIBLE TEMPLATE-BASED RESULTS Results Grid Scripter is a powerful tool that allows you to script data from Result Grid to disk or clipboard in different formats with the help of customizable scripting templates. It takes just a few clicks to export data from Results grid to Excel (as XML spreadsheet) or your Web browser (as HTML table). JUMP BETWEEN COLUMN/VALUE WITHIN INSERT STATEMENT The solution is to use " Jump between COLUMN and VALUE " command in SQL Editor context menu. You can also use universal "JUMP" shortcuts Ctrl+Shift+Up Arrow to navigate "UP" (from VALUE to COLUMN) or Ctrl+Shift+Down Arrow to navigate "Down" (from COLUMN to VALUE). For better visibility the corresponding COLUMN/VALUE pairs arehighlighted.
NEW FORMATTER/OLD FORMATTTER Thursday, August 21, 2014 1:49:20 PM. You can select "old style formatting" on the toolbar to use old formatter. New formatter is very flexible but requires additional actions to configure it to suit your needs. Currently we accumulate user feedback andSSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers DOWNLOAD LATEST VERSION OF SSMSBOOST: SQL SERVER Versions history of SSMSBoost add-in for SQL Server Management Studio ***** SSMSBoost v3.12 - NEW: Added support for the latest Release of SSMS 18.8 (15.0.18369.0) - COMING SOON: we have prepared 2 new features: -Pivoting assist (that will allow you to transform the standard SQL Query into PIVOT construct) -"Expand *" - will allow to "explode" the * into single fields in the select statements. LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENTDOWNLOAD SSMSBOOST FREESSMSBOOST DOWNLOAD SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. AUTOREPLACEMENTS: SSMSBOOST ADD-IN FOR SQL SERVER AutoReplacements or "snippets" allow you to input frequently used SQL commands much faster.Type "sel" and press SPACE, ENTER or TAB (configurable in Settings) - and it will be replaced with "select * from". "upd" will be replaced with "update # set where". "#" defines where cursor will be placed after the replacement is done (this symbol is customizable with the help of AutoReplacement). COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVERSELECT FROM VALUES SQL SERVERVALUES SQL SERVERINSERT INTO VALUES SQL SERVERSET VALUE IN SQLSQL SERVER COPY DATABASESQL SERVER COPY RECORD Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. COMMENT/UNCOMMENT SELECTED CODE: SSMSBOOST ADD-IN FOR SQL Comment/Uncomment selection. SSMS has a standard feature that allows you to comment selected text, however, it uses "--" syntax, thus making it impossible to insert comments within the line. SSMSBoost added a smart /*comment selection*/ feature which does exactly what developers expect it to do: it puts /**/ marks at both sides of theselected
COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by JUMP BETWEEN COLUMN/VALUE WITHIN INSERT STATEMENT The solution is to use " Jump between COLUMN and VALUE " command in SQL Editor context menu. You can also use universal "JUMP" shortcuts Ctrl+Shift+Up Arrow to navigate "UP" (from VALUE to COLUMN) or Ctrl+Shift+Down Arrow to navigate "Down" (from COLUMN to VALUE). For better visibility the corresponding COLUMN/VALUE pairs arehighlighted.
SCRIPT GRID DATA NOT WORKING 54.2% (Neutral) I just installed SSMSBoost (version info below) on a new computer that is using SSMS 2016. So far, I can not get the Script Grid Data feature to work. When I select the grid and click the Script Grid Data button, the screen blinks like it is trying to open a dialog, but nothing shows up. It's almost like the pop-up is blocked.SSMSBOOST ADD-IN
Productivity SSMS add-in packed with useful tools: scripting, sessions, connection management. Plug-in works with all versions of SQL Server Management Studio: 2018, 2017, 2016, 2014, 2012 and 2008: SSMS add-in with useful tools for SQL Server developers DOWNLOAD LATEST VERSION OF SSMSBOOST: SQL SERVER Versions history of SSMSBoost add-in for SQL Server Management Studio ***** SSMSBoost v3.12 - NEW: Added support for the latest Release of SSMS 18.8 (15.0.18369.0) - COMING SOON: we have prepared 2 new features: -Pivoting assist (that will allow you to transform the standard SQL Query into PIVOT construct) -"Expand *" - will allow to "explode" the * into single fields in the select statements. LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENTDOWNLOAD SSMSBOOST FREESSMSBOOST DOWNLOAD SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. AUTOREPLACEMENTS: SSMSBOOST ADD-IN FOR SQL SERVER AutoReplacements or "snippets" allow you to input frequently used SQL commands much faster.Type "sel" and press SPACE, ENTER or TAB (configurable in Settings) - and it will be replaced with "select * from". "upd" will be replaced with "update # set where". "#" defines where cursor will be placed after the replacement is done (this symbol is customizable with the help of AutoReplacement). COPY AS SQL VALUES LIST: SSMS BOOST ADD-IN FOR SQL SERVERSELECT FROM VALUES SQL SERVERVALUES SQL SERVERINSERT INTO VALUES SQL SERVERSET VALUE IN SQLSQL SERVER COPY DATABASESQL SERVER COPY RECORD Copy as SQL values List This feature can be useful when you have some dataset in Results grid and you need to add a filter based on IDs from several rows to your query. If you select and copy them using just regular SSMS functionality every value will appear in a new line, String and DateTime values will not be in a ready-to-use format. COMMENT/UNCOMMENT SELECTED CODE: SSMSBOOST ADD-IN FOR SQL Comment/Uncomment selection. SSMS has a standard feature that allows you to comment selected text, however, it uses "--" syntax, thus making it impossible to insert comments within the line. SSMSBoost added a smart /*comment selection*/ feature which does exactly what developers expect it to do: it puts /**/ marks at both sides of theselected
COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copy Results Grid data to Excel (as xml Spreadsheet) Copying data from Results grid to Excel via built-in Ctrl-C or Ctrl-Shift-C commands results in the loss of data type information: Regular copy-paste function operates with text representation of data, so Excel needs to "guess" its type and regional settings. SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by JUMP BETWEEN COLUMN/VALUE WITHIN INSERT STATEMENT The solution is to use " Jump between COLUMN and VALUE " command in SQL Editor context menu. You can also use universal "JUMP" shortcuts Ctrl+Shift+Up Arrow to navigate "UP" (from VALUE to COLUMN) or Ctrl+Shift+Down Arrow to navigate "Down" (from COLUMN to VALUE). For better visibility the corresponding COLUMN/VALUE pairs arehighlighted.
SCRIPT GRID DATA NOT WORKING 54.2% (Neutral) I just installed SSMSBoost (version info below) on a new computer that is using SSMS 2016. So far, I can not get the Script Grid Data feature to work. When I select the grid and click the Script Grid Data button, the screen blinks like it is trying to open a dialog, but nothing shows up. It's almost like the pop-up is blocked. LOGIN INTO SSMSBOOST ONLINE LICENSES MANAGEMENT SSMSBoost v3.12 released: . SSMS 18.8 (15.0.18369.0) support added "Old fashion formatter" is back; Other improvements and fixes. Make sure to check the Changelog to see the full list of changes. COMPARE EDITIONS OF SSMSBOOST ADD-IN FOR SSMS 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 CREATE SIMPLE MACROS IN SSMS: SSMSBOOST ADD-IN FOR SQL Create simple macros in SSMS re-using existing commands. SSMSBoost add-in allows you to combine existing SSMS commands (as well as the commands of other add-ins) and thus create simple macros. The best example would be two macros that we have already created for you: Execute to Grid - executes statements and outputs results to Gridpane.
AUTO-CONNECT OBJECT EXPLORER TO DATABASES AT STARTUP Auto-connect Object Explorer to databases at startup. If this function is enabled SSMS will start with Object Explorer connected to your preferred databases. To use this option go to: SSMSBoost => Settings => Preferred Connections => List. Select the database connection that you want Object Explorer to automatically initialize at startup, click FORMAT/RE-FORMAT SQL DOCUMENT OR SELECTED PART OF CODE SSMSBoost allows you to format SQL Code using two different formatting engines. SSMSBoost formatting engine SSMSBoost formatting engine offers you a wide variety of options. The best way to learn them is to use a built-in Templates editor which will apply changes to the formatting template while you're editing it. To create/edit a formatting template: SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of requests from our users to implement "Run current SQL statement" functionality, as finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" is very time-consuming and requires several keyboard strokes and mouse clicks. We have implemented "Select Current Statement" (SHIFT+F5) feature which, followed by RECENT SESSIONS/RESTORE LAST SESSION Recent Sessions / Restore last session. SSMSBoost keeps track of your working environment and opened documents. In case of an unexpected failure you have the possibility to restore the last session or one of the previous sessions completely or partially. This includes restoring all saved (with filename) and unsaved (QueryN.sql) documents SSMSBOOST ADD-IN DISCUSSION BOARD Most users ever online was 353 on 12/6/2019 2:41:55 AM. There are 2,069 posts in 612 topics in 5 forums. We have 1,489 registered members. 0 Spammers submitted to StopForumSpam.com. The SSMSBoost Add-in discussion board uses cookies. PREFERRED CONNECTIONS: "REMEMBER" FREQUENTLY USED SERVERS This functionality may be very convenient for those who have to deal with several servers on a daily basis. Preferred connections allow you to remember your favorite servers/databases and pre-configure several connection settings. Following options can be configured under SSMSBoost ->Settings->Preferred connections->List:. Connection alias INTELLISENSE COMPLETION FIX Intellisense Completion Fix. SSMS 2012 always sets "Intellisense autocompletion" to "On" whenever you open a new query window. This is the unfixed bug confirmed by Microsoft. SSMSBoost adds the possibility to define global default setting for IntelliSense behavior. Go to Settings->Advanced->Intellisense "Completion Mode" enabled by defaultand
Cookie Policy
This website uses cookies to ensure you get the best experience on ourwebsite. Learn more
DeclineAllow cookies* Manage Licenses
* Log On
* Product overview
* Features list
* ACTIVATE (PRO OR FREE)* BUY/REQUEST QUOTE
* Read more
* About Us
* Forum
SSMSBOOST- SQL SERVER MANAGEMENT STUDIO ADD-IN PACKED WITH USEFUL TOOLS FOR DAILY TASKS SSMSBOOST ADD-IN FOR SQL SERVER MANAGEMENT STUDIO MICROSOFT SQL SERVER is shipped with powerful, stable and _predictable_ working environment - SSMS. So, why invent new editorsand environments ?
SSMSBOOST ENHANCES SQL Server Management Studio and adds features like export to excel, results grid search, sessions history, destructive DML guard and many other. The main goal of the project is to speed-up your DAILY TASKS AS DBA, SQL DEVELOPER OR DATA MINER, additionally protecting you from occasional data or code loss. Shortly after the installation you will realize that plug-in saves you hundreds of mouse-clicks and key strokes every day ! SQL SERVER MANAGEMENT STUDIO VERSIONS SUPPORTED: 2008, 2008/R2, 2012, 2014, 2016, 2017, 2018 LICENSING OPTIONS: after 30 day trial period register and get free community license or buy the professional version. Versions comparison page gives you a short overview about the differences between both versions. SSMSBoost was released to the public in 2012 and was adopted since then by more than 40 000 registered users from more than 15 000 companies around the world. Just to mention some of them: ------------------------- FEATURES, ADDED BY SSMSBOOST TO SQL SERVER MANAGEMENT STUDIO PREFERRED CONNECTIONS: "REMEMBER" FAVORITE SERVERS/DATABASES If you have to deal with several servers on daily basis - this functionality is for you. Preferred connections allow you to remember your favorite servers/databases and pre-configure several options. Connections can be managed in SSMSBOOST SETTINGS->PREFERRED CONNECTIONS Following options can be defined: * CONNECTION ALIAS: sometimes server names are too long and are difficult to memorize, like "customerserver823127.hosteddomainsample.com". In this case you can define DISPLAY NAME, like customerserver823127.hosteddomainsample.com-> DEVELOPMENT customerserver823555.hosteddomainsample.com-> PRODUCTION * Additional connection Parameters can be specified and they will be remembered forever. (This is a known issue with SSMS, that connection parameters are not remembered) * define if SSMSBoost should CONNECT OBJECT EXPLORER on start-up * define if SSMSBoost should OPEN EMPTY SCRIPT WINDOW on start-up * CUSTOM STATUS BAR COLOR. It will help you to distinguish between development (=green) and production databases (=red) quickly. If you define color for preferred connection, where no database is specified, this color will be applied whenever any database from that server isactive.
SSMSBoost tracks connection changes and re-picks correct color onevery change.
* 'IMPORTANT DB ALERT' helps you to protect your production environments: as soon as you change connection to the database that has this option turned on, a warning Tooltip will appear (text, color and position are customizable). You can use following replacement patterns: {@SERVER}, {@DATABASE}, {@USER}, \R, \N, \T. Note, that Tooltip location can be defined under "Important DB Alerts" page in SSMSBoost Settings. Below you can see how does alert looklike:
This feature can protect you from occasional data modifications in live environments and can actually save you time or even your job ! :) * You can QUICKLY ADD DATABASE displayed in Object Explorer to preferred connections by right-clicking on it's node and selecting "Add to preferred connections" Once you have defined the list of your preferred connections, they will be displayed in Quick connection switchdrop-down on the
toolbar, which allows you to switch connections instantly. NOTE, that in FREE COMMUNITY EDITION the number of preferred connections is limited by 2. QUICK CONNECTION SWITCH QUICK CONNECTION SWITCH drop-down on the toolbar combines 3 useful features originally missing in SSMS: * Allows switching between PREFERRED CONNECTIONS * Keeps track of RECENT CONNECTIONS * Shows all or ACCESSIBLE-ONLY local databases If SSMS starts with empty environment you can choose any connection from Quick Connection switch drop-down to create an empty document with appropriate connection. You will find fine-tuning settings of quick connection switch drop-down under SSMSBOOST SETTINGS->PREFERRED CONNECTIONSCONNECTION COLORING
Native Sql Server Management Studio connection dialog allows you to choose the color of the status bar, when initiating new connecting to the database, however, this color remains permanent even if your connection changes. SSMSBoost solves this problem: when adding Preferred Connection you can specify an appropriate color for SERVER or SERVER/DATABASE. SSMSBoost will tracks then connection changes and applies most specific matching color to the status bar. Most common usage can be "Red" status bar for your live system and "Green" for test database. IMPORTANT DATABASE ALERT Use this feature for very important connections additionally to Connection coloring . When adding Preferred Connectiontick "Important DB
Alert", specify alert message and color. Whenever current connection changes to this particular connection a floating pop-up will remind you that you are working with important database. AUTO-CONNECT TO DATABASES AT STARTUP This is one of the options of Preferred Connections : you can start SSMS with Object Explorer connected to your favorite databases. Just tick this option for the desired preferred connection in settings. AUTO-OPEN NEW QUERY WINDOW(S) AT STARTUP This is one of the options of Preferred Connections : SSMSBoost can create empty query windows connected to your favorite databases on startup. Just tick this option for the desired preferred connection insettings.
SET CONNECTION FROM OBJECT EXPLORER If you wish to SWITCH CONNECTION of current SQL EDITOR WINDOW to any database displayed in Object Explorer - just right-click it in Object Explorer and choose "SET AS ACTIVE CONNECTION" menu item. COPY FULL OBJECT NAME FROM OBJECT EXPLORER This feeling, when you see object in Object Explorer, but cannot copy it's fully-qualified name !... Well, no more! Right click the object and select "Copy Full Name to Clipboard". SSMSBoost will copy object's name to clipboard (including database and schema). SCRIPT OBJECT FROM SQL EDITOR: "GO TO DEFINITION" FOR SQL OBJECTS SCRIPT OBJECT located at cursor position directly from SQL Editor.Keyboard Shortcut:
SQL Server
Management Studio currently lacks a feature present in other Visual Studio Editors - "go to definition". SSMSBoost plug-in solves this problem by adding a tool what you need: Script object located at the cursor position to a new window. YOU CAN INVOKE THIS FEATURE BY * PRESSING KEYBOARD SHORTCUT * RIGHT-CLICKING THE IDENTIFIER AND SELECTING "SCRIPT OBJECT" FROMTHE CONTEXT MENU
SSMSBoost performs search for valid identifiers at cursor location and allows you to select, which one you want to script. If you select part of the identifier - SSMSBoost will perform no search and will use selected text as object identifier. If you would like to change the default Keyboard Shortcut for the "Script Object" feature you can do that using Shortcuts Editor feature of SSMSBoost (required only in SSMS 2008 as far as SSMS 2012 has built-in shortcuts editor). By default objects will be scripted as CREATE. If you want to generate ALTER scripts you can use "Script as ALTER" command also provided by our add-in. Use Extras->Settings->"Shortcuts & Macros" to redefine F2 shortcut to this command. ADDITIONAL SCRIPTING OPTIONS FOR SQL OBJECTS SCRIPTING SSMS shows not all scripting options by default. For SSMSBoost operations we provide you all internal scripting options structure available in SSMS. Be careful - some of them might not work, some of them can stop scripting option working. For experts use. EDIT TOP N TABLE ROWS SQL Server Management Studio allows to right-click table in Object Explorer and select "Edit top rows". Now you can do the same, right-clicking table name directly in SQL Editor. Number of Top rows is customize in settings. LOCATE OBJECT IN OBJECT EXPLORER FOCUSED IN SQL EDITOR LOCATE OBJECT IN OBJECT EXPLORER located at cursor position directlyfrom SQL Editor.
Keyboard Shortcut:
An often need is to know more information about OBJECT UNDER THE CURSOR: its columns, parameters (for function or procedure), other properties. If a database has hundreds of objects, LOCATING AN OBJECT IN THE OBJECT EXPLORER can take some time. SSMSBOOST ALLOWS TO LOCATE OBJECT IN SECONDS! Just place the cursor on the identifier and * PRESS KEYBOARD SHORTCUT * RIGHT-CLICK THE IDENTIFIER AND SELECT "LOCATE OBJECT" FROM THECONTEXT MENU
SSMSBoost performs search for valid identifiers at cursor location and allows you to select, which one you want to locate. If you select part of the identifier - SSMSBoost will perform no search and will use selected text as object identifier. Object fill be focused in Object Explorer and it's node will be expanded. So that you can easily access it's properties and, for example, DRAG-N-DROP PARAMETERS of stored procedure into SQL Editor window. If you want to change the default Keyboard Shortcut of "Locate object" feature you can do that using other feature of SSMSBoost - Shortcuts editor (needed only in SSMS 2008, as far as SSMS 2012 and later versions finally have built-in shortcuts editor) TRACK CURRENT DATABASE When working with lots of opened scripts connected to different servers/databases, sometimes it is useful to LOCATE CURRENT DATABASEIN OBJECT EXPLORER.
Just hit the button on the toolbar and current Server/Database will be focused in Object Explorer. This feature can be used as single-time action or you can switch "TRACK CURRENT DATABASE PERMANENTLY", which will always focus current database whenever you change connection of your script or switch between scripts. Generally - it is something like "synchronize table of contents" function in windows help, or like "synchronize solution explorer" in Visual Studio.AUTOREPLACEMENTS
AUTO REPLACEMENTS or "snippets" allow you to WRITE FREQUENTLY USED SQL COMMANDS MORE QUICKLY. Type "sel" and press space, enter or tab (configurable in Settings) - and 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. (This symbol is customizable per Autoreplacement). SSMSBoost Autoreplacements have following features, improving similar functionality of SSMS: * Tokens can be case-sensitive * It is possible to specify final cursor location, after autoreplacement has triggered * You can use standard SSMS parameters likeinto source code.
You can easily add your own Auto-replacements HOW IT WORKS - SAMPLE FOR "SEL" TOKEN HOW IT WORKS - SAMPLE FOR "UPD" TOKEN CUSTOM SSMS WINDOW TITLE (CAPTION)Originally, SSMS
displays static caption "Microsoft SQL Server Management Studio". If you have several instances open and try to switch between them using Alt-Tab or task-bar, you will not be able to see the difference between instances. SSMSBoost add-in allows to re-define the caption of the window, so that you will be able to see current document name and connection information. You can also define your own pattern to be used for window title. AVAILABLE PARAMETERS: @FILENAME, @SERVER, @DATABASE, @USER. Parameters can be used within main pattern as well as in sub-patterns {ProjectName} and {Connection}. {ProjectName} pattern will be inserted only if SSMS project is loaded. {Connection} pattern will be inserted only if connection is open. Picture on the right shows you how different SSMS instances will be displayed on the task bar. Pictures below show how caption of SSMS looks like and how windows appear in Aero Peek. AERO PEEK WITH MODIFIED SSMS CAPTION ADVANCED OBJECTS SEARCH ADVANCED OBJECTS SEARCH allows to search for database objects, columns and function parameters across one or multiple connections directly from the SSMS user interface. To open the search dialog click button on the SSMSBoost toolbar. Appeared Dialog can be used in docked or floating state within the SQL Server Management Studio interface. To use the search function simply start typing first letters of the object, column or parameter name in the filter row. You can use Wildcard characters ? and * in your search string. * 1. SYNC CONNECTION WITH CURRENT DOCUMENT sets search context to the current connection of the active SQL Editor window. * 2. CURRENT SEARCH CONTEXT drop-down (in single-database search mode) allows you to select search context. * 3. REFRESH reloads objects cache. Use it only if you have modifieddatabase objects.
* 4. LIMIT TO FAVORITE OBJECT TYPES search will be performed only within your favorite object types (configurable in settings). * 5. SHOW SYSTEM OBJECTS adds system objects to search results * 6. MULTI-DATABASE SEARCH button switches between single- and multi-database search modes. * 7. SETTINGS button opens Settings window where you can configure default behavior of the dialog and some additional useful options. Make sure you check these options - they can save you a lot of time. Here's the list of operations that can be performed with Searchresults:
Double click the OBJECT to set it as the SEARCH CONTEXT, that will allow you to perform further search for object's columns or parameters. (This function will only work for database objects withcolumns/parameters)
The following buttons at the bottom of the dialog will be enabled if an object is selected in search results: * 8. SCRIPT SELECTED OBJECT(S) - opens SQL source in new editorwindow
* 9. LOCATE OBJECT - navigates Object Explorer to object's node * 10.COPY SELECTED IDENTIFIER(S) INTO CURRENT DOCUMENT - inserts selected objects into current cursor position * 11.RIGHT-CLICK an object (or the selection of multiple objects) to open the context menu with the functions described above. SELECT CURRENT STATEMENT / RUN CURRENT STATEMENT We have received a lot of user requests to implement "RUN CURRENT SQL STATEMENT" functionality, because finding and selecting the boundaries of the current SQL Statement to perform "Run selected statement" requires several keyboard strokes or mouse clicks and istime-consuming.
We have implemented "SELECT CURRENT STATEMENT" (SHIFT-F5), which, followed by "Execute"" (F5), gives you desired "Run current statement" functionality in SSMS Query editor. The reason we did not implement direct "Run current statement" command is to save you from fatal errors. You have the last chance to review the statement boundaries automatically detected by parser, beforehitting final "F5".
JUMP BETWEEN MATCHING BEGIN/END TOKENS This functionality allows to Jump to BEGIN or END of the current block or jumping between corresponding BEGIN/END tokens. To activate the function, select corresponding command in SQL Editor context menu. Note, that you can also use universal "JUMP" shortcuts CTRL+SHIFT-UP ARROW to navigate "UP" (to BEGIN) or CTRL+SHIFT-DOWN ARROW to navigate "Down" (to END). These shortcuts are shared with Jump between COLUMN/VALUE within INSERT statement functionality and act depending on current cursor placement. JUMP BETWEEN COLUMN/VALUE WITHIN INSERT STATEMENT When editing large INSERT statements with big number of involved columns, it is useful to know to corresponding COLUMN of currently edited VALUE or, vise-versa: sometimes you want to locate corresponding VALUE within values list for current COLUMN. Here is the solution: use "Jump between COLUMN and VALUE" command in SQL Editorcontext menu.
Note, that you can also use universal "JUMP" shortcuts CTRL+SHIFT-UP ARROW to navigate "UP" (from VALUE to COLUMN) or CTRL+SHIFT-DOWN ARROW to navigate "Down" (from COLUMN to VALUE). These shortcuts are sharedwith GoTo BEGIN/END
functionality and act depending on current cursor placement. COMMENT/UNCOMMENT SELECTION SSMS has standard feature allowing to comment selected text, however, it uses "--" syntax, making impossible to insert comments within theline.
SSMSBoost has added smart /*comment selection*/ feature, which does exactly what developers expect it to do: it puts /**/ marks around theselected text:
Additionally, this feature can be used to remove comments, when selection exactly matches comment bounds (works with both /**/ and --syntax):
REGIONS IN SQL SERVER MANAGEMENT STUDIO ! SSMSBoost adds the possibility to use common regions syntax--#region
--#endregion
in SQL Editor. Regions will be recognized and processed by our add-in and expand/collapse symbols will be added near region head. Regions functionality is available through SSMSBOOST TOOLBAR->REGIONS Following commands are available * CREATE REGION creates unnamed region. If you run it when some part of code is selected - it will be wrapped into newly created region. * CREATE NAMED REGION creates region, asking for name. If you run it when some part of code is selected - it will be wrapped into newlycreated region.
* REPARSE/REFRESH REGIONS forces re-processing of current document. All regions will be newly created. This can be necessary, if you are doing massive changes to the document. Regions are parsed automatically when script is being opened in editor. Make sure you check SSMSBOOST SETTINGS->REGIONS for fine-tuning options. For example, you can customize region start and end tokens.FORMAT SQL CODE
SSMSBoost allows to FORMAT SQL CODE using two different formattingengines.
SSMSBOOST FORMATTING ENGINE SSMSBoost formatting engine offers a wide variety of options. The best way to learn it is by using BUILT-IN TEMPLATE EDITOR: it will apply changes to the formatting template while you edit it. To create/edit formatting template: * Open one of your SQL scripts - it will be used to display formatting result while you change options * Run SSMSBOOST MENU->QUERY->SQL FORMAT STYLES TEMPLATE EDITOR * Change template options and they will be immediately applied toyour code.
* Hit "Save changes" when you are done Now you have created your own formatting template, you can choose it on the toolbar in the formatting drop-down and hit "Format" anytime to format your SQL code. Under SSMSBOOST SETTINGS->FORMATTING you can manage formatting templates as well, particularly - you can import/export them, to share templates with your colleagues. "POOR MAN'S T-SQL FORMATTER" This formatter is added as an external tool, which SSMSBoost calls in the background. The project is called "Poor Man's T-SQL Formatter"and is
displayed as "Old styled formatting" in formatting drop-down. Project author Tao Klerk did not update it for several years but many users were asking if it is possible to use this formatter under latest SSMS versions, so we decided to link it into our add-in. You can configure formatting options under SSMSBOOST SETTINGS->FORMATTING->OLD FASHIONED FORMATTING. RESULTS GRID SCRIPTER (FLEXIBLE TEMPLATE-BASED SCRIPTING) RESULTS GRID SCRIPTER allows to script data using flexible scripting templates to clipboard or to disk. For example, to export & open contents of results grid in Excel you need a few clicks (also see picture below): * Right click results grid * Select "Script data as" command * Select "Excel (MS XML Spreadsheet)" * Choose between "All grids", "Current grid" or "Selection"* Choose "To Disk"
* After scripting is done click displayed link to open created document in Excel (this step is not displayed on the picture) Existing templates can be fully customized and new templates can beadded under:
Extras->Settings->"Results Grid:Scripter Templates". Read template properties description in configuration dialog for more information about specific properties. Use existing templates as samples to experiment and create your owntemplates.
Post your templates at our forumif you have created
useful ones and want to share them with others. Results grid scripter FEATURE IS SHIPPED WITH FOLLOWING PREDEFINEDTEMPLATES:
* PROPERTY:VALUE - copies results as ColumnName:Value * WHERE COLUMN=VALUE - selected values are copied as 'WHERE (ColumnName=Value) OR ...' allowing to generate WHERE filters quickly by selecting required column values * WHERE COLUMNNAME IN (VALUE1,VALUE2..) - generates WHERE ColumnName in (Value1,..) filter based on selected values * EXCEL (MS XML SPREADSHEET) - saves results in MS XML Spreadsheet format, that can be easily opened in MS Excel. VALUES PRESERVE THEIR DATA TYPES: IF YOU EXPORT TELEPHONE NUMBERS TO EXCEL, THEY WILL NOT BE TREATED AS FORMULAS ANYMORE ! * INSERT INTO #TMPRES EXEC SP_STOREDPROC - quickly generates temporary table declaration, that can be used to insert execution results of stored procedure. * SELECT - scripts results as SELECT VALUES statement. It is some kind of table data exported as script. Datatypes are preserved. * XML - results are saved as pure XML document * HTML TABLE - results are saved as HTML Table IT IS REASONABLE TO TRY EACH PROVIDED TEMPLATE AT LEAST ONCE TO UNDERSTAND IT'S PURPOSE BETTER. COPY RESULTS GRID DATA TO EXCEL (AS XML SPREADSHEET) Copying data from Results grid to Excel via built-in Ctrl-C command results in loss of data type information. Excel needs to analyze inserted data and to "guess" it's type and regional settings. SSMSBoost allows you to copy Results Grid data in XML Spreadsheet format, preserving data type and precision information. Strings remain Strings, DateTime remains DateTime and Numeric and Money data keep their precision and scale. If you like this feature, make sure you read about Results GridScripting feature:
it is much more flexible and customizable and designed to output really bit amounts of data. FIND IN RESULTS GRID FIND IN RESULTS GRID allows you to SEARCH for values in current grid, all grids or selected block of data. * Search using wildcards * Search option allow to define search range, search tolerance andsearch order
* Double-click search result to navigate to corresponding cell * Search results offer a wide variety of options: copy cell data, preview data, focus matched cell... * You can always press Ctrl-F in SSMS Results Grid to start Data/Column search. Both windows have a quick switch button on thebottom.
* Quickly switch to Find column in Results Grid dialog, using button atthe bottom
Pictures below show initial view and multiple results representation. You make SSMSBoost select found cells in Results Grid to script them or perform subsequent search within selection. FIND COLUMN IN RESULTS GRID SSMSBoost offers search for columns in all currently displayed Results Grids (there can be several result sets returned by query). * Search using wildcards * Double-click the column to focus it in the corresponding grid * Select column name in results and press CTRL-C to copy it's name * Column data type, precision and NULLability are displayed in results set. Yes - now you know exact data types of the result set. * Quickly switch to Find in Results Grid dialog, using button atthe bottom
* You can always press Ctrl-F in SSMS Results Grid to start Data/Column search. Both windows have a quick switch button on thebottom.
Note, that this is dockable windows pane, that you can doc exactly as other SSMS panes and it will remember it's location. On first use you have to find a suitable place for this useful window in your SSMSenvironment.
COPY RESULTS GRID HEADERS (COLUMN NAMES) You have some results set in Results Grid and want to copy some of COLUMN NAMES ? Select cells from columns that you want to copy (Ctrl-Click) and choose "Copy selected Headers" from Results Grid context menu. Column names will be copied to clipboard. You can also run "Copy all Headers" command, if you want to have all headers. Note: it does not matter, cells of which row do you select. We just need to know the column. COPY CELL DATA FROM RESULTS GRID 1:1 (PRESERVING LINE BREAKS) If SQL Query outputs long strings of data (for example from TEXT, NTEXT, VARCHAR OR NVARCHAR fields) SQL Server Management Studio truncates them when outputting to Results Grid. Truncated string will be also copied to clipboard, if you use native copy command. SSMSBOOST INTRODUCES "COPY CURRENT CELL 1:1" command: select cell you want to view/copy, open context menu -> "Copy current cell 1:1" and full data will be copied to clipboard - all bytes and without anymodifications.
COPY AS SQL VALUES LIST You have some dataset in Results Grid and want to add a filter to your query, based on ID's from several rows. If you just select and copy them, every value will be on new line, and String and DateTime values will not be in "ready to use" format. SSMSBoost allows to speed-up the process: just select "Copy as SQL Values list" from context menus and you get a ready-to-use comma-separated list of values, that you can paste into your "WHERE" statement. SSMS RESULTS GRID DATA VISUALIZERS Feature allows to export & view files or some big amounts of text or XML data from tables (like files from document storage of sharepoint services). Required data should be simply output to Results Grid. By right-clicking the cell with required value and selecting "Visualize As->.." you can tell to save data to file with predefined name and open it with custom or default application. No matter that SSMS truncates long data from VARBINARY/VARCHAR fields when displaying them in Results Grid: SSMSBoost works with internal storage of SSMS and extracts complete cell value. Below you can see how a picture from field of . table from database is being visualized: There is actually no magic: in Settings dialog you can configure list of Visualizers. You define Visualizer name, file extension for saving data and also an application, used to open saved files. If you leave Application path empty SSMSBoost will perform "Shell.Open" - forcing windows to open file using associated application. There is a trick for using this feature: if your field keeps images of different types like .bmp, .png, .jpg, etc., then you do not have to define own visualizer per type. Just define visualizer "Picture" and extension to save ".pic". Then associate in Windows .pic with windows picture viewer. Picture viewer will analyze contents of .pic and display image correctly, no matter if it is .jpg or .bmp. This trick might also work with other picture viewers or other programs. RECENT CONNECTIONS - CONNECTIONS HISTORY IN SSMS SSMSBoost keeps track of connection history and allows to access itin 2 ways:
* Using Quick connection switchdrop-down on the
toolbar:
* Using RECENT->PICK RECENT CONNECTION command on the toolbar, which shows list of recent connections. Using this list, you can just connect to any of listed connections or promote recent connection to Preferred Connection . If you tick "freeze" option for any connection it will remain in list forunlimited time
Make sure you check SSMSBOOST SETTINGS->RECENT CONNECTIONS for fine-tuning options.RECENT TABS
Recent Tabs feature keeps track of currently opened documents. SSMSBoost remembers document names and their connections. If documents are new and were not saved (Query1.sql) they will be still remembered and unsaved content will be saved, coupled with SQL Editor ContentsHistory feature.
You can use these feature by using one of commands: * RESTORE LAST CLOSED TAB simply restoring last close tab, including it's CONNECTION without any further questions * PICK RECENT TAB shows Recent Tabs dialog, allowing you to choose one of the Tabs from the history: "Freeze" option allows you to force persistence of the tab in the recent tabs, until you manually delete it. Make sure you check SSMSBOOST SETTINGS->RECENT TABS for fine-tuningoptions.
RECENT SESSIONS / RESTORE LAST SESSION SSMSBoost keeps a track of your working environment and remembers which document were opened. In case of unexpected reboot or crash you have the possibility to RESTORE LAST SESSION or RESTORE ONE OF PREVIOUS SESSIONS completely or partially. This includes restoring all saved (with filename) and UNSAVED (QUERYN.SQL) documents, includingtheir CONNECTIONS.
You will wind RESTORE LAST SESSION and PICK RECENT SESSION commands on the SSMSBoost toolbar under RECENT menu. Here is how PICK RECENT SESSION dialog looks like: Make sure you check SSMSBOOST SETTINGS->RECENT TABS for fine-tuning options. These settings affect not only Sessions, but also Recent tabsfunctionality.
SQL EDITOR CONTENTS HISTORY: INFINITE UNDO POSSIBILITY. SSMSBoost regularly makes backup snapshots of currently opened document to disk, providing you with the possibility to get back to older versions of your work in future. It is not only "backup copy", it is modification history (sometimes you want to restore some specific version of your script). The feature is disk-size optimized: No data will be written if there were no changes since the last snapshot. History is saved on disk in simple text format, however, we have added advanced search functionality, that allows you to search for previous versions of current document right from SSMS environment. Search results can be compared to currently opened document with your favorite FileDiff tool, like WinMerge. Make sure you check Settings on this feature, to perform fine-tuningto your needs:
EXECUTED SQL STATEMENTS HISTORY SSMSBoost saves executed statements along with information about execution results to local folder. This feature allows you to find queries that you run in the past and reuse them again. This can help you to recover valuable scripts or analyze your actions on specific database. You should be familiar with those moments, when your customer asks for "same report but for last year" just after you have closed your temporary script without saving it... Well - now you can recover your work and re-use it. This feature can be configured in SSMSBOOST SETTINGS->SCRIPT EXECUTIONHISTORY.
You can define storage path, file naming template + a couple of other fine-tuning options. Use HISTORY->FIND IN EXECUTION HISTORY to search through archivedstatements.
WORKSPACES
Workspaces solve the problem, when you have to open some set of files connected to individual databases. If you have changing tasks/customers, it might be reasonable to create own Workspace per customer, so it will be easy to load all scripts connected to right databases at right time. You can see Workspaces as Recent Sessions , but with the possibility to give a Name to the Session and save it for a long time. You will find Workspaces under SSMSBOOST MENU->WORKSPACES, as well on the SSMSBoost toolbar. These are main features of Workspaces: * Named set of documents * Own pre-set connection per documentVERTICAL GUIDELINES
Vertical Guidelines is a useful feature that helps to stay in control of maximum "reasonable" width of your source code. You can configure one or several lines positions and define their color. You can also deactivate this feature, if you are used to clean SQL Editor.FATAL ACTIONS GUARD
There is always a possibility to accidentally execute UPDATE or DELETE statement without WHERE clause, ruining the data. Yes, in theory, it should never happen, backups should exist, triggers and foreign keys should stop deadly modification, but in reality additional protection can save you hours or work, or, maybe even yourjob ;)
Fatal Actions Guard parses scripts executed in SSMS and checks for potentially dangerous statements, like DELETE or UPDATE with missing WHERE clause, or usage or TRUNCATE statement, which bypasses delete triggers. To get an overview about the feature, open SSMSBoost settings and search for "Fatal actions guard". It is possible to configure what will happen if critical statements are found: should execution be stopped or should user be able to continue, confirming his intentions. You can also exclude particular tables from this check ("Exclude table names"). Further, you can enter custom tokens, that will cause following actions, if found: * "ask" token - will force SSMSBoost to ask user for execution confirmation. For example, if you add "#checklater" token in "ask" tokens list and will start adding it to your scripts, SSMSBoost will keep asking you for execution confirmation, until you delete all these tokens. This can be practical, if you are working on some script and want to mark some critical places, that should be verified. * "prohibit" token - pretty the same logic as "ask" token, only SSMSBoost will not allow you to run the script at all. You can add it to script files, that are not intended for blind execution. Sometimes system administrators collect frequently used commands in one script, and it can be fatal if someone just executes that file. * "magic unblocking" tokens allow you to disable execution guard for some particular script. For example, if you often use "full wipe" script to initialize your test database and use TRUNCATES there, just add #breakingbad in settings and then add this token as a comment to your script and. Execution Guard will be disabled for that particularfile.
RUN SELECTED SCRIPT AS DATABASE QUERY (.DQY) IN EXCEL Microsoft Excel has a perfect possibility to run direct database queries and use results for further processing: as simple data table, as base for Pivot tables and Charts. However, there are some clicks to do, before you get your query executed in Excel. SSMSBoost adds 1-click functionality to complete this: * Select query, that you want to export for execution in Excel * Execute SSMSBOOST MENU->QUERY->RUN IN MS EXCEL command * SSMSBoost will create Database Query (.dqy) file, passing selected SQL STATEMENT and CURRENT CONNECTION information * File is now passed to Excel for further processing. It might be necessary to adjust security settings in Excel to allow processing of".dqy" files
Note: Excel has some rules, that your query must fulfill. You will find detailed documentation on the Internet, but to keep it short: it must be single SQL query, returning one dataset. IMPORTANT: Make sure you check SSMSBOOST SETTINGS->DATABASE QUERY (.DQY) for fine-tuning options. For SQL Server native authentication SSMSBoost can export connection password in clear text form, which might be a big problem, if you are going to give .dqy file to other persons. And yes - this is a workaround how to RESTORE FORGOTTEN SQL PASSWORD for some connection, that is still present in your recentconnections list.
INTELLISENSE COMPLETION FIX SSMS 2012 always sets "Intellisense 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 behavior. See Settings->Advanced "Intellisense completion mode" option. RESULTS GRID AGGREGATES Excel has a perfect function, which allow users to select several cells and see their SUM in the status bar. Well, SSMSBoost adds even more advanced Aggregates functionality to Results Grid: All you need to do is to select a range of cells. SSMSBoost activates Aggregates windows and starts displaying aggregates. By clicking checkboxes below the calculated results you can select which aggregates to calculate: SUM, MIN, MAX, COUNT, COUNT NULLS, DISTINCTCOUNT, AVG.
Please note, that some aggregates are data type-specific and will not be calculated (like there is no SUM for Strings). Aggregates window, like most of other SSMSBoost windows is dockable floating pane, which can be docked in SSMS environment like any other window. You have to size/dock it when it appears for the first time. There are some fine-tuning options available under SSMSBOOST SETTINGS->GRID AGGREGATES. Make sure you check them and choose best settings for your usage case. QUERY POST-EXECUTION HANDLERS In current version we have implemented only one post-execution handler: an Info message is shown, when query completes the execution. This is useful particularly when you execute long-running queries and switch to other window within SSMS or even to other application. If query execution completes while you are working in another application, a Windows notification message in system tray is shown: If execution completes while you are still in SSMS, a pop-up is shown within the SSMS user interface: You can customize the contents and behavior of the Info-popup in SSMSBOOST SETTINGS->QUERY POST-EXECUTION HANDLERS. P.S. We will add more post execution handlers later. Please send us your ideas what you need. This can be something like "send an e-mail after query completes" or something else. Send your ideas, sample scripts and proposals.TRANSACTIONS GUARD
Whenever execution of last SQL batch leaves open transactions, SSMSBoost will show floating information window with the reminder. There will be one reminder window shown per SQL Editor tab. Reminder can be closed or will close itself when @TRANCOUNT reaches 0. Feature re-uses native SSMS functionality, that checks open transactions whenever you try to close SQL Editor window with open transactions. Due to this fact we do not show number of open transactions (native function returns only "yes" or "no"). You can always check number of open transactions using SELECT @TRANCOUNT statement. You can disable this functionality in SSMSBOOST SETTINGS->TRANSACTIONSGUARD
CREATE SIMPLE MACROS IN SSMS RE-USING EXISTING COMMANDS SSMSBoost add-in allows you to combine existing SSMS commands (and also commands of other add-ins) and create this way simple macros. The best example are 2 macros that we have already created for you: EXECUTE TO GRID - executes statements and outputs results to Grid pane EXECUTE TO TEXT - executes statements and outputs results to Text pane For example, EXECUTE TO GRID is created as a sequence of 2 existing SSMS commands: Query.ResultsToGrid and Query.Execute. When macro is created, you are free to assign shortcuts and place the button on the toolbar to speed up the access to the functionality. If you are looking for the easy to read list of all commands, available in SSMS, use our SSMS Commands Dumpfeature.
For your reference we have listed all SSMSBoost commands on the separate Settings page named "Commands". Along all available commands you see assigned shortcuts and can easily redefine them. Be creative, help yourself! MANAGE KEYBOARD SHORTCUTS Note: this functionality is present in SSMS VERSIONS 2008-2014 only. Users of SSMS 2016 and later versions do not need this feature and can use internal shortcuts editor connected with our Macros functionality. Additionally, in SSMS Versions starting from 2016, SSMSBoost displays full list of own commands under SETTINGS->COMMANDS, displaying assigned shortcuts and allowing to set new ones. In SSMSBoost for SSMS versions 2008-2014 Shortcuts management is merged with Macros functionality, which allows you to create sequences of commands with assigned shortcut. If you want to assign a shortcut to a single command (SSMSBoost or any other command), simply create a macro containing single command and assign it a shortcut.SSMS COMMANDS DUMP
SSMS environment has a technical name for every function/command it offers on the toolbar and in menus. Additionally, all installed add-ins and extensions register their functions in SSMS environment as well. Using our commands dump you can get a list of all functions, registered in your SSMS instance and, for example, perform a quick search for functionality, that you are interested in. This saves a lot of time if you are looking for some specific functionality. Additionally, SSMSBoost outputs associated shortcuts, if associated. You will find this command under SSMSBOOST MENU->TOOLS->DUMP SSMSCOMMANDS
UPDATE CHECKER
You can stay notified about new product updates. Open SSMSBOOST SETTINGS->UPDATE CHECKER and configure yourpreferences.
MISS YOUR FAVORITE FEATURE ? If you would like to see your feature proposal implemented in our add-in, please do not hesitate to contact us via e-mail: SUPPORT@SSMSBOOST.COM or using our Forum.
We are constantly improving our SSMS plug-in and a big part of the functionality is based on user proposals and feedback that we receive.Sincerely yours,
SSMSBoost team.
DOWNLOAD LATEST RELEASESSMSBOOST FOR SSMS
Build date: 19 Aug 2019v.3.7.7170
md5: 9145549BBACA51C3BA9AFC8387626BF4 Download Read Changelog Show Previous ReleasesSOCIAL
LATEST NEWS
AUGUST 19, 2019
SSMSBoost V3.7 released: * Further improvement of OBJECT SEARCH DIALOG * New DATALENGTH function in Grid Aggregates * Supports latest Release of SSMS 18.2 (15.0.18142.0) * Other improvements and fixes. Make sure to check the Changelog to see the full list of changes.Show More News
FEATURES
* Advanced objects search * Auto-connect to databases at startup * Auto-open new query window(s) at startup* Autoreplacements
* Comment/Uncomment selection using /**/ * Connection Coloring * Copy as SQL values List * Copy cell data from ResultsGrid 1:1 * Copy full object name from Object Explorer * Copy Results Grid data to Excel * Copy Results Grid Headers * Custom SSMS window title * Dump all SSMS commands and shortcuts * Edit Top N Table Rows * Executed SQL Statements History * Fatal actions guard * Find Columns in Results Grid * Find in Results Grid * Important Database alert * Intellisense Completion Fix * Jump between COLUMN/VALUE within INSERT statement* Jump to BEGIN/END
* Locate Object
* Macros
* Manage keyboard shortcuts * Post-Execution Handlers * Preferred connections * Quick Connection Switch * Recent connections* Recent Sessions
* Recent Tabs
* Regions
* Results Grid Aggregates * Results Grid data Visualizers * Results Grid Scripting * Run as Database Query (.dqy) in Excel* Script Object
* Select Current Statement * Set Connection from Object Explorer * SQL code formatting * SQL Editor contents history * Track current database * Transactions Guard* Update Checker
* Vertical guidelines * Workspaces managementINTERESTING READ:
How to create add-in for SSMS 2012 SUBSCRIBE TO RELEASE NOTIFICATIONS: SQL Server, Excel and Microsoft are registered trademarks of MicrosoftCorporation.
2012-2019 © Solutions Crew GmbH* PRIVACY POLICY
* EULA
* ABOUT US/IMPRESSUMDetails
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0