Released: Oct 16, 2019

Updates in 9.5.21

Features

• Added a new ranked ordering option for suggestions.
• Added suggestions support for ADD/DROP SENSITIVITY CLASSIFICATION syntax introduced in SQL Server 2019.
• Added suggestions for COMPATIBILITY LEVEL values for all supported versions of SQL Server.

Fixes

• Fixed scenario that could lead to corruption of Prompt Options during export to a zip archive.
• Fixed an issue which would sometimes cause formatting to fail when applied to a script containing a PIVOT clause within an UPDATE statement.
• Fixed an issue where scripts containing HISTORY_RETENTION_PERIOD syntax would sometimes fail to format.