Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
MIT License
Published by erpett 2 months ago
Azure Data Studio 1.49.1 is the latest general availability (GA) release.
New Item | Details |
---|---|
Extensibility | Fixed minimum version detection error causing extensions to incorrectly show no extension update available |
Installer | Fixed the certificate signing the Azure Data Studio Windows installers displaying as signed by Microsoft Azure instead of Microsoft |
Shell | Fixed an issue with the Windows executable of Azure Data Studio has product version property as undefined |
For details about the issues addressed in the August 2024 hotfix release, visit the August 2024 hotfix Release on GitHub.
New Item | Details | Workaround |
---|---|---|
Installation | Azure Data Studio installation fails on RHEL 8 | Use RHEL 9, or manually install glibc-2.29 and add it to the Library Path and then re-install ADS |
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 |
Published by caohai 3 months ago
Azure Data Studio 1.49.0 is the latest general availability (GA) release.
New Item | Details |
---|---|
SQL Database Projects Extension | Support for Fabric mirrored SQL database (preview) target platform |
New Item | Details |
---|---|
Accessibility | Accessibility improvements were made in the Database Properties dialog. |
Query editor | Fixed query editor override of transaction isolation level setting in T-SQL script. |
For details about the issues addressed in the July 2024 release, visit the July 2024 Release on GitHub.
New Item | Details | Workaround |
---|---|---|
Installation | Azure Data Studio installation fails on RHEL 8 | Use RHEL 9, or manually install glibc-2.29 and add it to the Library Path and then re-install ADS |
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 |
Published by erpett 4 months ago
Azure Data Studio 1.48.1 is the latest general availability (GA) release.
New Item | Details |
---|---|
Shell | Improved in-app update notifications to use Microsoft Download Center directly |
For details about the issues addressed in the June 2024 Hotfix, visit the 1.48.1 Hotfix - Update Server on GitHub.
New Item | Details | Workaround |
---|---|---|
Installation | Azure Data Studio installation fails on RHEL 8 | Use RHEL 9, or manually install glibc-2.29 and add it to the Library Path and then re-install ADS |
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 |
Published by erpett 8 months ago
Azure Data Studio 1.48.0 is the latest general availability (GA) release.
New Item | Details |
---|---|
Backup/Restore | Add restore from S3-compatible storage to restore dialog |
Backup/Restore | Add Restore Database option to Database context menu in Object Explorer |
Backup/Restore | Add SQL Server Restore from URL to restore dialog |
Copilot | Add ability to change github account |
Query Editor | Add Session ID / SPID to query editor tabs |
Object Explorer | Add ability to enable Ledger in Create Database dialog |
Shell | Support Connect command when launching ADS from the command line |
New Item | Details |
---|---|
Connections | Fixed Azure AD - Universal with MFA support doesn't work on Redhat Linux |
Connections | Fixed Error: “Cannot read properties of undefined (reading 'serverInfo')” |
Connections | Fixed proxy errors browsing Azure resources |
Connections | Fixed Error: “UserName cannot be null or empty when using SqlLogin authentication” message when using ’Active Directory Default' authentication |
Edit Data | Deleting row causes focus to be in wrong row |
Notebooks | Fixed Installing Notebook dependencies failed with error: Cannot read property 'version' of undefined |
Notebooks | Fixed "Open in editor" link in Notebooks search results doesn't work |
Object Explorer | Removed the drop database icon from the connection browser menu |
Query Editor | Fixed tabs not visible in query editor |
Query Editor | Fixed query editor does not display any results when results being with “#” |
Query Editor | Improved speed when copying data from results grid to clipboard |
Query Editor | Fixed blank/empty results pane after executing a query |
Query Editor | Fixed invalid results when field contains HTML or XML |
For details about the issues addressed in the February 2024 release, visit the February 2024 Release on GitHub.
New Item | Details | Workaround |
---|---|---|
Installation | Azure Data Studio installation fails on RHEL 8 | Use RHEL 9, or manually install glibc-2.29 and add it to the Library Path and then re-install ADS |
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 |
Published by erpett 10 months ago
Azure Data Studio 1.47.1 is the latest general availability (GA) release.
New Item | Details |
---|---|
Query Editor | Fixed query results with blank string interpreted as XML |
Shell | Fixed not all installation files signed |
Security | Update to Microsoft.Data.SqlClient 5.1.3 that patches CVE-2024-0056 |
New Item | Details | Workaround |
---|---|---|
Installation | Azure Data Studio installation fails on RHEL 8 | Use RHEL 9, or manually install glibc-2.29 and add it to the Library Path and then re-install ADS |
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 |
Published by erpett 10 months ago
New Item | Details |
---|---|
Security | Update to Microsoft.Data.SqlClient 5.1.3 that patches CVE-2024-0056 |
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 |
Published by erpett 12 months ago
Azure Data Studio 1.47.0 is the latest general availability (GA) release.
New Item | Details |
---|---|
Connection | Improved visibility of advanced options in tabs and tooltips |
Database Properties | Implemented usability improvements to object properties dialogs |
Extensibility | Allow extensions to hook into provider events |
Extensibility | Improved charting capability |
General | Enabled Mssql: Parallel Message Processing by default to improve application performance when working with MSSQL connections. |
General | Added Mssql: Parallel Message Processing Limit with a default of 100 to control the number of threads used for parallel processing. |
General | Updated notifications so they close automatically upon task completion |
Notebooks | Updated version to 6.5.6 and removed traitlets v5.9.0 from required notebook dependencies |
Object Explorer | Added Select Top 1000 menu option for the history table of a system-versioned temporal table |
Object Explorer | Usability improvements including added context menus |
Result Set | Added additional options for saving results to Excel |
Result Set | Added support to display formatted XML data when stored as a VARCHAR data type |
User Management | References to Azure Active Directory (Azure AD) have been updated to Microsoft Entra, see Azure AD is Becoming Microsoft Entra ID for details. |
VS Code Merge | Merges upstream improvements from VS Code 1.80, 1.81, and 1.82. These releases contained numerous new features as well as quality, performance, stability, and compliance enhancements. The full details can be reviewed in the VS Code release notes at: Visual Studio Code June 2023, Visual Studio Code July 2023, and Visual Studio Code August 2023. |
New Item | Details |
---|---|
Authentication | Fixed error "multiple matching_tokens occurred when acquiring token." when authenticating to Azure resources |
Autocomplete | Fixed autocomplete suggests "abort" whenever new comment is begun |
Connection | Updated prefix for Clear Pooled Connections in the command palette to use the MSSQL prefix |
Connection | Fixed proxy setting values not being passed to backend SQL Tools Service |
Connection | Removed tenant filter config setting |
Extensibility | Fixed issue where server dashboard was loading before activation of extension completed |
Notebooks | Fixed issue where the Notebook Python process continued to run after Azure Data Studio is closed |
Notebooks | Fixed Jupyter Notebook entry in new file command under command palette does nothing |
Object Explorer | Fixed silent failure when attempting to open script files |
Object Explorer | Removed duplicate entry for Group By Schema from command palette |
Object Explorer | Addressed behavior where selecting Manage for an Azure SQL Database opened the dashboard for the logical server instead of the database |
Profiler Extension | Fixed issue where Profiler columns were not resizeable |
Profiler Extension | Resolved problem where selecting Ctrl + F in the Profiler extension did not bring up Find dialog |
Query Editor | Updated maximum value supported for Query: Text Size setting to fix results not being copied to the clipboard |
Query Editor | Fixed issue where query editor would not open due to initialization errors |
Query Editor | Fixed error "Cannot connect to the database due to invalid OwnerUri" after saving a new query file |
Query History Extension | Fixed error loading query history items |
Schema Compare | Fixed issue where schema compare does not show that it is running while doing a comparison |
Schema Compare | Fixed issue where Azure Data Studio stops responding after attempting to apply schema compare changes |
Shell | Shortened query tab titles for edit data |
Shell | Updated hyperlinks to use correct theming so they are visible when using dark theme |
Shell | Updated shell default behavior to not open any editor when Show welcome page on startup is not selected |
SQL Project | Fixed issue where database project fails to build with syntax error when including a database scoped credential object |
For details about the issues addressed in the November 2023 release, visit the November 2023 Release on GitHub.
New Item | Details | Workaround |
---|---|---|
Installation | Azure Data Studio installation fails on RHEL 8 | Use RHEL 9, or manually install glibc-2.29 and add it to the Library Path and then re-install ADS |
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 |
Published by erpett about 1 year ago
Azure Data Studio 1.46.1 is the latest general availability (GA) release.
New Item | Details |
---|---|
Security | Update to Electron v22.3.25 with patch for CVE-2023-5217 |
For details about the issue addressed in the September 2023 hotfix release, visit the September 2023 Hotfix 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 |
Published by erpett about 1 year ago
Azure Data Studio 1.46.0 is the latest general availability (GA) release.
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 |
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 |
Published by erpett about 1 year ago
Azure Data Studio 1.45.1 is the latest general availability (GA) release.
New Item | Details |
---|---|
Connection | Fixed an issue that prevented all connections from appearing in the server tree view. |
Connection | Updated recent connections list to include connections that are not saved. |
Database Migration Assessment for Oracle | Resolved issue where links to open the assessment output were no longer working. |
Database Schema Conversion Toolkit | Resolved issue where links to open the conversion output were no longer working. |
Installation | Addressed error "gyp WARN install" for Windows arm64. |
Profiler | Fixed an issue where the session dropdown was not populated when an XEL file is opened. |
Profiler | Addressed issue where running state was incorrectly set after a session was started. |
For a full list of bug fixes addressed for the July 2023 hotfix release, visit the July 2023 Hotfix Release on GitHub.
New Item | Details | Workaround |
---|---|---|
Installation | Azure Data Studio installation fails on RHEL 8 | Use RHEL 9, or manually install glibc-2.29 and add it to the Library Path and then re-install ADS |
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 |
Published by erpett over 1 year ago
Azure Data Studio 1.45.0 is the latest general availability (GA) release.
New Item | Details |
---|---|
Connection | Introduced support for Tenant hierarchy in the Azure tree |
Connection | Updated Azure tree icons |
Connection | Updated the Azure tree in the Connection Pane to show only available resource types |
Connection | Added Azure Postgres Flexible Server and Azure CosmosDB for PostgreSQL in the Azure resource tree |
Connection | Added support for advanced connection options for other providers |
Connection | Added capability to clear encryption keys with the 'Clear Azure Account Token Cache' command |
Connection | Introduced support for connection pooling for MSSQL connections |
GitHub Copilot | GitHub Copilot extension version 1.95.239 |
MySQL Extension | General Availability |
Object Explorer | Added support for additional Filter options in Object Explorer |
Object Explorer | Reduced size of server group color block |
Object Explorer | Enabled 'Async Server tree' for the Server tree view |
Object Explorer | Added inline actions (e.g. edit, delete, refresh) |
Object Explorer | Introduced an action to collapse all open objects in Object Explorer |
Object Explorer | Added ability to use left and right arrows in OE to open or close trees |
Object Explorer | Right-click menu options updated and order modified |
Profiler / Extended Events | Introduced support for opening .XEL files up to 1GB in size |
Query Editor | Introduced a new configuration option to control whether to add a line break between rows when copying if the previous row has a trailing line break |
Result Set | Introduced keyboard shortcut (Ctrl/CMD + Shift + C) to copy information from the results grid with headers |
Result Set | Introduced keyboard shortcut (Ctrl/CMD + Shift + O) to sort columns in a result set |
SQL Database Projects Extension | Added the ability to create a publish profile from the Add Item… menu |
Table Designer | Added configuration option to prevent DDL triggers from being disabled as part of the table modification |
User Management | Improved table component performance in the Securables dialog of User properties |
VS Code merge | VS Code merges to version 1.79, read their release notes to learn more |
New Item | Details |
---|---|
Accessibility | Improved contrast for buttons on Welcome page when using light themes |
Accessibility | Improved focus on Home tab when using High Contrast Aquatic/Desert theme |
Accessibility | Corrected border color the issue reporter dialog when using light theme |
Accessibility | Fixed multiple issues with screen readers |
Accessibility | Improved keyboard navigation in select database dropdown and added visual label |
Accessibility | Added required indicator for Server group name when configuring a server group |
Accessibility | Fixed display so contents are visible at 200% zoom in Notebook cell |
Accessibility | Added tooltip for Learn more button in New Deployment window |
Backup/Restore | Addressed issue with backup/restore dialog titles not updating for non-MSSQL databases |
Central Management Servers Extension | Resolved error generated after saving a connection using SQL authentication |
Charting | Addressed issue with mix/max value setting for a chart axis |
Connection | Improved dialog window for adding an Azure account when authentication code is required |
Connection | Fixed throttling of ARM requests when in the Browse Connections tab |
General | Fixed issue with vertical scrolling in dialog windows |
General | Fixed error "Cannot read properties of undefined" |
Notebooks | Addressed inability to open JSON in a new tab from Notebook results cell |
Notebooks | Fixed error "Unable to load and parse grammar for scope markdown.math.inline" when creating a Notebook text cell |
Object Explorer | Addressed connection leak which occurred when renaming a table |
Object Explorer | Improved error handling in server tree expand requests |
Object Explorer | Fixed issue with unexpected connection drops in Object Explorer |
Query Editor | Corrected syntax highlighting for nested multi-line comments |
Query Editor | Addressed issue where folding behavior incorrectly included blank lines at the end of a text block |
Query Editor | Resolved issue when executing USE DATABASE_NAME command and database context did not change in the status bar |
Query Plan Viewer | Fixed issue with filter icon appearing over query text in Top Operations window |
Result Set | Fixed issue where HTML entered in Edit Rows mode was being rendered |
Result Set | Fixed incorrect aggregation (sum) when selecting rows in the result set and implemented performance improvements |
Result Set | Improved support for copying large result sets to the clipboard |
Result Set | Added progress notification when copying result sets and implemented performance improvements |
Result Set | Improved formatting and result set navigation for columns containing XML |
Result Set | Added notification to identify when the number of rows or columns copied exceed Excel limits |
SQL Database Projects Extension | Addressed issue with schema compare dropping constraints |
SQL Database Projects Extension | Removed incorrect delete command from database references node |
SQL Database Projects Extension | Introduced ability to add sqlcmd variables without a default value via the quickpick |
User Management | Removed unsupported database roles for Azure SQL DB user creation |
User Management | Included MUST_CHANGE option for Azure SQL when creating a new login or for a password change |
New Item | Details | Workaround |
---|---|---|
Installation | Azure Data Studio installation fails on RHEL 8 | Use RHEL 9, or manually install glibc-2.29 and add it to the Library Path and then re-install ADS |
For a full list of bug fixes addressed for the July 2023 release, visit the July 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 |
Published by erpett over 1 year ago
Azure Data Studio 1.44.1 is the latest general availability (GA) release.
New Item | Details |
---|---|
Backup & Restore | Fixed an issue in Object Explorer where the Restore dialog failed to open. https://github.com/microsoft/azuredatastudio/issues/23257 |
Connection | Resolved issue that caused a login failure in Azure SQL for hyphenated user accounts. https://github.com/microsoft/azuredatastudio/issues/23210 |
Object Explorer | Addressed inability to open a view using CTRL/CMD + Q or the Open View menu. https://github.com/microsoft/azuredatastudio/issues/23236 |
Query Editor | Introduced a performance improvement in the Query Editor language service by enabling connection pooling. https://github.com/microsoft/azuredatastudio/issues/22970 |
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 |
Published by erpett over 1 year ago
Azure Data Studio 1.44.0 is the latest general availability (GA) release.
New Item | Details |
---|---|
Connection | Enabled Sql Authentication Provider by default for Azure SQL connections and the MSAL Authentication Library. Learn more at Connect with Azure Data Studio |
Connection | Introduced support for passing in advanced connection options in command line arguments |
Connection | Added ability to provide an Application Name in the connection string parameter |
General | Added support for customizing table keyboard shortcuts |
General | Added warning notification on startup if Azure PII logging is enabled |
GitHub Copilot | GitHub Copilot extension for autocomplete-style suggestions added to extension gallery. Learn more at https://aka.ms/ads-copilot |
Notebooks | Fixed issue where deleted text listed using the Find feature |
Object Explorer | Introduced filtering capability for Object Explorer (preview) |
Query Editor | Shorted text for Change Connection and Export as Notebook button |
Query Results | Increased the default max column width |
SQL Database Projects Extension | Released version 1.1.1 |
SQL Database Projects Extension | Improved performance of loading one or more large projects |
SQL Database Projects Extension | Introduced ability to save publish settings to a new or existing publish profile |
User Management | Added support for creating database and server roles (preview) |
User Management | Improved authentication options when creating database users (preview) |
New Item | Details |
---|---|
Accessibility | Added labels to radio groups in SQL Database Projects dialog |
Accessibility | Fixed issue with narrator reading character twice in network share path for Azure SQL migration extension |
Accessibility | Addressed problem where keyboard focus did not shift to error message when creating a new database |
Accessibility | Fixed issue with voiceover not announcing label names correctly when updating a database project |
Connection | Improved token refresh behavior |
Connection | Enabled support to login with blank passwords when creating MSSQL connection |
Connection | Added change password dialog display after password expiration occurs for a SQL login |
Connection | Addressed scenario where Intellisense stopped working after a connection token expired |
Connection | Fixed behavior where PostgreSQL username was incorrectly replaced |
Connection | Implemented support for connections against the same server but with different properties |
Connection | Resolved issue where connection status changed to red (disconnected) after moving an active connection to a server group |
Connection | Updated Azure node in Connection dialog to include notation when no subscriptions are found |
Connection | Updated firewall dialog to pre-select the account and tenant in the connection dialog |
Extension | Fixed an issue with over-encoded URLs in diagnostic error messages |
Intellisense | Resolved issue with SORT_IN_TEMPDB not recognized as valid T-SQL syntax when creating an object |
Notebooks | Updated Notebook connection to support MySQL and PostgreSQL when connecting to an existing Notebook |
Query Results | Fixed overlapping action display when multiple result sets are returned |
Schema Compare | Update scmp files to be backwards compatible |
SQL Database Projects Extension | Fixed multiple issues related to SQLCMD variables and projects |
SQL Database Projects Extension | Addressed a failure that was occurring when using schema compare with Azure Synapse dedicated pools |
SQL Database Projects Extension | Resolved problem where a database project would not build after a reference to a system database was added from SSDT |
SQL Database Projects Extension | Fixed issue where projects were listed twice when using multi root workspaces |
SQL Database Projects Extension | Fixed an issue where file structure information was not stored in the scmp file after a schema compare |
SQL Database Projects (VS Code) | Updated default folder location when creating a new project from database workflow |
For a full list of bug fixes addressed for the May 2023 release, visit the May 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 |
Published by erpett over 1 year ago
New Item | Details |
---|---|
Connection | Added notation for required properties (e.g. Attestation protocol and Attestation URL) when Secure Enclaves are enabled |
SQL Database Projects extension | General Availability |
SQL Database Projects extension | Move and rename files within Database Projects view |
SQL Database Projects extension | SQLCMD variables available for editing in Database Projects view |
Object Explorer | Double-clicking on a user or table in Object Explorer will open the designer for the object |
Query Editor | Added a Parse button to the Query Editor toolbar for parsing queries before execution |
Query Results | Added support to select a row in query results via double click |
New Item | Details |
---|---|
Connection | Added support for linked accounts with same username but different domains |
Connection | Fixed issue with incorrect cache write path |
Connection | Added ability to include optional name and grouping when creating a new connection using a connection string |
Connection | Updating username in MSSQL connections to use Preferred username for the display name |
Connection | Fixed issue with encoding for OSX keychain on macOS |
Connection | Added support for Azure MFA and ‘Sql Authentication Provider’ on Linux |
Dataverse | Addressed error generated when expanding the database node for a Dataverse database in Object Explorer |
IntelliCode extension | Fixed error that occurred when launching Azure Data Studio with Visual Studio Code IntelliCode extension installed |
PostgreSQL extension | Implemented support for exporting query results on Apple M1 from a notebook |
SQL Database Projects extension | Added Accessibility Fixes related to screen reader, label names, and improved focus when navigating |
For a full list of bug fixes addressed for the April 2023 release, visit the April 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 |
Published by erpett over 1 year ago
New Item | Details |
---|---|
ARM64 Support for macOS | Implemented native arm64 SqlToolsService support for arm64 Windows and macOS. |
Connection | Changed the icon under Linked Accounts when adding a new Azure account. |
Connection | Introduced support for the Command Timeout connection property. |
Connection | Added support for all three connection encryption options: Strict, Mandatory, and Optional. |
Connection | Introduced HostNameInCertificate connection property under Security on the Advanced tab, for server with a certificate configured. |
Connection | Added new advanced option in the Connection dialog to support Secure Enclaves. |
Connection | Introduced a new setting, Mssql Enable Sql Authentication Provider to allow connections to be maintained without the concern of losing access token lifetime or getting dropped by server. Access tokens will be refreshed internally by the SqlClient driver whenever they are found to be expired. This option is disabled by default. |
Connection | Added support for connections to Microsoft Dataverse using the TDS endpoint. |
Connection | Introduced additional error reporting for Azure connections. |
Connection | Introduced support for change password. |
Connection | Added support for encryption options for Arc SQL Managed Instance when server certificates are not installed. |
Deployment | Moved the New Deployment option from the Connections breadcrumb to the File Menu. |
Object Explorer | Introduced ability to group objects in Object Explorer by database schema. This applies to all MSSQL connections when enabled or disabled. |
Object Explorer | Introduced a new option to allow a custom timeout to be configured for Object Explorer. Within Settings, enable Mssql > Object Explorer: Expand Timeout. |
Query Results | Added option to disable special handling for JSON strings. |
New Item | Details |
---|---|
Accessibility | Updated server group color display to improve visibility and contrast. |
Backup | Addressed inability to select "Backup Set" checkbox. |
Connection | Removed refresh action for connections which are disconnected. |
Connection | Fixed issue with MSAL not properly set for connections. |
Connection | Added ability to delete a server group if no connections exist for it. |
Connection | Added connection display name to the Delete Connection dialog. |
Connection | Azure connections with "Do not save" for the server group are no longer added to the default server group list. |
Connection | Improved error handling in the connection dialog. |
Connection | Fixed issue where saved passwords were not retained for Azure SQL connections. |
Connection | Improved method to retrieve database access when connecting to Azure SQL. |
Connection | Improved connection experience for cloud users. |
Connection | Improved account and tenant selection when connecting to Azure SQL in the connection dialog. |
Deployment | Improved narration for deployment wizard. |
Installation | Updated default install location for the Windows on ARM installer. |
MySQL Extension | Addressed issue where dialog boxes in the MySQL connection pane were not editable. |
Notebooks | Fixed issue with updating the relative path in a Notebook cell. |
Notebooks | Fixed issue that caused internal notebook links to break when editing characters in the page. |
Notebooks | Addressed error thrown when opening a Notebook via a link. |
Object Explorer | Fixed issue with Object Explorer node not expanding. |
Query Editor | Fixed database dropdown list for contained users to display correctly. |
Query Editor | Addressed issue where database dropdown list was not ordered the same as in Object Explorer. |
Query Editor | Added the ability to properly escape special characters when they exist in object names. |
Query Editor | Fixed issue which caused query timer to continue to run even though execution was complete. |
Query Plan Viewer | Addressed an issue where a query plan would not render when opened via a URL. |
Query Results | Improved precision formatting for datetimeoffset data type. |
For a full list of bug fixes addressed for the March 2023 release, visit the bugs and issues list 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 |
Published by erpett over 1 year ago
New Item | Details |
---|---|
Connection | Fixed a regression blocking connections to sovereign Azure clouds |
Query Editor | Fixed a regression causing the Output window to display on each query execution |
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 |
Published by erpett over 1 year ago
New Item | Details |
---|---|
Connection | Fixed a bug causing incorrect Azure account tenant selection when connecting to server through the Azure view. https://github.com/microsoft/azuredatastudio/issues/21643 |
Object Explorer | Fixed a regression which caused Object Explorer to not show database objects for Azure SQL DB Basic SLO. https://github.com/microsoft/azuredatastudio/issues/21735 |
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 |
Published by erpett almost 2 years ago
New Item | Details |
---|---|
Azure Subscriptions | Introduced Azure Synapse Analytics and Dedicated SQL Pools nodes. |
Azure SQL Migration Extension | Premium series memory optimized SQL MI SKUs included in recommendations. |
Connection | Migrated Azure authentication library from ADAL to MSAL. MSAL is the library used by default starting with release 1.41. However, if you encounter issues, you can change back to ADAL within Settings > Azure: Authentication Library. |
Connection | Added ability to provide a description when creating a firewall rule from Azure Data Studio. |
Connection | Include ability to change password for new or expired login. |
Connection | Add support for SQL Server Alias use when connecting to a server. |
MongoDB Atlas Extension | Provides the ability to connect to and query data on MongoDB Atlas (Preview). |
Notebooks | Provide option for users to convert markdown to a table or not when HMTL table tag is present. |
Object Explorer | Databases are no longer brought online in serverless Azure SQL when Databases node is expanded. |
Object Explorer | Added support for Ledger views. |
Object Explorer | Fixed issue with key binding for objectExplorer.manage not working. |
Query Editor | Fixes and updates to SQL grammar (colorization and auto-complete). |
Query Plan Viewer | Changed default folder to be user’s home directory when saving a query plan. |
Query Results | Added ability to only copy Column Headers, and only for cells that are highlighted. |
Query Results | Added option to show or hide the action bar in the results window. |
Query Results | Increased height of horizontal scrollbar in results window. |
Query Results | Added new aggregate details in the results toolbar when selecting multiple cells. |
SQL Projects Extension | Provide the ability select an existing project via a new dropdown. |
New Item | Details |
---|---|
Accessibility | Accessibility improvements were made in the Query Plan Viewer, Query History Extension and Migration Extension. |
Big Data Cluster | Fix missing connect icon in BDC view header bar. |
Big Data Cluster | Fixed issue preventing HDFS nodes for BDC servers in Object Explorer from expanding. |
Connection | Added ability to delete a connection that has expired AAD credentials. |
Connection | Improved experience when Azure Active Directory token expiration occurs. |
Connection | Improved connection experience when using multiple Azure tenants. |
Connection | Addressed problem with adding a firewall exception for a non-default Azure subscription. |
Migration Extension | Added support for non-public clouds for migration scenarios. |
MySQL Extension | Updated resource endpoints to support AAD logins in the MySQL extension. |
Notebooks | Improve Intellisense refresh in Notebook cells. |
Notebooks | Address issue with "New Notebook Job" resulting in an empty form. |
Object Explorer | Fixed issue with database list not loading. |
Query Execution | Fixed error generated when executing a query with LEFT JOIN and NULL values. |
Query Plan Viewer | When saving query plans (.sqlplan file), the filename will numerically increment to prevent duplicate filenames. |
Query Results | Fixed issue where users were unable to open JSON data as a new file. |
Query Results | Provide proper cell selection and navigation in the query results grid. |
Query Results | Improved the handling of line breaks when copying cell contents. |
Query Results | Addressed issue where a column would re-size incorrectly when auto-sizing in the results output. |
Query Results | Improved JSON cell handling from query results. |
Query Results | Fixed behavior where focus was incorrectly set on a cell using keyboard navigation. |
Resource Deployment | Remove 'Preview' flag for SQL Server 2022 deployment types. |
Schema Compare Extension | Fixed problem where differences in schema compare were not being highlighted. |
Schema Compare Extension | Permissions are now included in schema compare when the "Include Permissions" option is selected. |
SQL Projects Extension | Changes to db_datawriter or db_datareader roles are now supported. |
SQL Projects Extension | Updated Database Projects Net Core SDK Location dialog to be more descriptive. |
Table Designer | Updated Table Designer to disable transaction support for Azure Synapse databases. |
Table Designer | Addressed problem of the table name not refreshing after being updated prior to publishing. |
Table Designer | Fixed issue where table designer could not be opened for existing Ledger tables. |
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 |
Published by kburtram almost 2 years ago
Platform | Type | Download |
---|---|---|
Windows | User Installer | 64 bit |
System Installer | 64 bit | |
.zip | 64 bit | |
Linux | .tar.gz | 64 bit |
.deb | 64 bit | |
.rpm | 64 bit | |
Mac | .zip | Universal Intel Chip Apple Silicon |
Published by Charles-Gagnon almost 2 years ago
Platform | Type | Download |
---|---|---|
Windows | User Installer | 64 bit |
System Installer | 64 bit | |
.zip | 64 bit | |
Linux | .tar.gz | 64 bit |
.deb | 64 bit | |
.rpm | 64 bit | |
Mac | .zip | Universal Intel Chip Apple Silicon |