SQL Complete v7.0 release notes

Last modified: April 9, 2025

  • Introduced the Enterprise Edition of SQL Complete with T-SQL Code Analyzer
  • Added integration support for Microsoft Visual Studio 2022
  • Added integration support for Microsoft SQL Server Management Studio 20.2
  • Added support for non-aggregated columns in GROUP BY statements
  • Added support for viewing the MSDescription property for databases
  • Added support for the PERSISTENT_LOG_BUFFER construct in CREATE DATABASE statements
  • Added support for the RSA_OAEP algorithm in CREATE COLUMN ENCRYPTION KEY statements
  • Added support for the COLUMN MASTER KEY server object
  • Added support for T-SQL graph functions: EDGE_ID_FROM_PARTS, GRAPH_ID_FROM_EDGE_ID, GRAPH_ID_FROM_NODE_ID, NODE_ID_FROM_PARTS, OBJECT_ID_FROM_EDGE_ID, and OBJECT_ID_FROM_NODE_ID
  • Added support for the TERTIARY_WEIGHTS function
  • Extended support for the AVAILABILITY GROUP constructs
  • Redesigned the SQL Query history toolbar with an updated date range selection and a new Clear button
  • Added the ability to save user-defined column layouts in Query History
  • Added CLI automation for Find Invalid Objects
  • Added Save Command Line for Find Invalid Objects
  • Added Save Command Line for SQL Formatter Wizard
  • Support suggestions for Implicit Procedure Execution

Want to find out more?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by SQL Complete.

All features

All features

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

Request a demo

Request a demo

If you consider employing this tool for your business, request a demo to see it in action.

SQL Complete logo

Ready to start using  

SQL Complete?

Download a FREE 14-day trial