The new release of SQL Complete 5.9 brings simplicity and security as well as helps safeguard access to data. Below is the summary of new features.

Active Directory – Universal with MFA support

To adhere to the highest industry standards, as well as to meet popular requests from our users, we have implemented the new authentication method of SSMS 17.2 – “Active Directory – Universal with MFA support” in the new version of SQL Complete. This two-step authentication provides an extra layer of protection, such as phone call, text message, or mobile app code, to deliver an even more secure access to data and applications while easy and convenient for end users.

Code Completion

Yet another portion was added on top of the long list of the statement suggestions supported in dbForge SQL Complete:

TEMPORAL_HISTORY_RETENTION

HISTORY_RETENTION_PERIOD

IDENTITY_CACHE and Automatic database tuning

Code Refactoring

Rename variables in UPDATETEXT, WRITETEXT, READTEXT, and REVERT statements in a few clicks using a handy Rename dialog window.

Productivity

The following features were specifically developed to make it easier for you to work with data in SSMS result grid.