SQL Complete Keeps Extending SQL Prompting

October 5th, 2021

We are happy to announce that the new version of dbForge SQL Complete has been released. We have been working on the implementation of the new features and fixing the faults in the existing ones to make your everyday working experience better. dbForge SQL Complete is a perfect solution for those database developers who treasure their time. With this add-in, you might actually feel that the application reads your mind and predicts your next step, taking away the painstaking work. The award-winning SQL Complete is available for Visual Studio and SSMS.

What’s new in dbForge SQL Complete v6.9:

In dbForge SQL Complete, v6.9 we decided to pay special attention to the statement suggestions functionality. The new features were designed to simplify and optimize the database development process:

  • Support for CONSTRAINT suggestion in the ALTER TABLE statement
  • Suggestion of UPDATETEXT
  • Support for DISTRIBUTED_AGG in SELECT — GROUP BY
  • Support for ALTER/DROP DATABASE SCOPED CREDENTIAL
  • Support for Configuration Options for Query Store feature in ALTER DATABASE
  • Support for WAIT_AT_LOW_PRIORITY in ALTER TABLE … SWITCH PARTITION
  • Support for new keywords in ALTER DATABASE SCOPED CONFIGURATION
  • Support for CREATE/ALTER/DROP EVENT SESSION session_name ON DATABASE (for Azure SQL)
  • Support for ALTER SERVER CONFIGURATION in MEMORY_OPTIMIZED options

To download the new version, click here.

Support for CONSTRAINT suggestion in the ALTER TABLE statement

SQL constraints are rules applied to the columns of a table. They are used to restrict the types of data that can be stored in a table. This ensures the accuracy and reliability of the data in a database. In the latest SQL Complete version, CONSTRAINT hints are available for the ALTER TABLE statement.

Suggestion of UPDATETEXT

Starting now, dbForge SQL Complete v6.9 supports UPDATETEXT that can be used to update an existing text, ntext, or image as a whole or just partially.

Support for DISTRIBUTED_AGG in SELECT — GROUP BY

The DISTRIBUTED_AGG hint can now be used in the SELECT — GROUP BY clause.

Support for ALTER/DROP DATABASE SCOPED CREDENTIAL

With the support for ALTER/DROP DATABASE SCOPED CREDENTIAL in SQL Complete, you can quickly and easily change the existing database credentials and remove them from the server completely.

Support for Configuration Options for Query Store feature in ALTER DATABASE

In the latest version of SQL Complete, the ALTER DATABASE syntax has been enriched with new configuration options.

Support for WAIT_AT_LOW_PRIORITY in ALTER TABLE … SWITCH PARTITION

SWITCH PARTITION moves entire partitions between the existing tables almost instantly. New data can be loaded into separate tables and then switched in, while old data can be switched out to separate tables and then archived or purged.

In dbForge SQL Complete v6.9, you can use WAIT_AT_LOW_PRIORITY. This parameter allows the DBA to control the S and Sch-M locks that are used to rebuild the index online.

Support for new keywords in ALTER DATABASE SCOPED CONFIGURATION

Meet the wide variety of keywords we have added in the latest version of the add-in.

Support for CREATE/ALTER/DROP EVENT SESSION session_name ON DATABASE (for Azure SQL)

SQL Complete suggests full functionality for managing event sessions: creating new sessions, changing and removing the already created ones.

Support for ALTER SERVER CONFIGURATION in MEMORY_OPTIMIZED options

The memory-optimized table type is used to specify a predefined table definition. MEMORY_OPTIMIZED = ON syntax identifies that this table type will be on the memory-optimized structure.

Conclusion

Devart constantly and diligently works on improving its products. Today’s dbForge SQL Complete release is yet another step on a long path of making database development, administration, and management easier for experienced users and more comprehensible for beginners. We will be glad to hear your feedback regarding the product.

Just in case you are interested in more SQL Tools by Devart, feel free to visit our website.

Leave a Comment