Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux. To learn more, visit our GitHub.
The key highlights to cover this month include:
- Added deployments of Azure SQL Database and virtual machines (VMs).
- Added PowerShell kernel results streaming support.
- New extension updates.
- Bug fixes.
For a list of complete updates, refer to the Azure Data Studio release notes.
Added deployments of Azure SQL Database and VMs
You can now deploy Azure SQL resources from the deployment wizard in Azure Data Studio. These new options sit alongside local options like SQL Server on-premises and on Big Data Clusters and hybrid options, like SQL Managed Instance on Azure Arc. The deployment wizard includes UI-assisted Notebook experiences to deploy Azure SQL virtual machines and links to the Azure portal to create SQL databases, database servers, and elastic pools (SQL managed instances are not yet included).
This added experience comes with the overall commitment to add more Azure resource management into Azure Data Studio. The announcements above mention the inclusion of Azure Arc and Azure SQL Edge. Recently in June, we added a link to Open in Azure Portal for any existing Azure SQL server in Azure Data Studio. Expect more improvements like this to come in future releases.
Added PowerShell kernel results streaming support
We have received several requests from the community that PowerShell notebooks need to support results streaming. As it turns out, this change required changes in the Open Source PowerShell kernel, which we are also active maintainers. If you upgrade to the latest PowerShell kernel, you will now be able to have results streaming supported as shown below.
New extension updates
With this release, we have pushed out new versions of the following extensions. If you have not tried out these extensions before, check out each extension’s documentation and try it out.
If you would like to help make Azure Data Studio an even better product, share any feedback or report issues through our Issues page. Our engineering team is regularly going through the untriaged issues and assigning issues into different monthly milestones so that you know we are working on it. Your votes on issues help us prioritize.
Take a look at the full list of bug fixes for the October release.