Released: May 12, 2023

Updates in V6.14.18

Features

• Optimized RAM usage.

Fixes

• Fixed an issue with the incomplete loading of the extension in SSMS.
• Fixed an error that could occur when integrating the application into SSMS 19.0.1.
• Fixed an error that could occur when displaying the completion list.
• Fixed a column hint for the table CTE.
• Fixed an issue with hints got missing in the completion list if the server and database had the same name.
• Fixed a logging file initialization error that occurred when launching the application.
• Fixed an...

Released: Dec 30, 2022

Updates in V6.14.7

Features

• Added support for Microsoft SQL Server Management Studio (SSMS) 19 Preview 4.
• Added column suggestions in ORDER clause for CREATE CLUSTERED INDEX statement.
• Added filegroups suggestions after SELECT INTO ON statement.
• Improved memory handling.
• Improved performance of hint processing.
• Improved formatting of SQL statements.

Fixes

• Fixed issues with Azure Active Directory - Universal with MFA authentication.
• Fixed errors that occurred when working with synonyms when searching for invalid...

Released: Oct 5, 2022

Updates in V6.12.8

Fixes

• Fixed an error that occurred when determining the JOIN clause for the completion list.
• Fixed a bug that occurred when opening multiple SSMS instances.

Released: Sep 12, 2022

Updates in V6.12.6

Features

• Microsoft SQL Server 2022 - Added support for:
  • 'ALTER DATABASE SCOPED CONFIGURATION'.
  • 'ALTER INDEX'.
  • 'ALTER TABLE'.
  • 'CREATE CLUSTERED INDEX'.
  • 'CREATE INDEX'.
  • 'CREATE TABLE'.
• Added query hints for 'DELETE', 'INSERT', 'SELECT', 'UPDATE' and 'MERGE' statements.
• Added support for 'BACKUP SYMMETRIC KEY' syntax construct.
• Added support for 'RESTORE SYMMETRIC KEY' syntax construct.
• Added support for 'DATE_BUCKET' function in Completion List, Quick Info and Parameter Information.

Fixes

• Fixed an...

Released: Jul 20, 2022

Updates in V6.11.5

Fixes

• Fixed an error that might occur when a computer entered sleep mode.
• Fixed an issue with switching the active window in VS to the Debug window and vice versa.

Released: Jun 24, 2022

Updates in V6.11.3

Features

• Added support for Microsoft SQL Server Management Studio (SSMS) v19 Preview 2.

Fixes

• Fixed an application error that occurred when starting SSMS 2014.
• Fixed the display of data in Data Viewer when changing the order of columns in the Editor.
• Fixed an error that might occur when opening documents.
• Fixed an issue with displaying Quick Info on an incomplete script.
• Fixed an issue with missing hints for Linked Server objects.
• Added temporary table hints that do not depend on the selected...

Released: Apr 4, 2022

Updates in V6.10.5

Features

• Added support for new functions in Completion List, Quick Info, and Parameter Information: GREATEST, LEAST, CURRENT_TIMEZONE, CURRENT_TIMEZONE_ID.
• Added support for the FORMATFILE_DATA_SOURCE parameter for bulk_options in the OPENROWSET function.

Fixes

• Fixed an unexpected exception that occurred when renaming a table in a project.
• Fixed an issue caused by SQL Complete catching a Data Pump exception.
• Fixed an issue that occurred when applying tab caption changes in new files.
• Fixed an...

Released: Jan 31, 2022

Updates in V6.9.34

Features

• Optimized the retrieval of object information from the server and removed unnecessary sorting.

Fixes

• Fixed an issue that occurred when navigating to the document from the execution notification window.
• Fixed an issue that occurred when retrieving machine configuration details for an error report.
• Fixed an issue that occurred when formatting single-line queries.
• Fixed an issue that occurred when loading an assembly.
• Fixed an unexpected exception that occurred when working with the...

Released: Nov 15, 2021

Updates in V6.9.28

Fixes

• Fixed an issue with opening a SQL document from a Microsoft Visual Studio project.
• Fixed an issue that occurred when working with SQL documents related to Visual Studio projects.
• Fixed an issue with loading the SQL Complete assembly after launching SSMS.
• Fixed an issue that occurred when working with variables in the SQLCMD mode.
• Fixed an issue that occurred when working with the CREATE SCHEMA statement in the SQL editor.
• Fixed an application launch issue.
• Fixed a document session...

Released: Oct 5, 2021

Updates in V6.9.16

Features

• Added support for CONSTRAINT suggestions in ALTER TABLE statements.
• Added support for UPDATETEXT which can be used to update existing text, ntext, or image as a whole or just partially.
• Added support for DISTRIBUTED_AGG in SELECT - GROUP BY. The DISTRIBUTED_AGG hint can now be used in the SELECT - GROUP BY clause.
• Added support for ALTER/DROP DATABASE SCOPED CREDENTIAL.
• Added support for Configuration Options for Query Store in ALTER DATABASE.
• Added support for WAIT_AT_LOW_PRIORITY in...