Release 1.20.1

Version 1.20.1

• Release date: August 7, 2023
• Release status: GA

What's new in 1.20.1

• Fixed an issue with not being able to download the SQL Tools Service Component in a proxy-enabled environment (#17755)

Release 1.20.0

Version 1.20.0

• Release date: July 26, 2023
• Release status: GA

What's new in 1.20.0

• Added new setting to support enabling connection pooling for performance improvement - #17733
• Bug Fixes:
  • Fixed issue where creating connection with connection string would fail - #17737
  • Fixed issue where Copy actions wouldn't work on Data Grid cells - #17722
  • Added missing DB Create syntax keyword colorization - #17732
  • Improved connection description when selecting connection from quick pick - #17737
  • Fixed authentication issue where user account could not be found in MSAL Cache in Linux - #17747

Release 1.19.1

Version 1.19.1

• Release date: June 5, 2023
• Release status: GA

What's new in 1.19.1

• Performance improvement in Query Editor language service by enabling connection pooling (microsoft/azuredatastudio#22970)
• Fixed an issue where hyphenated user accounts failed to login to Azure SQL Server (microsoft/azuredatastudio#23210)

Release 1.19.0

Version 1.19.0

• Release date: May 24, 2023
• Release status: GA

What's new in 1.19.0

• Added support for Linux ARM64 runtime - #17639
• Use preferred username instead of email for Azure accounts - #17606
• Removed prompt to select tenant when SQL Auth Provider is enabled - #17611
• Updated msal-node npm package to v1.16.0 - #17605
• Bug Fixes
  • Added validation for servername before attempting connection #17680
  • Fixed an issue when selecting "Add Azure Account" during profile creation prompts for profile name first #17664
  • Fixed a bug where SQLCMD variables weren't getting JSONified #17683

Release 1.18.0

Version 1.18.0

• Release date: March 22, 2023
• Release status: GA

What's new in 1.18.0

• Upgraded AAD Azure account management to support MSAL authentication.
• Added native MacOS and Windows arm64 support - #17614
• Added "Group by Schema" to Object Explorer - #17543
• Add Object Explorer connection timeout setting - #17548
• Accessibility Fixes
  • Screen Reader is not reading the full information related to the database name - #17204
  • After pressing tab key from "More actions" keyboard focus is going to bottom status bar instead of going to the "messages" dropdown - #17192
  • Message window does not expand and collapse with the help of keyboard and shortcut key - #1687

@microsoft/ads-adal-library v1.0.17

Fixes:

• Fixes bug where incorrect home tenant would be used to acquire access token.

Link to NPM Package

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