Releases: microsoft/azuredatastudio
Releases · microsoft/azuredatastudio
April 2023 Release (version 1.43.0)
Version 1.43.0
- Release number: 1.43.0
- Release date: April 12, 2023
What's new in 1.43.0
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 |
Bug fixes in 1.43.0
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.
Known issues
For a list of the current known issues, visit the issues list on GitHub.
March 2023 Release (version 1.42.0)
Version 1.42.0
- Release number: 1.42.0
- Release date: March 22, 2023
What's new in 1.42.0
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. |
Bug fixes in 1.42.0
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.
Known issues
For a list of the current known issues, visit the issues list on GitHub.
January 2023 Release Hotfix 2 (version 1.41.2)
Version 1.41.2
- Release date: February 10, 2023
- Release status: General Availability
Bug fixes in 1.41.2
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 |
January 2023 Release Hotfix 1 (version 1.41.1)
Version 1.41.1
- Release date: January 30, 2023
- Release status: GA
Bugs fixed in 1.41.1
New Item |
Details |
Connection |
Fixed a bug causing incorrect Azure account tenant selection when connecting to server through the Azure view. #21643 |
Object Explorer |
Fixed a regression which caused Object Explorer to not show database objects for Azure SQL DB Basic SLO. #21735 |
January 2023 Release (version 1.41.0)
Version 1.41.0
- Release date: January 25, 2023
- Release status: General Availability
What's new in 1.41.0
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. |
Bug fixes in 1.41.0
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. |
November 2022 Release Hotfix 2 (version 1.40.2)
Version 1.40.2
- Release date: December 27, 2022
- Release status: General Availability
Bug fixes in 1.40.2
- Fix potential elevation of privilege issue using Bash shell on Windows. VS Code issue #160827
November 2022 Release Hotfix 1 (version 1.40.1)
Version 1.40.1
- Release date: November 22, 2022
- Release status: General Availability
What's new in 1.40.1
- Bug fixes in 1.40.1
- Fixed bug that caused folders in the servers tree to display incorrect contents (#21245)
November 2022 Release (version 1.40.0)
Version 1.40.0
- Release date: November 16, 2022
- Release status: General Availability
What's new in 1.40.0
New Item |
Details |
Connections |
Connections for SQL now default to Encrypt = 'True'. |
ARM64 Support for macOS |
ARM64 build for macOS is now available. |
Table Designer |
Announcing the General Availability of the Table Designer. |
Table Designer |
Period columns now added by default when System-Versioning table option is selected. |
Table Designer |
Added support for hash indexes for In-Memory tables, and added support for columnstore indexes. |
Table Designer |
New checkbox added, "Preview Database Updates", when making database changes to ensure that users are aware of potential risks prior to updating the database. |
Table Designer |
"Move Up" and "Move Down" buttons added to support column reordering for Primary Keys. |
Query Plan Viewer |
Announcing the General Availability of the Query Plan Viewer in Azure Data Studio. |
Query Plan Viewer |
Added support for identification of most expensive operator(s) in a plan. |
Query Plan Viewer |
Updates were made to the properties window to allow for full display of text upon hovering over a cell. Full text can also be copied. |
Query Plan Viewer |
Implemented filter functionality in the Properties pane for an execution plan. |
Query Plan Viewer |
Added support for collapsing and expanding all subcategories within the Plan Comparison Properties window. |
Query History Extension |
Announcing the General Availability of the SQL History Extension. |
Query History Extension |
Now includes ability to persist history across multiple user sessions. |
Query History Extension |
Added the ability to limit the number of entries stored in the history. |
Schema Compare |
Users can now open .scmp files directly from the context menu for existing files in the file explorer. |
Query Editor |
Now allows full display for text strings larger than 65,535 characters. |
Query Editor |
Added support for the SHIFT key when making multiple cell selections. |
MySQL Extension |
Support for MySQL extension is now available in preview. |
Azure SQL Migration Extension |
Azure SQL Database Offline Migrations is now available in preview. Customers can use this new capability to save and share reports as needed. |
Azure SQL Migration Extension |
Addition of elastic Azure recommendations model. |
Database Migration Assessment for Oracle |
Assessment tooling for Oracle database migrations to Azure Database for PostgreSQL and Azure SQL available in preview. |
VS Code merge |
VS Code merges to version 1.67. Read their release notes to learn more. |
SQL Database Projects |
Adds SQL projects support for syntax introduced in SQL Server 2022. |
Bug fixes in 1.40.0
New Item |
Details |
Connections |
Fixed bug that occurred when trying to connect to the Dedicated Admin Connection (DAC) on SQL Server. |
Connections |
Fixed issue with wrong tenant showing up while trying to connect to a database with Azure Active Directory login. |
Connections |
Fixed zoom reset behavior when adding a new connection. |
Connections |
Fixed loading bug what occurred when attempting to sign in to Azure via proxy. |
Connections |
Fixed issue encountered while attempting to connect to a "sleeping" Azure SQL Database. |
Object Explorer |
Fixed the SELECT script generation issue for Synapse Databases. |
Schema Compare |
Fixed error that caused duplication of comment headers when applying schema changes on stored procedure objects. |
Schema Compare |
Fixed issue that prevented schema compare issues when creating a new empty schema with a "DOMAIN\User" pattern. |
Query Editor |
Fixed bug that caused results to be lost upon saving query files. |
Table Designer |
Fixed a bug that caused creation of a new table when renaming an existing table. |
Query Plan Viewer |
Fixed missing index recommendation T-SQL syntax. |
SQL Projects |
Fixed bug in SQL Projects that led to extension not using output path when publishing a project. |
SQL Projects |
Fixed bug that caused .NET install to not be found when using the SQL Projects extension on Linux platforms. |
August 2022 Release Hotfix 1 (version 1.39.1)
Version 1.39.1
- Release date: August 30, 2022
- Release status: General Availability
What's new in 1.39.1
- Bug fixes in 1.39.1
- Fixed bug that caused Database Trees in server connections to not expand in the Object Explorer.
August 2022 Release (version 1.39.0)
Version 1.39.0
- Release date: August 24, 2022
- Release status: General Availability
What's new in 1.39.0
New Item |
Details |
Deployment Wizard |
Azure Data Studio now supports SQL Server 2022 (Preview) in the Deployment Wizard for both local and container installation. |
Object Explorer |
Added Ledger icons and scripting support to Object Explorer for Ledger objects. |
Dashboard |
Added hexadecimal values to support color detection. |
Query Plan Viewer |
Added the ability to copy text from cells in the Properties Pane of a query plan. |
Query Plan Viewer |
Introduced a "find node" option in plan comparison to search for nodes in either the original or added plan. |
Table Designer |
Now supports the ability to add included columns to a nonclustered index, and the ability to create filtered indexes. |
SQL Projects |
Publish options were added to the Publish Dialog. |
Query History Extension |
Added double-click support for query history to either open the query or immediately execute it, based on user configuration. |
Bug fixes in 1.39.0
New Item |
Details |
Dashboard |
Fixed an accessibility issue that prevented users from being able to access tooltip information using the keyboard. |
Voiceover |
Fixed a bug that caused voiceover errors across the Dashboard, SQL Projects, SQL Import Wizard, and SQL Migration extensions. |
Schema Compare |
Fixed a bug that caused the UI to jump back to the top of the options list after selecting/deselecting any option. |
Schema Compare |
Fixed a bug involving Schema Compare (.SCMP) file incompatibility with Database Project information causing errors when reading and using information stored in this file type. |
Object Explorer |
Fixed a bug that caused menu items in Object Explorer not to show up for non-English languages. |
Table Designer |
Fixed a bug that caused the History Table name not to be consistent with the current table name when working with System-Versioned Tables. |
Table Designer |
Fixed a bug in the Primary Key settings that caused the "Allow Nulls" option to be checked, but disabled, preventing users from changing this option. |
Query Editor |
Fixed a bug that prevented the SQLCMD in T-SQL from working correctly, giving false errors when running scripts in Azure Data Studio. |
Query Editor |
Fixed a bug that caused user-specified zoom settings to reset to default when selecting JSON values after query that returned JSON dataset was ran. |
SQL Projects |
Fixed a bug that caused the "Generate Script" command to not work correctly when targeting a new Azure SQL Database. |
Notebooks |
Fixed a bug that caused pasted images to disappear from editor after going out of edit mode. |
Notebooks |
Fixed a bug that caused a console error message to appear after opening a markdown file. |
Notebooks |
Fixed a bug that prevented markdown cell toolbar shortcuts from working after creating a new split view cell. |
Notebooks |
Fixed a bug that caused text cells to be erroneously created in split view mode when the notebook default text edit mode was set to "Markdown". |