Devart Hones DevOps Automation to Perfection in dbForge Studio for SQL Server 6.1

December 21st, 2021

We are thrilled to roll out the new version of dbForge Studio for SQL Server—our multi-featured IDE for database development, management, and administration. The release brings a number of new features and improvements.

In the previous update of dbForge Studio for SQL Server, we introduced the long-awaited DevOps Automation feature. In this version, we keep perfecting the DevOps capabilities and improve the functionality further for you to be able to embrace and implement the best DevOps practices in your routine.

What’s New

DevOps Automation Improvements

dbForge Studio for SQL Server comes with an advanced DevOps Automation tool that brings the best continuous integration practices to the database development and thus takes it to a whole new level. In this version of the Studio, we are adding the support for the Execution step for the Jenkins, TeamCity, and Bamboo plugins.

dbForge Studio for SQL Server - DevOps Automation Execute Step added

Support for New Functions, Statements, and Keywords

UPDATETEXT

In dbForge Studio for SQL Server 6.1, you can benefit from objects hints for the UPDATETEXT function.

dbForge Studio for SQL Server 6.1 - New keywords suggested - UPDATETEXT

SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE, and SEMANTICSIMILARITYDETAILSTABLE

The SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE, and SEMANTICSIMILARITYDETAILSTABLE functions are now suggested and the syntax check is available for them.

SEMANTICSIMILARITYTABLE, SEMANTICKEYPHRASETABLE, and SEMANTICSIMILARITYDETAILSTABLE functions support in SQL Complete

Check constraints hints for the ALTER TABLE statements

You can now enjoy the automatic suggestions of check constraints when working with the ALTER TABLE Statements.

dbForge Studio for SQL Server - Check constraints hints for the ALTER TABLE statements

WAIT_AT_LOW_PRIORITY option for the ALTER TABLE … SWITCH PARTITION statements

The WAIT_AT_LOW_PRIORITY option is now supported and suggested in the ALTER TABLE ... SWITCH PARTITION statements.

dbForge Studio for SQL Server - WAIT_AT_LOW_PRIORITY option supported

DISTRIBUTED_AGG in the SELECT – GROUP BY queries

The DISTRIBUTED_AGG hint is now available for the SELECT — GROUP BY queries.

dbForge Studio for SQL Server - support for DISTRIBUTED_AGG in the SELECT - GROUP BY queries

ALTER/DROP DATABASE SCOPED CREDENTIAL

dbForge Studio for SQL Server 6.1 brings the suggestion of keywords for ALTER/DROP DATABASE SCOPED CREDENTIAL statements.

dbForge Studio for SQL Server 6.1 - support for ALTER/DROP DATABASE SCOPED CREDENTIAL

ALTER DATABASE SCOPED CONFIGURATION

We are also adding the suggestion of keywords for the ALTER DATABASE SCOPED CONFIGURATION statement.

dbForge Studio for SQL Server 6.1 - support for ALTER DATABASE SCOPED CONFIGURATION

MEMORY_OPTIMIZED in the ALTER SERVER CONFIGURATION statements

To speed up your SQL coding, we introduce the suggestion of keywords for the MEMORY_OPTIMIZED syntax element in the ALTER SERVER CONFIGURATION statements.

dbForge Studio for SQL Server 6.1 - support for MEMORY_OPTIMIZED syntax element

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

For efficiency’s sake and to simplify your work with event sessions, we deliver the support for the СREATE/ALTER/DROP EVENT SESSION session_name ON DATABASE statements.

dbForge Studio for SQL Server - support for CREATE/ALTER/DROP EVENT SESSION

Query Store options in the ALTER DATABASE statements

We extend the number of supported options for configuring the Query Store parameters.

dbForge Studio for SQL Server 6.1 supports Query Store options in the ALTER DATABASE statements

Get the new shiny update

Interested? Download the fresh version of dbForge Studio for SQL Server and explore its new features.

Comments are closed.