Release notes for Azure Data Studio
This article provides details about updates, improvements, and bug fixes for the current and previous versions of Azure Data Studio.
Current Azure Data Studio release
Download and install the latest release!
May 2022 (hotfix)
Azure Data Studio 1.36.2 is the latest general availability (GA) release.
- Release number: 1.36.2
- Release date: May 20, 2022
Bug fixes in 1.36.2
| New Item | Details |
|---|---|
| Query Plan Viewer | Fixed issue with execution plan zoom and operator icons. |
| Query Plan Viewer | Updated parallelism icon direction. |
Azure Data Studio feedback
You can reference Azure Data Studio feedback for other known issues and to provide feedback to the product team.
Previous Azure Data Studio releases and updates
| Azure Data Studio release | Build number | Release date | Hotfix |
|---|---|---|---|
| April 2022 | 1.36.0 | April 20, 2022 | hotfix |
| February 2022 | 1.35.0 | February 24, 2022 | hotfix |
| December 2021 | 1.34.0 | December 15, 2021 | N/A |
| October 2021 | 1.33.0 | October 27, 2021 | N/A |
| August 2021 | 1.32.0 | August 18, 2021 | N/A |
| July 2021 | 1.31.0 | July 21, 2021 | N/A |
| June 2021 | 1.30.0 | June 17, 2021 | N/A |
| May 2021 | 1.29.0 | May 19, 2021 | N/A |
| April 2021 | 1.28.0 | April 15, 2021 | N/A |
| March 2021 | 1.27.0 | March 17, 2021 | N/A |
| February 2021 | 1.26.0 | February 18, 2021 | N/A |
| December 2020 | 1.27.0 | December 9, 2020 | hotfix |
| November 2020 | 1.24.0 | November 12, 2020 | N/A |
| October 2020 | 1.23.0 | October 14, 2020 | N/A |
| September 2020 | 1.22.0 | September 22, 2020 | hotfix |
| August 2020 | 1.21.0 | August 12, 2020 | N/A |
| July 2020 | 1.20.0 | July 15, 2020 | hotfix |
| June 2020 | 1.19.0 | June 15, 2020 | N/A |
| May 2020 | 1.18.0 | May 20, 2020 | hotfix |
| April 2020 | 1.17.0 | April 27, 2020 | hotfix |
| March 2020 | 1.16.0 | March 18, 2020 | N/A |
| February 2020 | 1.15.0 | February 13, 2020 | hotfix |
| December 2019 | 1.14.0 | December 19, 2019 | hotfix |
| November 2019 | 1.13.0 | November 4, 2019 | hotfix |
| October 2019 | 1.12.0 | October 2, 2019 | hotfix 1 hotfix 2 |
| September 2019 | 1.11.0 | September 10, 2019 | N/A |
| August 2019 | 1.10.0 | August 15, 2019 | N/A |
| July 2019 | 1.9.0 | July 11, 2019 | N/A |
| June 2019 | 1.8.0 | June 6, 2019 | N/A |
| May 2019 | 1.7.0 | May 8, 2019 | N/A |
| April 2019 | 1.6.0 | April 18, 2019 | N/A |
| March 2019 | 1.5.1 | March 18, 2019 | hotfix |
| February 2019 | 1.4.5 | February 13, 2019 | N/A |
| January 2019 | 1.3.8 | January 09, 2019 | hotfix |
Download the previous release of Azure Data Studio.
Note
All previous versions of Azure Data Studio are not supported.
April 2022 (hotfix)
Azure Data Studio 1.36.1 is the latest general availability (GA) release.
- Release number: 1.36.1
- Release date: April 22, 2022
Bug fixes in 1.36.1
| New Item | Details |
|---|---|
| Table Designer | Fix for timeout occurring when viewing table list |
April 2022
- Release number: 1.36.0
- Release date: April 20, 2022
What's new in 1.36.0
| New item | Details |
|---|---|
| Table Designer | Added support for System Versioning, Memory Optimized, and Graph Tables. |
| Query Plan Viewer | Added support icons and additional support for searching within plans. Added additional telemetry to Execution Plans. Provided support on plan toolbar to enable or disable tooltips. Added support for saving .sql plan files on Azure Data Studio |
| SQL Projects | Introduced new SQL Project format based on an SDK-Style project file |
| Azure SQL Migration Extension | Announcing General Availability of the Azure SQL Migration Extension |
| .NET Interactive Notebooks extension | This extension provides additional multi-language support to Jupyter Notebooks. Please reference .NET Notebooks in Visual Studio Codefor an introduction to using SQL and .NET interactive |
Bug fixes in 1.36.0
| New Item | Details |
|---|---|
| Table Designer | Added missing validation rules for primary key column specifications |
| Table Designer | Now able to add description to Primary Key ,Foreign Key, and check constraints |
| Table Designer | Fixed bug that prevents the primary key checkbox from being unchecked for unsupported primary key types |
| Query Plan Viewer | Added option to turn off tooltip in execution plan |
| Query Plan Viewer | Fixed display and sizing issues |
| Query Plan Viewer | Fixed latency issues while switching tabs when execution plan is shown |
| Query Editor | Fixed performance issues in Query Editor |
| Notebooks | Fixed keyboard navigation issues |
| Notebooks | Fixed .NET Interactive log errors on startup |
| Notebooks | Fixed inconsistencies with notebook URI handling |
For a full list of bug fixes addressed for the April 2022 release, visit the bugs and issues list on GitHub.
Known issues in 1.36.0
For a list of the current known issues, visit the issues list on GitHub.
February 2022 (hotfix)
- Release number: 1.35.1
- Release date: March 17, 2022
Bug fixes in 1.35.1
| New Item | Details |
|---|---|
| Query Editor | Geometry Data Type Returned as Unknown Charset in Results Grid |
| Query Editor | Excel number format |
February 2022
- Release number: 1.35.0
- Release date: February 24, 2022
What's new in 1.35.0
| New item | Details |
|---|---|
| Table Designer | Added functionality for creation and management of tables for SQL Servers. Built using DacFx framework |
| Query Plan Viewer | Added functionality for users to view a graphic view of estimated and actual query plans without need for an extension |
| Azure Arc Extension | Updated the Data Controller deployment wizard and the SQL Managed Instance - Azure Arc deployment wizard to reflect the deployment experience in Azure Portal |
Bug fixes in 1.35.0
| New Item | Details |
|---|---|
| Azure Arc Extension | SQL Managed Instance-Azure Arc is now fixed for both indirect connectivity mode and direct connectivity mode |
| Notebooks | Support for keyboard navigation between cells to minimize mouse clicking |
For a full list of bug fixes addressed for the February 2022 release, visit the bugs and issues list on GitHub.
Known issues in 1.35.0
For a list of the current known issues, visit the issues list on GitHub.
December 2021
- Release number: 1.34.0
- Release date: December 15, 2021
What's new in 1.34.0
| New item | Details |
|---|---|
| SQL Migration extension | Added 'Currently restoring backup file' in the migration progress details page of Azure SQL migration extension when backup files location is Azure Storage blob container |
| Notebooks | Added undo/redo support |
| SQL Database Projects extension | Support for project build with .NET 6 in SQL Database Projects extension |
| SQL Database Projects extension | Publish to container in SQL Database Projects extension |
| Extension update | SQL Database Projects |
| Extension update | Lang packs |
| Extension update | Azure SQL Migration |
Bug fixes in 1.34.0
| New Item | Details |
|---|---|
| SQL Migration | Fix for multiple database migrations when using network share as backup files location in Azure SQL migration extension |
| SQL Migration | Fix for multiple database migrations when using blob storage containers as backup files location in Azure SQL migration extension |
| SQL Migration | Fix to pre-populate target database names in the migration wizard in Azure SQL migration extension |
| Grid | Fix to column sorting in grids where the presence of null values could lead to unexpected results |
| Notebooks | Fix for Python upgrades when two or more notebooks were open |
October 2021
- Release number: 1.33.0
- Release date: October 27, 2021
What's new in 1.33.0
| New item | Details |
|---|---|
| Notebooks | Added Notebook Views support |
| Notebooks | Added split cell support |
| Notebooks | Added keyboard shortcuts for Markdown Toolbar cells |
| Notebooks | Large performance improvement for large notebooks • Ctrl/Cmd + B = Bold Text • Ctrl/Cmd + I = Italicize Text • Ctrl/Cmd + U = Underline Text • Ctrl/Cmd + Shift + K = Add Code Block • Ctrl/Cmd + Shift + H = Highlight Text |
| Notebooks | Added Book improvements • Add a new section • Drag and Drop |
| Extension update | Azure Monitor Logs |
| Extension update | Schema Compare |
| Extension update | SQL Database Projects |
| Extension update | Machine Learning |
| Extension update | Profiler |
| Extension update | Import |
| Extension update | Kusto |
| Extension update | Dacpac |
| Extension update | Lang packs |
| Extension update | Azure SQL Migration |
| Extension update | CMS |
| Extension update | Kusto |
Bug fixes in 1.33.0
| New Item | Details |
|---|---|
| Notebook | Fixed Notebook linking |
| Notebook | Fixed horizontal scrollbar (when word wrap is off in MD Splitview / MD mode) in Notebooks |
| Notebook | Fixed vertical scrollbar for MD Splitview in Notebooks |
For a full list of bug fixes addressed for the August 2021 release, visit the bugs and issues list on GitHub.
Known issues in 1.33.0
For a list of the current known issues, visit the issues list on GitHub.
August 2021
- Release number: 1.32.0
- Release date: August 18, 2021
What's new in 1.32.0
| New item | Details |
|---|---|
| Notebooks | Large performance improvement for large notebooks |
| Extension (new) | Azure Monitor Logs |
| Extension update | SchemaCompare |
| Extension update | SQLDatabaseProjects |
| Extension update | MachineLearning |
| Extension update | Azure Arc |
| Extension update | Lang packs |
Bug fixes in 1.32.0
| New Item | Details |
|---|---|
| Database Projects | Fixed Seeing "Project already opened" message for every project I open or create |
| Schema Compare | Fixed Schema compare subsequent results after once are not loading in view |
| Lang packs | Fixed Localization for previously untranslated extensions. |
| Machine Learning | Fixed Machine Learning - View models dialog is broken |
For a full list of bug fixes addressed for the August 2021 release, visit the bugs and issues list on GitHub.
Known issues in 1.32.0
For a list of the current known issues, visit the issues list on GitHub.
July Hotfix 2021
- Release number: 1.31.1
- Release date: July 29, 2021
Bug fixes in 1.31.1
| New Item | Details |
|---|---|
| Connections | Fixed Database connection toolbar missing for sql scripts |
| Connections | Fixed Connection dropped / is not maintained when saving / opening scripts |
| Connections | Script file opened from command line does not allow DB connection |
For a full list of bug fixes addressed for the July Hotfix 2021 release, visit the bugs and issues list on GitHub.
Known issues in 1.31.1
For a list of the current known issues, visit the issues list on GitHub.
July 2021
- Release number: 1.31.0
- Release date: July 21, 2021
What's new in 1.31.0
| New item | Details |
|---|---|
| Notebooks | WYSIWYG link improvements |
| Extension update | SchemaCompare |
| Extension update | SQLDatabaseProjects |
Bug fixes in 1.31.0
| New Item | Details |
|---|---|
| Import Wizard | Fixed Import extension next button does not work in July release |
| Schema Compare | Fixed issue that Schema compare Select Source target dialog OK button not enabled |
| Notebooks | Fixed Export Notebook as SQL file has no query editor toolbar |
| SQL Server Big Data Clusters | Fixed Can't connect to BDC Clusters |
| Accessibility bug fixes |
For a full list of bug fixes addressed for the July 2021 release, visit the bugs and issues list on GitHub.
Known issues in 1.31.0
For a list of the current known issues, visit the issues list on GitHub.
June 2021
- Release number: 1.30.0
- Release date: June 17, 2021
What's new in 1.30.0
| New item | Details |
|---|---|
| Results Grid | Added filtering/sorting feature for query result grid in query editor and notebook, the feature can be invoked from the column headers. note that this feature is only available when you enable the preview features. |
| Results Grid | Added a status bar item to show summary of the selected cells if there are multiple numeric values |
| Notebooks | Added new book icon |
| Notebooks | Notebook URI Handler File Support |
| Python | Updated Python to 3.8.10 |
Bug fixes in 1.30.0
| New Item | Details |
|---|---|
| Notebooks | Fixed WYWIWYG Table cell adding new line in table cell |
| Notebooks | Fixed issue that Kusto notebook does not change kernels properly |
For a full list of bug fixes addressed for the May 2021 release, visit the bugs and issues list on GitHub.
Known issues in 1.30.0
For a list of the current known issues, visit the issues list on GitHub.
May 2021
- Release number: 1.29.0
- Release date: May 19, 2021
What's new in 1.29.0
| New item | Details |
|---|---|
| Notebooks | Added run with parameters action. Learn more here |
Bug fixes in 1.29.0
| New Item | Details |
|---|---|
| Database | Fixed an issue with the title not changing when the database connection changes. |
| Extensions | Fixed an issue with no longer prompting the user to install 3rd party extensions. |
| General Azure Data Studio | Fixed an issue with the account button in the sidebar getting stuck loading. |
| General Azure Data Studio | Fixed an issue with the Run With Parameters silently failing if the parameters cell is empty or invalid. |
| General Azure Data Studio | Fixed an issue with the Run With Parameters not handling multiple parameters on the same line. |
| General Azure Data Studio | Fixed an issue with being unable to connect to Azure. |
| General Azure Data Studio | Fixed an issue with the wrong line number showing up in the output. |
| General Azure Data Studio | Fixed an issue when receiving an error when connecting to an Azure server in the Azure viewlet. |
| General Azure Data Studio | Fixed an issue with the loading spinner not being animated. |
| General Azure Data Studio | Fixed an issue with the links inserted in the split view/MD view not being inserted as a list item. |
| General Azure Data Studio | Fixed an issue with the Issue Reporter being blank. |
| Extensions | Fixed an issue with the extensions view having many filter options that aren't applicable to Azure Data Studio. |
| General Azure Data Studio | Fixed an issue with getting the Azure subscriptions API failing across Azure Data Studio. |
| General Azure Data Studio | Fixed an issue with the wrong event prefix. |
| General Azure Data Studio | Fixed an issue with converting the default tables from Excel, Word, and OneNote into markdown tables. |
| Notebooks | Fixed an issue with selecting notebooks from the notebooks viewlet recentering the viewlet vertically. |
| Notebooks | Fixed an issue with not connecting to SQL Server from SQL Notebook. |
| Notebooks | Fixed an issue with the notebook icons being sized incorrectly. |
| PowerShell | Fixed an issue with using the Cloud Shell (PowerShell). |
| SQL Database Project | Fixed an issue with showing an unnecessary horizontal scrollbar in the create project from database dialog SQL Database Project dashboard update. |
For a full list of bug fixes addressed for the May 2021 release, visit the bugs and issues list on GitHub.
Known issues in 1.29.0
For a list of the current known issues, visit the issues list on GitHub.
April 2021
April 15, 2021 / version: 1.28.0
What's new in 1.28.0
| New item | Details |
|---|---|
| Extension update | Kusto (KQL) |
| Extension update | MachineLearning |
| Extension update | SchemaCompare |
| Extension update | SQLDatabaseProjects |
| Notebook features | Added Add Notebook and Remove Notebook commands |
Bug fixes in 1.28.0
For the list of the bug fixes addressed for the April 2021 release, visit the bugs and issues list on GitHub.
Known issues in 1.28.0
For the list of known issues, visit the issues list on GitHub.
March 2021
March 17, 2021 / version: 1.27.0
| Change | Details |
|---|---|
| Bug Fixes | For a complete list of fixes, see Bugs and issues on GitHub. |
| Extension(s) update | Dacpac SQLDatabaseProjects |
| New Notebook features | Added create book dialog |
February 2021
February 18, 2021 / version: 1.26.0
| Change | Details |
|---|---|
| Bug Fixes | For a complete list of fixes see Bugs and issues on GitHub. |
| Extension(s) update | Dacpac Kusto (KQL) MachineLearning Profiler SchemaCompare SQLDatabaseProjects |
| New Azure Arc features | Multiple data controllers now supported New connection dialog options like the kube config file Postgres dashboard enhancements |
| New Notebook features | Improved Jupyter server start-up time by 50% on Windows Added support to edit Jupyter Books through right-click Added URI notebook parameterization support and added notebook parameterization documentation |
December 2020 (hotfix)
February 10, 2021 / version: 1.25.3
| Change | Details |
|---|---|
| Fix bug #13899 | Scrolling to the appropriate cross-reference links in Notebooks |
| Upgrade Electron to incorporate important bug fixes | N/A |
December 2020
December 9, 2020 / version: 1.25.0
| Change | Details |
|---|---|
| Bug Fixes | For a complete list of fixes see Bugs and issues on GitHub. |
| Database Projects extension update | Added workspaces and improved sidebar |
November 2020
November 12, 2020 / version: 1.24.0
| Change | Details |
|---|---|
| Bug Fixes | For a complete list of fixes see Bugs and issues on GitHub. |
| Connection dialog | Added new browse tab for connection dialog. |
| Extension(s) update | Released update to Postgres extension. |
| New notebook features | Added new features to SQL to notebook support. Added new features to Notebook parameterization support. Added new features to results streaming for SQL Notebooks. |
| Python installation | PROSE package has been removed from default Python installation. |
Known issues (1.24.0)
| New Item | Details | Workaround |
|---|---|---|
| Azure Arc extension | Known Issue: The "Script to Notebook" button for Arc MIAA & PG deployments doesn't do field validation before scripting the notebook. This means that if users enter the password wrong in the password confirm inputs then they may end up with a notebook that has the wrong value for the password. | The "Deploy" button works as expected though so users should use that instead. |
| Object Explorer | Releases of Azure Data Studio before 1.24.0 have a breaking change in object explorer because of the engine's changes related to Azure Synapse Analytics serverless SQL pool. | To continue utilizing object explorer in Azure Data Studio with Azure Synapse Analytics serverless SQL pool, you need to use Azure Data Studio 1.24.0 or later. |
You can reference Azure Data Studio feedback for other known issues and to provide feedback to the product team.
October 2020
October 14, 2020 / version: 1.23.0
| Change | Details |
|---|---|
| Azure SQL Edge | Support for Azure SQL Edge objects. |
| Bug Fixes | For a complete list of fixes see Bugs and issues on GitHub. |
| Databases | Support for same database reference. |
| Extension updates | Azure Arc azdataMachine Learning Kusto (KQL)Schema Compare SQL AssessmentSQL Database Projects SQL Server Import |
| New deployment features | Added Azure SQL DB and VM deployments. |
| PowerShell | Added PowerShell kernel results streaming support. |
September 2020 (hotfix)
September 30, 2020 / version: 1.22.1
| Change | Details |
|---|---|
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues on GitHub. |
September 2020
September 22, 2020 / version: 1.22.0
| Change | Details |
|---|---|
| New notebook features | • Supports brand new text cell editing experience based on rich text formatting and seamless conversion to markdown, also known as WYSIWYG toolbar (What You See Is What You Get) • Supports Kusto kernel • Supports pinning of notebooks • Added support for new version of Jupyter Books • Improved Jupyter Shortcuts • Introduced perf loading improvements |
| SQL Database Projects extension | The SQL Database Projects extension brings project-based database development to Azure Data Studio. In this preview release, SQL projects can be created and published from Azure Data Studio. |
| Kusto (KQL) extension | Brings native Kusto experiences in Azure Data Studio for data exploration and data analytics against massive amount of real-time streaming data stored in Azure Data Explorer. This preview release supports connecting and browsing Azure Data Explorer clusters, writing KQL queries and authoring notebooks with Kusto kernel. |
| Azure Arc extension | Users can try out Azure Arc public preview through Azure Data Studio. This includes: • Deploy data controller • Deploy Postgres • Deploy Managed Instance for Azure Arc • Connect to data controller • Access data service dashboards • Azure Arc Jupyter Book |
| Deployment options | • Azure SQL Database Edge (Edge will require Azure SQL Edge Deployment Extension) |
| SQL Server Import extension GA | Announcing the GA of the SQL Server Import extension, features no longer in preview. This extension facilitates importing csv/txt files. Learn more about the extension in this article. |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
August 2020
August 12, 2020 / version: 1.21.0
| Change | Details |
|---|---|
| New notebook features | • Move cell locations • Convert cells to Text Cell or Code cell |
| Jupyter Books picker | Users can now choose Jupyter Books from GitHub releases and open seamlessly in Azure Data Studio |
| Search added to Notebooks Viewlet | Users can easily search through content across their notebooks and Jupyter Books |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
July 2020 (hotfix)
July 17, 2020 / version: 1.20.1
| Change | Details |
|---|---|
| Fix bug #11372 Object Explorer drag-and-drop table incorrectly wraps table names | #11372 |
| Fix bug #11356 Dark theme is now the default theme | #11356 |
Known Issue
- Some users have reported connection errors from the new Microsoft.Data.SqlClient v2.0.0 included in this release. Users have found following these instructions to successfully connect
July 2020
July 15, 2020 / version: 1.20.0
| Change | Details |
|---|---|
| Added new Feature Tour | From welcome page and command palette, users can now launch a feature tour to get a walkthrough of commonly used features including Connections Viewlet, Notebooks viewlet, and Extensions Marketplace |
| New notebook features | • Header support in Markdown Toolbar • Side-by-side Markdown Preview in Text Cells |
| Drag and Drop Columns and Tables in Query Editor | Users can now directly drag and drop columns and tables from connections viewlet to query editor |
| Added Azure Account icon to Activity Bar | Users can now easily see where to sign in to Azure |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
June 2020
June 15, 2020 / version: 1.19.0
| Change | Details |
|---|---|
| Added Azure Data Studio to Azure portal Integration | Users can now directly launch to Azure portal from an Azure SQL Database connection, Azure Postgres, and more. |
| New notebook features | • New Notebook toolbar • New Edit Cell toolbar • Python dependencies wizard UX updates • Improved spacing across notebooks |
| Announcing SQL Assessment API extension | This extension adds SQL Server best-practice assessment in Azure Data Studio. It exposes SQL Assessment API, which was previously available for use in PowerShell SqlServer module and SMO only, to let you evaluate your SQL Server instances and receive for them recommendations by SQL Server Team. Learn more about SQL Assessment API and what it's capable of in this article. |
| Machine Learning Extension improvements | Now supports Azure SQL Managed Instance. |
| Data Virtualization extension improvements | Now supports MongoDB and Teradata |
| Postgres extension bug fixes | Fixed Azure MFA |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
May 2020 (hotfix)
May 27, 2020 / version: 1.18.1
| Change | Details |
|---|---|
| Fix bug #10538 "Run Current Query" keybind no longer behaving as expected | #10538 |
| Fix bug #10537 Unable to open new or existing sql files on v1.18 | #10537 |
May 2020
May 20, 2020 / version: 1.18.0
| Change | Details |
|---|---|
| Announcing Redgate SQL Prompt extension | This extension lets you manage formatting styles directly within Azure Data Studio, so you can create and edit your styles without leaving the IDE. |
| Announcing Machine Learning Extension | This extension enables you to: • Manage Python and R packages with SQL Server machine learning services with Azure Data Studio. • Use ONNX model to make predictions in Azure SQL Edge. • View ONNX models in an Azure SQL Edge database. • Import ONNX models from a file or Azure Machine Learning into Azure SQL Edge database. • Create a notebook to run experiments. |
| New notebook features | • Added new Python Dependencies Wizard to make it easier to install Python dependencies • Added underline support for Markdown Toolbar |
| Parameterization for Always Encrypted | Allows you to run queries that insert, update, or filter by encrypted database columns. |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
April 2020 (hotfix)
April 30, 2020 / version: 1.17.1
| Change | Details |
|---|---|
| Fix bug #10197 Can't connect via MFA | #10197 |
April 2020
April 27, 2020 / version: 1.17.0
| Change | Details |
|---|---|
| Improved welcome page | UI update on the welcome page to make it easier to see common actions and highlighting extensions. |
| New notebook features | • Added Markdown toolbar when editing text cells to help write with Markdown • Revamped Jupyter Books viewlet to become a Notebooks viewlet where you can manage Jupyter Books and notebooks together • Added support for persisting charts when saving a notebook • Added support for KQL magic in Python notebooks |
| Improved dashboards | Dashboards throughout Azure Data Studio have been updated with latest design patterns, including an actions toolbar. This also applies to many extensions. |
| Added Cloud Shell integration in the Azure view. | |
| Support for Always Encrypted and Always Encrypted with secure enclaves. | |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
March 2020
March 18, 2020 / version: 1.16.0
| Change | Details |
|---|---|
| Added charting support in SQL Notebooks | When running a SQL query in a code cell, users can now create and save charts. |
| Added Create Jupyter Book experience | Users can now create their own Jupyter Books using a notebook. |
| Added Azure AD support for Postgres extension | |
| Fixed many accessibility bugs | List of accessibility bugs |
| VS Code merges to 1.42 | This release includes updates to VS Code from the 3 previous VS Code releases. Read their release notes to learn more. |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
February (hotfix)
February 19, 2020 / version: 1.15.1
| Change | Details |
|---|---|
| Fix bug #9149 Show active connections | #9149 |
| Fix bug #9061 Edit Data grid doesn't properly resize when showing or hiding SQL Pane | #9061 |
February 2020
February 13, 2020 / version: 1.15.0
| Change | Details |
|---|---|
| New Azure Sign-in improvement | Added improved Azure Sign-in experience, including removal of copy/paste of device code to make a more seamless connected experience. |
| Find in Notebook support | Users can now use Ctrl+F in a notebook. Find in Notebook support searches line by line through both code and text cells. |
| VS Code merges from 1.38 to 1.42 | This release includes updates to VS Code from the 3 previous VS Code releases. Read their release notes to learn more. |
| Fix for the "white/blank screen" issue reported by many users. | |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
Known Issue
- Users on macOS Catalina will need to right-click Azure Data Studio and then click open.
December 2019 (hotfix)
December 26, 2019 / version: 1.14.1
| Change | Details |
|---|---|
| Fix bug #8747 OE Expansion fails | #8747 |
December 2019
December 19, 2019 / version: 1.14.0
| Change | Details |
|---|---|
| Changed attach to connection dropdown in Notebooks to only list the currently active connection | #8129 |
| Added bigdatacluster.ignoreSslVerification setting to allow ignoring TLS/SSL verification errors when connecting to a BDC | #8582 |
| Allow changing default language flavor for offline query editors | #8419 |
| GA status for Big Data Cluster/SQL 2019 features | #8269 |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
November 2019 (hotfix)
November 15, 2019 / version: 1.13.1
| Change | Details |
|---|---|
| Fix bug #8210 Copy/Paste results are out of order | |
November 2019
November 4, 2019 / version: 1.13.0
| Change | Details |
|---|---|
| New SQL Server 2019 support | • Deploy SQL Server 2019 big data cluster with BDC Deploy wizard • Manage cluster health with controller dashboard • Manage HDFS access control lists using Security ACLs Dialog • Add mounts using HDFS Tiering Dialog • Troubleshoot using built-in Jupyter Book, SQL Server 2019 guide • Renamed to SQL vNext extension Data virtualization extension • Added Teradata and Mongo support in External Table Wizard |
| New notebook features | • Announcing PowerShell notebooks • Announcing collapsible code cells • Perf improvements in Notebooks • View the full list of improvements here |
| Announcing Jupyter Books | Jupyter Books are a collection of notebooks and markdown files organized in a table of contents. |
| New SQL Server Deploy wizard | Now includes support for deploying: • SQL Server 2019 on Windows • SQL Server 2017 on Windows • SQL Server 2019 on Docker • SQL Server 2017 on Docker |
| Announcing GA of Schema Compare extension | • SQLCMD mode • Localization support • Accessibility fixes • Security bugs |
| Announcing GA of SQL Server Dacpac extension | • Localization support • Accessibility fixes • Security bugs |
| Announcing Visual Studio IntelliCode extension | Visual Studio IntelliCode now supports SQL, which allows for smarter suggestions of reserved keywords. |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
October 2019 (hotfix 2)
October 11, 2019 / version: 1.12.2
| Change | Details |
|---|---|
| Disable automatically starting the EH in inspect mode | |
October 2019 (hotfix)
October 8, 2019 / version: 1.12.1
| Change | Details |
|---|---|
| Fixed issue for quotes and backslashes in Notebooks to escape correctly. | |
October 2019
October 2, 2019 / version: 1.12.0
| Change | Details |
|---|---|
| Release of Query History extension | The SQL History extension saves all past queries executed in an Azure Data Studio session and lists them in execution order. Users can see open the query, execute the query, delete the query, pause query history, or delete all query history entries. |
| New Copy/Paste Results | We have added more ways to copy/paste results from the results grid. |
| Update to PowerShell extension | |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
Known Issues
- Notebooks
- 7080 Rare Case when Notebook is Serialized Incorrectly
September 2019
September 10, 2019 / version: 1.11.0
| Change | Details |
|---|---|
| Enable SQLCMD Mode | Query editor now supports toggling of SQLCMD mode to write and edit queries as SQLCMD scripts |
| Community Extension: Query Editor Boost | Query Editor Boost is an open-source extension focused on enhancing the Azure Data Studio query editor for users who are frequently writing queries. • Save the current query as a snippet • Switch databases using Ctrl+U • New Query from template • View the full list of improvements here |
| Notebook Improvements | • Performance improvements for supporting larger notebook files • View the full list of improvements here |
| Visual Studio Code August Release Merge 1.38 | Latest improvements can be found here. |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
Known Issues
- Notebooks
- 7080 Rare Case when Notebook is Serialized Incorrectly
August 2019
August 15, 2019 / version: 1.10.0
| Change | Details |
|---|---|
| Release of SandDance 1.3.1 extension | • Smart chart detection • 3D Visualizations • Data filtering |
| Notebook Improvements | • Add code or text cell in-line • Added ability to right-click SQL results grid to save result as CSV, JSON, etc. • Improvement to notebook loading performance for loading JSON faster • View the full list of improvements here |
| SQL Server 2019 Support | This release includes support for extra SQL Server 2019 Big Data Cluster features including: • Reduced time taken to load table and column information on the object-mapping page. • Fixed a bug with loading existing database scoped credentials on the connection details page. • Increased default sample size used for PROSE parsing. |
| Dacpac extension now supports Azure AD | |
| Visual Studio Code July Release Merge 1.37 | Latest improvements can be found here. |
| Resolved bugs and issues | For a complete list of fixes see Bugs and issues, on GitHub. |
July 2019
July 11, 2019 / version: 1.9.0
| Change | Details |
|---|---|
| Release of SentryOne Plan Explorer extension | Our valued Microsoft partner, SentryOne, will be shipping their SentryOne Plan Explorer extension for Azure Data Studio. This is a free extension, which provides enhanced plan diagrams for queries run in Azure Data Studio, with optimized layout algorithms and intuitive color-coding to help quickly identify the most expensive operators affecting query performance. To learn more about the extension, check out SentryOne's blog post here. |
| New Features coming to Schema Compare | • Schema Compare File Support (.SCMP) • Cancel Schema Compare Support • Complete changes can be found here |
| Notebook Improvements | • Plotly Python Support • Open Notebook from Browser • Python Package Management Dialog • Performance and Markdown Enhancements • Keyboard Shortcuts Update • Bug Fixes and Minor Features can be found here |
| SQL Server 2019 Support | This release includes support for extra SQL Server 2019 Big Data Cluster features including: • Service Endpoints table within the Management Dashboard that lists all key services in the cluster. • Cluster Status Notebook shows how you can query & troubleshoot cluster status across all services and pods. |
| Updated Language Packs Available | There are now 10 language packs available in the Extension Manager marketplace. Simply, search for the specific language using the extension marketplace and install. Once you install the selected language, Azure Data Studio will prompt you to restart with the new language. |
| SQL Server Profiler Update | The SQL Server Profile extension has been updated to include new features including: • Filtering by Database Name • Copy & Paste Support • Save/Load Filter A full list of improvements for SQL Server Profiler Extension can be found here. |
| Visual Studio Code May Release Merge 1.35 | Latest improvements can be found here. |
| Resolved bugs and issues | In previous releases of Azure Data Studio, if a user database was selected when connecting from the Connection dialog, the resulting Object Explorer entry was scoped entirely to that single database. Beginning in this release, that behavior is being changed so that server level properties are also shown in the object explorer. For a complete list of fixes see Bugs and issues, on GitHub. |
June 2019
June 6, 2019 / version: 1.8.0
| Change | Details |
|---|---|
| Release of Central Management Servers (CMS) extension | Central Management Servers store a list of instances of SQL Server that is organized into one or more central management server groups. Users can connect to their own existing CMS servers and manage their servers like adding and removing servers. To learn more, you can read here |
| Release of Database Administration Tool Extensions for Windows | This extension launches two of the most used experiences in SQL Server Management Studio from Azure Data Studio. Users can right-click on many different objects (such as Databases, Tables, Columns, Views, and more) and select Properties to view the SSMS Properties Dialog for that object. In addition, users can right-click on a database and select Generate Scripts to launch the well-known SSMS Generate Scripts Wizard. |
| Schema Compare Improvements | • Added Exclude/Include Options • Generate Script opens script after being generated • Removed double scroll bars • Formatting and layout improvements • Complete changes can be found here |
| Moved Messages section to own tab | When users ran SQL queries, results and messages were on stacked panels. Now they are in separate tabs in one panel like in SSMS. |
| SQL Notebook Improvements | • Users can now choose to use their own Python 3 or Anaconda installs in notebooks • Multiple Stabilities + fit/finish fixes • View the full list of improvements here |
| Visual Studio Code April Release Merge 1.34 | Latest improvements can be found here |
| Resolved bugs and issues. | See Bugs and issues, on GitHub. |
Known Issues
- Database Administration Tool Extensions for Windows
- Can't launch properties from disconnected server node
- Can't launch properties for Azure servers
- Not all objects have property dialogs
- Dialogs take a long time to start up
- Errors launching servers with some types of connections (such as Azure AD)
- Notebooks
- 5838 Allow users to use system Python for Notebooks
- Schema Compare
- 5804 Schema Compare tasks show default cancel context menu, which doesn'thing
May 2019
May 8, 2019 / version: 1.7.0
| Change | Details |
|---|---|
| Release of Schema Compare extension | Schema Compare is a well-known feature in SQL Server Data Tools (SSDT), and its primary use case is to compare and visualize the differences between databases and .dacpac files and to execute actions to make them the same. |
| Moved Task view to Output Window | Users can now view the status of long running tasks like Backup, Restore, and Schema Compare in the Task view in Output window |
| Added Welcome page | • Links to common actions like New Query, New File, New Notebook • Links to documentation and GitHub |
| SQL Notebook Improvements | • Markdown rendering improvements, including better support for notes and tables • Usability improvements to the toolbar • Markdown links for trusted notebooks no longer require Cmd/Ctrl + click and can be clicked directly • Improvements in cleaning up Jupyter processes after closing notebooks and reducing errors when starting multiple notebooks concurrently • Improvements to SQL notebook connections to ensure errors don't occur when running 2 notebooks against the same database • Improvements to notebook autoscrolling to the currently executing cell when clicking the Run Cells button from the toolbar • General stability and performance improvements |
| Resolved bugs and issues. | See Bugs and issues, on GitHub. |
April 2019
April 18, 2019 / version: 1.6.0
| Change | Details |
|---|---|
| Renamed Servers tab to Connections | |
| Moved Azure Resource Explorer as an Azure viewlet under Connections | Users can now view their Azure SQL instances through Azure viewlet in the Connections view and expand to view objects under each server or database. |
| SQL Notebook Improvements | • Added button on toolbar to clear output for all cells • Added button on toolbar to run all cells • Fixed connection name instead of server name (if set) in the Attach to dropdown • Fix for images in markdown not rendering when using relative image paths • Improved functionality in notebook grids by adding double-click auto resize column size and improved mousewheel support • Improvements to error handling and python install resiliency when installing python through notebooks • Improvements to "select all" functionality when selecting notebook cells • Improvements to notebook connections to prevent closing a notebook and impacting an object explorer connection • Improved notebook experience to display a message to the user when notebook disconnected and needs a connection to run cells • Improved support for unsaved notebooks to rehydrate in Azure Data Studio when Azure Data Studio is started again |
| Resolved bugs and issues. | See Bugs and issues, on GitHub. |
March 2019 (Hotfix)
March 22, 2019 / version: 1.5.2 / Hotfix release
| Change | Details |
|---|---|
| Fixed a few issues discovered in 1.5.1. | See March Hotfix Release, on GitHub. • Fixed issue where user couldn't close notebook opened from the "Open Notebook" task in the Dashboard • Fixed issue where Notebook JSON has extra } after save • Fixed issue where notebook grids weren't responding to theme changes • Fixed issue where full notebook path was shown in the tab header. Now only the filename is shown. |
March 2019
March 18, 2019 / version: 1.5.1
| Change | Details |
|---|---|
| Added PostgreSQL extension for Azure Data Studio | Supported features: • Connection Dialog • Object Explorer • Query Editor • Charting • Dashboards • Snippets • Edit Data • Notebooks |
| Added SQL Notebooks | Added SQL Kernel support to built-in Notebook viewer: • Supports T-SQL • Support PGSQL |
| Added PowerShell Extension | Brings over the PowerShell extension experience from VS Code. |
| Added SQL Server dacpac extension | Removes Data-Tier Application Wizard from SQL Server Import extension into a new extension. |
| Added Community extension QueryPlan.show | Adds integration support to visualize query plans |
| Updated SQL Server 2019 Preview extension | • Jupyter Notebook support, specifically Python3, and Spark kernels, have moved into the core Azure Data Studio tool. • Bug fixes to External Data Wizard |
| Resolved bugs and issues. | See Bugs and issues, on GitHub. |
Known Issues
- #4427: Clicking Run on Cell Before Kernel is Ready for Spark Results in Fatal Error Workaround: Wait until kernels are loaded until running any cells
- #4493: Azure Data Studio launched from SSMS using SQL auth - prompts user for password Workaround: Use Windows Auth for now.
- #4494: Unable to install SQL notebook feature
Workaround: Follow workaround steps here. - #4503: Azure Data Studio can't be Opened Directly from DownloAzure Data Studio Folder (Mac)
Workaround: Restart computer after unzipping the app. Will be investigated. - #4539: Notebook Save As loses connection context
Workaround: Will be fixed in next release. - #4458: Dacpac Extract crashes SqlToolsService if invalid version is used
Workaround: Restart Azure Data Studio and ensure correct version is used. - New Notebook and Open Notebook icons are lost
Workaround: The legacy connection type is deprecated. We recommend connecting to the SQL Server endpoint and you'll get all the actions (New Notebook, Spark Job) as expected.
February 2019
February 13, 2019 / version: 1.4.5
| Change | Details |
|---|---|
| Added Admin pack for SQL Server extension pack. | This makes it easier to install SQL Server admin-related extensions. This includes: • SQL Server Agent • SQL Server Profiler • SQL Server Import |
| Added filtering extended event support in Profiler extension. | |
| Added Save as XML feature that can save T-SQL results as XML. | |
| Added Data-Tier Application Wizard improvements. | • Added Generate script button • Added view to give warnings of possible data loss during deployment. |
| Updates to the SQL Server 2019 Preview extension. | See Data Virtualization extension. |
| Results streaming enabled by default for long running queries. | |
| Resolved bugs and issues. | See Bugs and issues, on GitHub. |
January 2019 (Hotfix)
January 16, 2019 / version: 1.3.9 / Hotfix release
| Change | Details |
|---|---|
| Fixed a few issues discovered in 1.3.8. | See January Hotfix Release, on GitHub. For detailed information, see: • Change Log, on GitHub. • Releases, on GitHub. |
January 2019
January 09, 2019 / version: 1.3.8
| Change | Details |
|---|---|
| Added a new user installer for Windows. | Unlike the existing system installer, the new user installer doesn't require administrator privileges. This also enables an easier upgrade experience for non-administrators. |
| Added Azure Active Directory Authentication support. | |
| Announcing Idera SQL DM Performance Insights (preview). | |
| Data-Tier Application Wizard support in SQL Server Import extension. | |
| Update to the SQL Server 2019 Preview extension. | See Data Virtualization extension. |
| SQL Server Profiler improvements. | |
| Results Streaming for large queries (preview). | |
| Community extensions: sp_executesql to sql and New Database. | |
| Resolved bugs and issues. | See Bugs and issues, on GitHub. |
Next steps
See one of the following quickstarts to get started:
- Download Azure Data Studio
- Connect & Query SQL Server
- Connect & Query Azure SQL Database
- Connect & Query Azure Synapse Analytics
Contribute to Azure Data Studio:
Pripomienky
Odoslať a zobraziť pripomienky pre