10.11.12.27800 - Released on 16 May 2022

Fixes

• Fixed an issue when applying autofixes in bulk.
• Fixed an issue where try_convert formatting could cause an error.
• Fixed an issue where Qualify Object Names would incorrectly qualify with synonyms from other schemas.
• Fixed an issue when auto completing INSERT INTO statements for tables in a different database to the current connection.

10.11.11.27632 - Released on 28 April 2022

Fixes

• Fixed an issue where the command palette wouldn't open in Visual Studio 2019/2022.
• Fixed an issue where nullif and try_convert did not respect function parenthesis settings when formatted.

10.11.10.27545 - Released on 20 April 2022

Features

• Improved suggestions for CREATE USER.

Fixes

• Fixed an issue where a semicolon was being incorrectly added when formatting a CREATE USER...FROM EXTERNAL PROVIDER statement.

• Fixed an issue where constraints were incorrectly being qualified when running the Qualify Object Names action.

10.11.9.27382 - Released on 30 March 2022

Fixes

• Fixed a crash introduced in v10.11.8.

10.11.8.27379 - Released on 30 March 2022

Fixes

• Fixed an issue where autofixes could fail when applied in bulk from the code analysis light bulb.
• Fixed an issue where a crash could sometimes occur when upgrading formatting styles on startup.
• Fixed a crash in early versions of SSMS 2016 when restoring tabs using tab history.
• Fixed an issue where some commands were not showing in Visual Studio (Copy as IN Clause, Find Invalid Objects, Open in Excel, Script Results as INSERT, Split Table).

10.11.7.27287 - Released on 23 March 2022

Fixes

• Fixed an issue where the command palette sometimes fails to load the database objects.
• Fixed an issue where some commands were not showing in Visual Studio (Copy as IN Clause, Find Invalid Objects, Open in Excel, Script Results as INSERT, Split Table).

10.11.6.27098 - Released on 09 March 2022

Fixes

• Fixed an issue where certain features were not available in Visual Studio (including Script As Alter).
• Fixed a crash when opening results in Excel when the results contain a NULL datetime value.
• Fixed a crash when Script As Alter encounters an error.
• Fixed an issue where the Add Square Brackets refactoring would fail when column names started with $.

10.11.5.26913 - Released on 25 February 2022

Features

• Added a command to the command palette to check whether the current connection's password has appeared in a data breach (using Have I Been Pwned?).

Fixes

• Improved the performance of the command palette when containing a large number of items.
• Fixed an issue where additional invalid columns would be suggested when using graph statements.
• Fixed an issue where physical names would be used for computed graph columns, instead of the logical name.

• Fixed an issue where table names would be incorrectly qualified in graph match clauses.

10.11.4.26759 - Released on 17th February 2022

Fixes

• Fixed an issue where errors may be shown when a script has certain code analysis issues.

10.11.3.26715 - Released on 16th February 2022

Fixes

• Fixed a crash when running some commands from the command palette.
• Fixed an issue where NULL values weren't being treated as blank cells when opening query results in Excel.
• Fixed an issue where Autofix ST008 (Use named parameters when calling procedure) would be shown for System Extended Stored Procedures (not supported).
• Fixed an issue where SQL Server 2000 warning messages could be shown when qualifying servers.

10.11.2.26629 - Released on 9th February 2022

Features

• Added the ability to change SQL Prompt's options from the command palette.

• Added the configured keyboard shortcuts for commands in the command palette.

Fixes

• Fixed locating some object types (users, database roles) in Object Explorer from the command palette.
• Added help context to the command palette for default constraints, check constraints, unique constraints, and primary keys.
• Prevented database users, database roles, and server roles from being shown twice in the command palette.
• Fixed suggestions for SET STATISTICS when setting multiple options.
• Fixed an issue where Open In Excel would only export the first results set.
• Fixed an issue where Autofix PE003 (Creation of table by SELECT INTO statement) may not work when objects were qualified.

• Fixed an issue where Autofix BP004 (INSERT without column list) could show an error when using temporary tables.

10.11.0.26431 - Released on 1st February 2022

Features

• Added a command palette (press Alt+S to open).

Fixes

• Fixed an issue where refreshing suggestions would not refresh other databases referenced in a query.
• Fixed an issue where the Formatting Styles dialog would open with parts off-screen, resulting in certain buttons not being visible.

• Fixed an issue where the Script as Insert and Copy as In options from the results grid would not copy DATE types correctly.