The new release of SQL Complete 5.9 brings simplicity to your SQL coding and provides an additional security approach to safeguard access to your data. Let’s take a closer look at what this release delivers.
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.
Results Grid Data Visualizer
Data Viewer allows you to instantly visualize data from the results grid via Hexadecimal, Text, XML, HTML, Rich Text, PDF, JSON, Image, and Spatial views.
Copy Data As XML, CSV, HTML, or JSON from SSMS grid
An easy way to retrieve data from SSMS results grid to a format suitable for you.
Copy Data As from SSMS grid to Clipboard or File
Quickly copy data in any available file format to a file or clipboard.
Shortcuts to SSMS grid popup menu assigned
Shortcuts assigned to Find, Copy Data As…To Clipboard, Generate Script As…To Clipboard will expedite your work with these options.
Try dbForge SQL Complete for free to evaluate its great functionality!
