September 2023
Azure Data Studio 1.46.0 is the latest general availability (GA) release.
- Release number: 1.46.0
- Release date: September 20, 2023
What's new in 1.46.0
| New Item | Details |
|---|---|
| Attach/Detach Database | Introduced support for attaching and detaching databases (Preview) |
| Connection | Introduced support for custom cloud providers, see (Azure Data Studio - Azure Connectivity) for configuration information |
| Connection | Enabled Connection Pooling as default behavior |
| Connection | Introduced command SQL Server: Clear Pooled Connections to clear inactive pooled connections
|
| Database Properties | Introduced support for viewing database properties (Preview) |
| General | Added support for Server and Database properties (Preview) |
| Result Set | Updated copy notification to automatically close after three (3) seconds, and included an option to disable notifications |
| Result Set | Added a prompt to open the file location after saving result to Excel |
| Profiler Extension | Introduced a progress dialog when opening an XEL file |
| Server Properties | Introduced support for viewing server properties (Preview) |
| SQL Database Projects Extension | Released version 1.3.1 |
| SQL Database Projects Extension | Added support for "Azure Synapse Serverless SQL Pool” target platform |
| SQL Database Projects Extension | Added support for “Synapse Data Warehouse in Microsoft Fabric” target platform |
| SQL Database Projects Extension | Updated to Microsoft.Build.Sql SDK version to 0.1.12-preview |
Bug fixes in 1.46.0
| New Item | Details |
|---|---|
| Accessibility | Improved screen reader prompts for SQL Database Projects extension, Database Migration Assessment for Oracle extension, SQL Agent extension, and when installing a new extension |
| Accessibility | Addressed issues with install button tool tip, new connection button, and new server group buttons |
| Accessibility | Fixed color contrast for creating connections and notebooks, running queries, and deploying a server |
| Connection | Added refresh prompt for Azure accounts when error AADSTS700082 occurs |
| Connection | Introduced notification when a duplicate connection exists upon dragging a connection to a different group |
| Connection | Fixed issue to prevent Dashboard server name from being replaced with profile name |
| Connection | Added retry logic to wait for resume when establishing connection to a serverless Azure database |
| Connection | Fixed issue where tab color did not align with server group color |
| Connection | Updated Cluster Server connection property to have the correct Boolean value for Cosmos DB |
| Connection | Fixed issue with advanced connection options not correctly transferred to change password dialog |
| Connection | Addressed incorrect label for first connection in the Recent connections list |
| Connection | Improved account selection experience after enabling cloud settings |
| General | Fixed issue with incorrect cell colors when editing data |
| General | Addressed problem with invalid data for a column's data type when editing data |
| General | Re-enabled full screen toggle behavior for the F11 key binding |
| Notebooks | Addressed issue where kernel failed to change correctly when switching to Python |
| Query Editor | Fixed Intellisense refresh behavior |
| Query Editor | Improved query execution performance |
| Query Editor | Improved read performance for large data sets |
| Query Editor | Addressed issue where selecting Cancel would not immediately cancel a query that was executing |
| Query Editor | Resolved problem of queries hanging when executing against Synapse Dedicated Pool |
| Query Plan Viewer | Fixed issue where missing index definition recommendation included incorrect column |
| Query Plan Viewer | Addressed issue with query plan XML having the incorrect format |
| Result Set | Corrected XML formatting when opening a column from the result set |
| Result Set | Fixed issue where copying results to clipboard did not work |
| Schema Compare | Added support to automatically resize the split view when the window changes size |
| Schema Compare | Addressed error “StartIndex cannot be less than zero” which occurred when applying change using Schema Compare |
| Schema Compare | Display 'Yes' button to re-compare after changing options in Schema Compare |
| SQL Database Projects | Fixed issue where databases were not populated if a project was created from the server instead of a database |
| SQL Database Projects | Addressed error 'Could not run the "SqlModelResolutionTask" task because MSBuild could not create or connect to a task host with runtime "NET" and architecture "arm64"' resulting in build failure on arm64 with SDK-style and legacy style projects |
| Welcome Page | Improved display of Install button under the extension list on Welcome Page |
For a full list of bug fixes addressed for the September 2023 hotfix release, visit the September 2023 Release on GitHub.
For a list of the current known issues, visit the issues list on GitHub.
| Platform | Type | Download |
|---|---|---|
| Windows | User Installer | 64 bit ARM |
| System Installer | 64 bit ARM | |
| .zip | 64 bit ARM | |
| Linux | .tar.gz | 64 bit |
| .deb | 64 bit | |
| .rpm | 64 bit | |
| Mac | .zip | Universal Intel Chip Apple Silicon |