Take full advantage of SQL Server 2019 with SQL Complete v6.5

June 10th, 2020

The dbForge team is delighted to announce a fresh release of our advanced solution for SQL database development – SQL Complete. The new version 6.5 is packed with improvements and the major one is full support for SQL Server 2019.

We are absolutely excited about SQL Complete 6.5. Here is why.

Full support for SQL Server 2019

From now on, SQL Complete users will not have to worry about the issues associated with SQL Server 2019 support. SQL Complete v6.5 fully supports it allowing you to benefit from all the features and capabilities that SQL Server 2019 offers.

SQL Complete New Edition

In response to many requests, we expand the range of SQL Complete editions and introduce SQL Complete v6.5 Standard Edition to give our customers more choice. SQL Complete Standard is a special edition offering full Intelligent SQL Completion and T-SQL Formatting capabilities. For those who need more, we’re happy to recommend Professional Edition featuring advanced Productivity and Code Refactoring options as well as SQL Formatting command-line interface support.

Microsoft SQL Server Management Studio v18.5 integration

The Devart team strives to keep its finger on the pulse and we are happy to announce that our SQL Complete v6.5 can be seamlessly integrated into the latest version of SSMS.

Suggest properties for built-in metadata functions (SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc.)

In SQL Complete v6.5,  properties for built-in metadata functions (SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc) are now prompted, allowing you to make full use of the system catalog to find out more about a database.

Suggest properties for built-in metadata functions

Temporary tables suggestion

At our users’ demand, we bring the suggestion of temporary tables variables and columns regardless of the database specified in the USE statement.

Temporary tables suggestion

OPENJSON objects suggestion

SQL Complete v6.5 can now boast suggestions for SQL server objects when working with OPENJSON SQL Server table-valued function.

OPENJSON objects suggestion

Hungry for more improvements?

We, at the dbForge team, are committed to ironing out all the hurdles for our users. We have supported a bunch of new functions and statements as well as expanded the support for a couple of existing ones. Meet them.

Support for the functions

  • NEWSEQUENTIALID
  • CERTPRIVATEKEY
  • CERTENCODED
  • PWDENCRYPT and PWDCOMPARE

Support for the SQL statements

  • GRANT ALTER ANY SECURITY POLICY
  • GRANT ALTER ANY SENSITIVITY CLASSIFICATION
  • GRANT ALTER ANY DATABASE SCOPED CONFIGURATION
  • GRANT ALTER ANY COLUMN MASTER KEY
  • GRANT ALTER ANY COLUMN ENCRYPTION KEY
  • GRANT EXECUTE ANY EXTERNAL SCRIPT
  • GRANT ALTER ANY EXTERNAL DATA SOURCE
  • GRANT ALTER ANY EXTERNAL FILE FORMAT
  • GRANT ALTER ANY EXTERNAL LANGUAGE
  • GRANT ALTER ANY EXTERNAL LIBRARY
  • GRANT ADMINISTER DATABASE BULK OPERATIONS

Expanded support for the function

  • PREDICT for SQL Server 2019

Expanded support for the statements

  • CREATE USER for Azure SQL Database
  • CREATE INDEX for SQL Server 2019
  • CREATE AVAILABILITY GROUP for SQL Server 2019
  • CREATE EXTERNAL LIBRARY for SQL Server 2019
  • ALTER DATABASE for SQL Server 2019
  • ALTER TABLE for SQL server 2019
  • ALTER EXTERNAL LIBRARY for SQL Server 2019
  • ALTER AVAILABILITY GROUP for SQL server 2019
  • DROP EXTERNAL RESOURCE POOL for SQL Server 2019
  • DROP EXTERNAL LIBRARY for SQL Server 2019
  • ACCELERATED_DATABASE_RECOVERY in ALTER DATABASE for SQL Server 2019

Availability

Want to stay up to date? Download a new shiny version of SQL Complete from our website and let us know your opinion of it.

Leave a Comment