Release 1.17.1

Version 1.17.1

• Release date: January 30, 2023
• Release status: GA

What's new in 1.17.1

• Fixed a regression causing Object Explorer to not show database objects for Azure SQL DB Basic SLO (microsoft/azuredatastudio#21735)

Release 1.17.0

Version 1.17.0

• Release date: January 25, 2023
• Release status: GA

What's new in 1.17.0

• BREAKING CHANGE - Connection Encryption is now Enabled by Default - #17484
  • Moving to Microsoft.Data.SqlClient 5.0.1 dependency with STS Update
  • By default, saved connection profiles will connect with encryption and only accept trusted server certificates. This is a breaking change for some connections and some saved connection profiles may require updates to connect.
  • See https://aka.ms/vscodemssql-connection for more information.
• Introduced HostNameInCertificate Connection Property.
• Exposed getServerInfo API to allow Target Platform to be set automatically when creating SQL Projects from database
  • microsoft/azuredatastudio#20363
  • microsoft/azuredatastudio#20576
• Accessibility Fixes
  • Fixed Screen Reader not reading status of "loading query" - #17451
  • Fixed Screen Reader to announce messages table in a clearer manner - #17450
  • Fixed issue where Results Table was not minimizable with keyboard - #17452

SQL Grammar Fixes & Updates

• Fix function syntax highlighting including non-function keywords #17462
• Match "other" keywords last - #17464
• Syntax Update (Mostly from SQL 2022) - #17465
• Add SELECT ALL and FULL/NATURAL JOIN syntax to grammar - #17508
  • Special thank you to @hanohrs for their help with this!

@microsoft/ads-adal-library v1.0.16

https://www.npmjs.com/package/@microsoft/ads-adal-library/v/1.0.16

Release 1.16.0

Version 1.16.0

• Release date: August 24, 2022
• Release status: GA

What's new in 1.16.0

• Added support for creating Azure Functions with SQL Bindings from Views in the Object Explorer
• Fixed issues with Integrated authentication in Unix environments #17333

Release 1.15.0

Version 1.15.0

• Release date: June 15, 2022
• Release status: GA

What's new in 1.15.0

• Add support for dependent extensions
• Fixed issues

Release Hotfix 1.14.2

Version 1.14.2

• Release date: May 20, 2022
• Release status: GA

What's new in 1.14.2

• Adds extension APIs for managing Azure resources

Release Hotfix 1.14.1

Version 1.14.1

• Release date: April 22, 2022
• Release status: GA

What's new in 1.14.1

• Fix regression in Object Explorer that causes timeouts expanding the Tables folder. microsoft/azuredatastudio#19166

Release 1.14.0

Version 1.14.0

• Release date: April 20, 2022
• Release status: GA

What's new in 1.14.0

• All SQL bindings functionality released in 1.13 moved to SQL bindings extension in extension pack
• Fixed connection string generated for SQL bindings on connection to <default> database. #17267
• Fixed error with heirarchyID data type in results pane. microsoft/sqltoolsservice#1450

Release 1.13.0

Version 1.13.0

• Release date: February 24, 2022
• Release status: GA

What's new in 1.13.0

• Adds context menu item for object explorer table nodes to create an Azure Function with SQL binding for that table
• Updated SqlParser to fix some intellisense issues
• Fixed decimal datatype handling microsoft/azuredatastudio#275
• Fixed BatchParser execution error caused by missing resource files #17221

Release 1.12.0

Version 1.12.0

• Release date: December 15, 2021
• Release status: GA

What's new in 1.12.0

• Fix AAD token refresh bugs
• Fix Azure SQL DB connectivity bug
• Add support for SELECT * column expansion
• Add Untrusted Workspace support