Keep going to improve productivity with dbForge SQL Complete

November 23rd, 2018

The Devart team brings together the interests of its clients and best usability practices in a new version of SQL Complete 6.0.  Read on to find out what useful features we have prepared for you in the new release.

SQL Server 2019 support

The release of SQL Server 2019 was announced just a little while ago, but we’ve managed to support it in this release of SQL Complete.

SSMS 18 support

SQL Complete can now be seamlessly integrated into the most recent SSMS 18.

Invoke Search panel instantly with a new shortcut

A keyboard shortcut Shift+Alt+F is assigned to the Find command, which calls the Search panel in the grid.

Shortcut for Find option

Days are displayed in execution notification

If a query is running more than 23:59:59 hours, days are added to the time in the Execution Notification.

Long-running query

Sort snippets in Snippets Manager

You can switch between the titles and shortcuts of snippets and sort them in ascending/descending order to quickly find the one you need.

Sorting in snippets manager

Grid Aggregates Enhancements

SQL Complete now counts the aggregate values not just for one column selection but also for multiple columns of the same data type.

Grid Aggregates for multiple columns

The Grid Aggregates row now shows MIN/MAX aggregate values for the date/time and string data types.

To make the Grid Aggregates row permanently visible, open Options, navigate to the Query Result Grid tab, and select Show always summary panel.

permanently show aggregate grid row

Execution Warning for DROP statement

An execution warning will appear if you try to drop a table/database of a certain environment category. You may also disable the warnings for a certain part of a script as specified in the bottom of the Execution Warnings window.

Execution warnings for DROP statements

Moreover, SQL Complete analyzes every USE statement and prompts an execution warning if the statement refers to a database of the environment for which the execution warning is set.

Execution warning for USE

Status bar and Object Explorer coloring intensify Tabs Coloring

You can quickly determine which connection is used by a current tab as the tab coloring is now concurrent with the status bar and Object Explorer colorings. The color may be associated with a server node, moreover, different colors can be set to databases residing on the same server.

Pane and Object Exploreк coloring

SQL Document Enhancements

You can shorten the name of SQL documents by excluding unnecessary portions therefrom (such as sever and/or database name) so that multiple tabs could neatly fit into the tabs pane.

Auto adjust tab width

 

3 Responses to “Keep going to improve productivity with dbForge SQL Complete”

  1. Jones Credo Says:

    Amazing Article ! I have bookmarked this article page as i received good information from this. All the best for the upcoming articles. I will be waiting for your new articles. Thank You

  2. Cloud Analogy Says:

    Thanks.. the information is really useful.

  3. Sam Duval Says:

    I’ve been using the free version of Devart’s SQL complete for a little over a year, and the trial version of the complete (paid) version for the past week or so. This tool has been the most valuable edition to SSMS I’ve used. The replacement intelisense alone is worth the cost of the program. Even better that it is included in the express (free version) albeit with some handicaps compared to the full version. In the express version it functions very similar to the native intellisense that is built into SSMS but is more responsive and offers a little more contextual information in the “tool tips” menu. This contextual information pops up when you are scripting an execute function or SP in the SSMS query editor, and is very helpful in knowing what and what order of parameters you need to enter. It also has automatic table name appending, so as you type your query, you no longer have to type the table name before the column name. This saves you from the ambiguous column reference error if you have or add a table later with column names in common. Even without common table names this feature is a great thing to have when editing or debugging code, so that you know exactly where the column came from without having to do much digging. The value really shines when you consider the table name was applied for you, so you reap the benefits of nice clean code with ½ the work.
    The complete version takes intellisense further and builds a hybrid text and GUI approach to query builds. It has some auto formatting it applies as you type (mostly case correction or closing parenthesis) but as you are typing a select statement it pops up a mini window in which you can check off the columns you want to have included in your query. This is great when you want several fields that have a something in common name wise. Example of a table with a bunch of columns including First Name, last name and middle name. You can type “name” and the context menu pops up with only those 3 fields. Now you can quickly check off the three boxes and they get added to the sql script.
    Both the free and the complete version off some execution history of SQL scripts. This is a great time saver when you close that one and done SQL query without saving it anywhere only to have someone come by and ask you for that same information. The execution history allows you to pull up a list of recently executed queries and see the code for each one as you move down the list. This is a fantastic feature that saves a lot of time having to rework a query especially if it was not the most easy query to write. It’s also helps you be more confident in resharing the information without having to validate your results against results you previously provided to make sure the script was written the same way.

Leave a Comment