Features

• Added suggestions support for new permission types in SQL Server 2019.

Fixes

• Fixed an issue with columns sometimes not being qualified when qualifying object names.
• Fixed an issue with some functionality not appearing for servers connected using Windows authentication.

Fixes

• Fixed an issue that caused SSMS to crash when connecting to an Azure server using Multi-Factor Authentication.

Features

• Added Azure support for the following 33 built-in T-SQL functions:
  • ASYMKEY_ID
  • ASYMKEYPROPERTY
  • CERT_ID
  • CERTPROPERTY
  • CERTENCODED
  • CERTPRIVATEKEY
  • CONNECTIONPROPERTY
  • CURRENT_TRANSACTION_ID
  • DECRYPTBYASYMKEY
  • DECRYPTBYCERT
  • DECRYPTBYKEY
  • DECRYPTBYPASSPHRASE
  • ENCRYPTBYASYMKEY
  • ENCRYPTBYCERT
  • ENCRYPTBYKEY
  • ENCRYPTBYPASSPHRASE
  • EVENTDATA
  • FULLTEXTCATALOGPROPERTY
  • FULLTEXTSERVICEPROPERTY
  • GET_TRANSMISSION_STATUS
  • HOST_NAME
  • KEY_GUID
  • KEY_ID
  • KEY_NAME
  • NEWSEQUENTIALID
  • OBJECT_DEFINITION
  • ORIGINAL_LOGIN
  • PERMISSIONS
  • SIGNBYASYMKEY
  • SIGNBYCERT
  • SYMKEYPROPERTY
  • VERIFYSIGNEDBYASYMKEY
  • VERIFYSIGNEDBYCERT

Fixes

• Find Invalid Objects no longer tries to analyse databases that are being filtered out.
• Fixed an issue where schema filtering settings were being lost when saving options.
• SQL Prompt no longer tries to cache a server when suggestions are disabled.

Fixes

• SP-7926 : The Code Analysis and Action List icons now correctly reposition themselves when moving SSMS/VS or any query windows.
• SP-7931 : The previous release undid the modification to ensure keywords were suggested in preference to snippets when using ranked suggestions, which is now reintroduced.
• SP-7939 : Computed columns such as COUNT(*) in SELECT COUNT(*) ... now appear correctly in the suggestions box when the context is valid.
• SP-7953 : Fixed text filtering of reserved and semi-reserved T-SQL keywords in suggestions so they match word boundary and camel case correctly (e.g. TIME will now match CURRENT_TIMESTAMP).
• SP-7954 : The heading text is no longer clipped in the Data(DML) panel of the edit styles dialog.
• SP-7955 : Added support for T-SQL scalar cryptographic built-in function IS_OBJECTSIGNED.

Features

• Improved handling of keywords when using ranked suggestions.
• Improved handling of CamelCase matches when using ranked suggestions.

Fixes

• SP-7874 : SQL Prompt now correctly suggests `BINARY` when writing `CREATE CERTIFICATE` statements.
• SP-7909 : Fixed filtering of string literals and SQL scripting variables when using ranked suggestions.
• SP-7928 : The `Qualify Object Names` refactoring will now prefer synonyms over other database objects if there is any ambiguity.

Fixes

• SP-7904 : Fixed an issue which would prevent navigation of the Tab History menu with the keyboard after a group expander was interacted with.
• SP-7920 : SQL Prompt now respects selection limits when multiple snippet selection placeholders (e.g. $SELECTIONSTART$/$SELECTIONEND$ and $CURSOR$) are used in the same snippet.
• SP-7930 : Fixed a crash relating to an 'unknown style name' when typing in a query window.
• SP-7931 : Fixed an issue where snippets were being suggested in preference to keywords.

Fixes

• SP-7876 : Fixed formatting bug that could generate broken T-SQL when using whitespace characters in Three or Four Part Names.
• SP-7885 : Fixed an issue which caused the suggestions box to show when typing within a string literal.
• SP-7891 : When writing a subselect on the same table, SQL Prompt now suggests columns from both the inner and outer instance of the table.

Fixes

• Added support for T-SQL scalar security built-in functions PWDCOMPARE and PWDENCRYPT.
• Fixed bug in previous release that prevented saving of user-defined custom aliases in the SQL Prompt options.

Fixes

• When typing to narrow down suggestions, snippets will now appear at the top if they are an exact match.
• Fixed a problem where columns were being incorrectly selected/deselected when using the column picker.
• Insert Semicolons now correctly handles all permutations of `COMMIT` statements.

Fixes

• Fixed a crash that could occur when displaying the Check for Updates (CFU) pop-up.
• Fixed an issue that would sometimes cause SET LOCK_TIMEOUT to parse incorrectly when supplied with a value of -1.

Fixes

• The options for column alias styles that surround the alias in single quotes have been changed to use double quotes, which is the recommended style.
• Insert Semicolons no longer inserts a semicolon after GET CONVERSATION GROUP statements.
• Square brackets are no longer added around collation names in some scenarios.
• The version of the 'chk' snippet shipped in Prompt 10 was faulty and did not match the original and correct version in Phil's article.
• Updated the 'tvc' snippet to handle incorrect characters in column names as reported in our forums and kindly fixed by Phil Factor.

Features

• Ranked suggestions (this is now the default).
  SQL Prompt will suggest syntax for you as you type and will now by default attempt to place the most relevant suggestions at the top, using a combination of type, how close the suggestion is to what you have typed, and what suggestions you have previously used.
• Tab History improvements.
  You can now star your favorite or most commonly used tabs, so you can navigate to them more easily.
• New auto-fixes.
• Microsoft SQL Server 2019 support.
• Added several snippets created by Phil Factor in product learning articles.
  • chk - Creates an extended event session, runs the code you want to test, extracts the output and then stops the session.
  • eata - An improved version of the ata snippet, so that it enforces certain coding standards, such as specifying whether the column accepts NULL values, and ensuring the new column is well-documented.
  • timings - Wraps a simple timings test harness around the selected code.
  • tvc - Automatically create a table variable (or temp table) in which to store the results of (for example) executing a stored procedure, function or query.
• Added two snippets to control script formatting: 'foff' (disable) and 'fon' (enable).

Fixes

• Open tabs in tab history now appear within the correct grouping.

Other

• Support for Microsoft SQL Server 2000 and Microsoft SQL Server 2005 has been removed.
• Removed built-in snippets 'j', 'neo' and 'yell'.