Devart Releases Update of dbForge Studio and SQL Tools With Support for SQL Server 2022
09/17/2022

The update delivers support for SQL Server 2022 Community Technology Preview 2.1 (CTP 2.1)

Online PR News – 17-September-2022 – Prague, Czech Republic – Devart, one of the leading developers of database management software, ALM solutions, and data providers, updated its dbForge Studio for SQL Server, dbForge SQL Complete, and dbForge SQL Tools — go-to solutions for fast and effective tackling of routine database-related tasks.

First and foremost, this update delivers full compatibility with Microsoft SQL Server 2022 Community Technology Preview 2.1.

Also expanded keyword suggestions for a few statements, namely, CREATE INDEX, ALTER INDEX, CREATE CLUSTERED INDEX, CREATE TABLE, ALTER TABLE, and ALTER DATABASE SCOPED CONFIGURATION.

In this release, you get two new query hints for your DELETE, INSERT, SELECT, UPDATE, and MERGE statements: DISABLE_OPTIMIZED_PLAN_FORCING and
{ FORCE | DISABLE } SCALEOUTEXECUTION.

You also get a few new functions available in Completion List, Quick Info, and Parameter Information:
DATE_BUCKET,
FIRST_VALUE and LAST_VALUE,
ISJSON,
JSON_ARRAY,
JSON_OBJECT,
JSON_PATH_EXISTS,
STRING_SPLIT.

To learn more about the recent release, refer to
https://blog.devart.com/get-the-latest-update-of-dbforge-studio-and-sql-tools-with-support-for-sql-server-2022.html

About Devart

Devart is a multiproduct company that delivers advanced tools for database development and administration, ALM solutions, data providers for database servers, as well as data integration and backup solutions.

For additional information about Devart, visit https://www.devart.com/.