Announcing Azure Data Studio 1.43

Our regular users may have noticed we typically release Azure Data Studio every other month.  As such, this April release is a bonus with just a few updates to highlight (and yes, we are planning to have a release in May).

SQL Database Projects Extension GA

The biggest announcement is General Availability of the SQL Database Projects Extension!  This extension has received a wealth of support and improvement from the team over the past six months, and we are pleased to bring it to GA.  You can find complete details in our “Announcing SQL Database Projects extension General Availability” post, but we'll mention here that the GA release includes enhancements to the projects view, accessibility improvements, and a few bug fixes.

Connectivity

We continue to iterate on the connection experience, both in terms of features and fixes.  In the 1.42 release we introduced support for Secure Enclaves when using Always Encrypted, and in this release we updated the dialog to note that a value for Attestation protocol is required when Secure enclaves is enabled, and if ‘Host Guardian Service’ or ‘Azure Attestation’ are select for Attestation protocol, then Attestation URL is required:

Screenshot of Connection Security options

Fixes for the experience ranged from addressing a problem with encoding in the OSX keychain on macOS to adding support for Azure MFA and ‘Sql Authentication Provider’ on Linux, with a host of other items in between.  As always, if you encounter a connection problem after upgrading to the latest release, please let us know by logging an issue in GitHub).  We continue to test a combination of scenarios, but we recognize that your setup may be unique, and we appreciate your assistance in identifying gaps and problems.

Odds and Ends

User Management functionality will continue to expand in Azure Data Studio.  This feature is still in preview, but you can enable it by within Settings by enabling the Workbench: Enable Preview Features option.  In this release, double-clicking on a Login or User from Object Explorer will open the designer, and doing the same on a table in Object Explorer will open Table Designer.

The team introduced additional time-saving changes in 1.43, including a Parse button on Query Editor, and we modified a couple existing buttons on the toolbar.  Before and after for clarification:

Screenshot of Query Editor toolbar in ADS 1.42

Screenshot of Query Editor toolbar in ADS 1.43

Finally, a long-standing request for Query Results has been implemented that supports selection of the entire row when you double-click on any cell in the row.  

Summary

If you’d like to see a list of all the issues for Azure Data Studio 1.43, please check out the release notes.  We’ve seen an uptick in the number of folks running Insider builds, and we thank those of you that have taken that leap and then also report issues and share ideas in the GitHub repository.  As mentioned, we will have another release in May, and after that we’ll provide a look into what’s coming next in Azure Data Studio.  Stay tuned!