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.
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:
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.
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.
The DISTRIBUTED_AGG hint can now be used in the SELECT — GROUP BY clause.
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.
In the latest version of SQL Complete, the ALTER DATABASE syntax has been enriched with new configuration options.
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.
Meet the wide variety of keywords we have added in the latest version of the add-in.
SQL Complete suggests full functionality for managing event sessions: creating new sessions, changing and removing the already created ones.
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.
© Copyright 2000-2023 COGITO SOFTWARE CO.,LTD. All rights reserved