Release notes for Azure Data Studio

Download and install the latest release!

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
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)
New Azure Arc features Multiple data controllers now supported
New connection dialog options like 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 does not 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 ADS before 1.24.0 have a breaking change in object explorer due to 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
Machine Learning
Kusto (KQL)
Schema Compare
SQL Assessment
SQL 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 as well as 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 ADS. 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 is 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 merge 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 inside of a notebook. Find in Notebook support searches line by line through both code and text cells.
VS Code merge 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 additional 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 additional 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 additional 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 Stability + 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 does nothing

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 do not 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 ADS when ADS 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 could not 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 were not 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 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: ADS 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 Downloads 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 does not 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.

November 2018

November 6, 2018   /   version: 1.2.4


Change Details
Update to the SQL Server 2019 Preview extension. See Data Virtualization extension.
Introducing Paste the Plan extension.  
Introducing High Color queries extension, including SSMS editor theme.  
Fixes in SQL Server Agent, Profiler, and Import extensions.  
Fix .NET Core Socket KeepAlive issue causing dropped inactive connections on macOS.  
Upgrade SQL Tools Service to .NET Core 2.2 Preview 3 (for eventual Azure AD support).  

Bug Fixes, November 2018

  • Fix issue #2933: Connection lost to Azure SQL Database
  • Fix issue #2914: "Invalid argument" exception expanding OE database node
  • Fix issue #2935: Display multi-line messages correctly in query results
  • Fix issue #2906: Fix Edit Data document name when table name contains special characters
  • Fix issue #2929: Built in extension changelog says to check the VSCode Release Notes for changes
  • Fix issue #2719: High Contrast theme doubles/triples icons
  • Fix issue #3047: Add a command-line interface for connecting to a SQL Server
  • Fix issue #3031: Add query plan theme support

October 2018

October 29, 2018   /   version: 1.1.4


Change Details
Introducing the Azure Resource Explorer to browse Azure SQL Database.  
Improve Object Explorer and Query Editor connectivity robustness.  
SQL Agent extensions improvements.  
Update to the SQL Server 2019 Preview extension. See Data Virtualization extension.

Bug Fixes, October 2018

  • Fix issue #2717: XML Column result click formatting
  • Fix issue #2993: Width's Result windows is incomplete
  • Fix issue #2999: Could not load file System.Diagnostics.Tracing on Mac when connecting to DB
  • Fix issue #2851: TimeSeries chart does not render correctly
  • Fix issue #2996: Temp table loss due to sudden session change

For detailed information, see the Change Log, and Releases.

September 2018 (GA Release)

September 24, 2018   /   version: 1.0   /   GA release

General Availability release of Azure Data Studio (formerly SQL Operations Studio).


Change Details
Query Results Grid performance and UX improvements for large number of result sets.  
Visual Studio Code source code refresh from 1.23 to 1.26.1 with Grid Layout and Improved Settings Editor (preview).  
Accessibility improvements for screen reader, keyboard navigation, and high-contrast.  
Added Connection name option to provide an alternative display name in the Servers view-let.  

Announcing the SQL Server 2019 Preview extension


Change Details
Support for SQL Server 2019 preview features including big data cluster support. Connect to the HDFS/Spark Gateway shipped with SQL Server 2019 preview.

Browse HDFS, upload files, save files, and launch useful actions such as Analyze in Notebook for CSV files.

Submit Spark jobs from the dashboard or right-click on a HDFS/Spark connection in Object Explorer.
Azure Data Studio Notebooks. Create or open Notebooks using an integrated Notebook viewer. In this release, the Notebook viewer supports connecting to local kernels and the SQL Server 2019 big data cluster only.

Use the PROSE Code Accelerator libraries in your Notebook to learn file format and data types for fast data preparation.
Azure Resource Explorer. The Azure Resource Explorer view lets you browse data-related endpoints for your Azure accounts and create connections to them in Object Explorer. In this release, Azure SQL Database is supported.
SQL Server PolyBase Create External Table Wizard. Create an external table and its supporting metadata structures with an easy to use wizard. In this release, remote SQL Server and Oracle servers are supported.

Bug Fixes, September 2018

  • Fix issue #2647: The charts took a significant step backwards.
  • Fix issue #2648: SELECT that returns a JSON hyperlinks the whole column.

For detailed information, see the Change Log, and Releases.

August 2018

August 30, 2018   /   version: 0.32.8   /   Public Preview

The August Public Preview focuses on bug fixes, product stabilization, and filling in gaps existing scenarios.

0.32.8 contains fixes for a couple regressions found in 0.32.7 (#1971, #2372)


Change Details
Announcing the SQL Server Import Extension.  
SQL Server Profiler Session management.  
SQL Server Profiler session template support.  
SQL Server Agent improvements.  
New community extension: First responder kit.  
Quality of Life improvements: Connection strings  

Bug Fixes, August 2018

  • Parse SQL in a Query Editor window by using the Parse Syntax command.
  • Fix issue #143: Double-click not selecting @ in variable name.
  • Fix issue #387: SQL Tab DB Icon is red.
  • Fix issue #825: Request: Auto Connect to current server after Script as...
  • Fix issue #1278: sqlops.desktop [Desktop Entry] - redundant value for Name & Comment.
  • Fix issue #1285: Updating causes application icon to be removed/replaced in Windows.
  • Fix issue #1317: Fix the decimal separator.
  • Fix issue #1474: Cancel change connection disconnects current connection.
  • Fix issue #1497: View as Chart options are cut off at the bottom.
  • Fix issue #1524: Shell/Dashboard: Main viewlet icons are draggable and can crash the app.
  • Fix issue #1578: Not able to expand/collapse remote file browser folder by clicking name.
  • Fix issue #1620: Feature Suggestion: Get Connection String for existing connection.
  • Fix issue #1624: SelectBox doesn't change color when disabled.
  • Fix issue #1728: Save as JSON/EXCEL/CSV not work.
  • Fix issue #1744: Results pane loses its scrolling positions when switching between tabs.
  • Fix issue #1748: Error message when saving Excel file second (and subsequent) time.
  • Fix issue #1782: Edit data: cell doesn't revert to original value on hitting Escape key.
  • Fix issue #1836: .sql files not associated with SQL Operations Studio.
  • Fix issue #1850: Typing N'' autocompletes to N'''.
  • Fix issue #1985: Copy from query results grid is off by one column.
  • Fix issue #1998: Add VS Code version to About dialog.
  • Fix issue #2042: Agent: Enabled button to import queries from sql files.
  • Fix issue #2091: Can't use Ctrl+C shortcut to copy from result pane.
  • Fix issue #2099: Added more saveAsCsv options.
  • Fix issue #2107: Update document icon for Dashboard and Profiler documents.
  • Fix issue #2129: Save edit data scroll position when switching tabs.
  • Fix issue #2152: Results Grid Row Indicator Zero Based.

Known Issues, August 2018

  • Issue #2371 Save As Excel Only Saves First Row of Data
  • Issue #2150: Unable to connect on Ubuntu 16.04 to SQL in a container

July 2018

July 19, 2018   /   version: 0.31.4   /   Public Preview

The July Public Preview focuses on the following items:

  • The initial release of the SQL Server Agent configuration scenarios.
  • SQL Server Profiler session and view template enhancements.
  • Continued bug fixes for customer reported GitHub issues.


Change Details
SQL Server Agent for SQL Operations Studio extension improvements. Added view of Alerts, Operators, and Proxies and icons on left pane.

Added dialogs for New Job, New Job Step, New Alert, and New Operator.

Added Delete Job, Delete Alert, and Delete Operator (right-click).

Added Previous Runs visualization.

Added Filters for each column name.
SQL Server Profiler for SQL Operations Studio extension improvements. Added 5 Default Templates to view Extended Events.

Added Server/Database connection name.

Added support for Azure SQL Database instances.

Added suggestion to exit Profiler when tab is closed when Profiler is still running.
Release of Combine Scripts Extension.  
Wizard and Dialog Extensibility points added for Extension Authors.  

Bug Fixes, July 2018

  • Fix issue 728: No response to Add Connection on macOS
  • Fix issue 1612: Results grid text display is messed up by international characters
  • Fix issue 1693: Backup dialog: File browser UI is broken
  • Fix issue 1713: Number of rows affected
  • Fix issue 1718: Unable to connect to any datasource
  • Fix issue 1719: TypeError when Connecting to Server
  • Fix issue 1724: Extension dialogs have stopped working
  • Fix issue 1749: BUG: HTML data in a column gets interpreted
  • Fix issue 1789: Extensibility: if you add a connection provider uninstall will never remove it from the list
  • Fix issue 1791: Sqlops Extensions: queryeditor.connect() connects to the target database, but UI does not show the editor is connected
  • Fix issue 1799: Top 10 DB Size chart does not work on case-sensitive instances
  • Fix issue 1814: sqlops.d.ts typo causing implicit 'any' type definition
  • Fix issue 1817: Error de Ortografia
  • Fix issue 1830: Setting iconPath in ButtonComponent after component() is called does not change icon
  • Fix issue 1843: Better Table organization

June 2018

June 20, 2018   /   version: 0.30.6   /   Public Preview


Change Details
SQL Server Profiler for SQL Operations Studio Preview extension initial release.  
The new SQL Data Warehouse extension includes rich customizable dashboard widgets surfacing insights to your data warehouse. This unlocks key scenarios around managing and tuning your data warehouse to ensure it is optimized for consistent performance.
Edit Data "Filtering and Sorting" support.  
SQL Server Agent for SQL Operations Studio Preview extension enhancements for Jobs and Job History views.  
Improved Wizard & Dialog UI Builder Framework extensibility APIs.  
Update VS Code Platform source code. Integrated the following releases:
•   March 2018 (1.22)
•   April 2018 (1.23)

GitHub Issues Fixes, June 2018

  • Feature request (issue 1204): Make the results grid autofit column width to data, and remember manual changes if the same query is rerun.
  • Fix issue 1398: Should show add message and add account button when linked account is empty.
  • Fix issue 1399: Linked account tab is broken when the view is collapsed.
  • Fix issue 1374: SQL Tools Service crashes when opening .sql file from disk.
  • Fix issue 1372: Missing SQL keyword "BETWEEN".
  • Fix issue 1395: 'MATCH' keyword crashes SQL Tools Service.
  • Fix issue 1496: "New Profiler" context menu option in Object Explorer does nothing.
  • Fix issue 1495: Query editor "Explain" query plan is broken.

May 2018

May 7, 2018   /   version: 0.29.3   /   Public Preview

The May Public Preview is focused on stabilization and bug fixes.


Change Details
Announcing Redgate SQL Search extension available in Extension Manager.  
Community Localization available for 10 languages. German, Spanish, French, Italian, Japanese, Korean, Portuguese, Russian, Simplified Chinese, and Traditional Chinese.
Telemetry collection changes. •   Reduced telemetry collection.
•   Improved opt-out experience.
•   In-product links to Privacy Statement.
Extension Manager has improved Marketplace experience. More easily discover community extensions.
SQL Agent extension. •   Jobs.
•   Job History view improvement.
Updates for whoisactive and Server Reports extensions.  
Improved scrolling of Manage Dashboard Properties.  

Fix GitHub Issues

  • Fix issue 703: Entering HTML-like text in edit data causes value to display incorrectly until refresh
  • Fix issue 821: azuredatastudio.deb package dependency
  • Fix issue 1260: Keyword 'distinct' not highlighted
  • Fix issue 1332: Edit data revert row doesn't work
  • Fix issue 1215: SQL Agent extension and the status bar
  • Fix issue 1316: SQL Agent Don´t resize after change windows size

April 2018

April 25, 2018   /   version: 0.28.6   /   Public Preview

The April Public Preview contains bug fixes and improvements.


Change Details
Improvements to the SQL Agent Preview extension:  
      Improved support for files. •   Large files.
•   Protected files, for saving Admin protected.
•   Storing >256M files within SQL Operations Studio.
      Integrated Terminal Splitting. Work with multiple open terminals simultaneously.
      Faster installs and startup times. Reduced installation of on-disk file count foot print.

Fix GitHub issues, April 2018

  • Fix issue 37: When the chart viewer throws an error, unexpected behavior occurs.
  • Fix issue 462: Feature Request: Option for Server Groups to be expanded by default.
  • Fix issue 606: intellisense - Bad suggestion for 'update' command.
  • Fix issue 967: Expect query plan when select XML showplan in the result grid.
  • Fix issue 1023: Add square brackets for ms_foreachdb call from flyfishingdba.
  • Fix issue 1048: Pre-login SSL/TLS handshake error.
  • Fix issue 1050: Clear insights view before showing error.
  • Fix issue 1057: Restore and new query actions in explorer-widget are broken.
  • Fix issue 1068: Dashboard Output windows pops-up with error message for Azure SQL Database.
  • Fix issue 1069: Connection Dialog shows Server Required error when initially displayed.
  • Fix issue 1070: Server Groups now require a double-click to expand.
  • Fix issue 1072: Select control background is semi-transparent.
  • Fix issue 1115: Fix all high contrast accessibility issues in SQL Operations Studio.
  • Fix issue 1101: Extension fails to upgrade "Download Manually" link goes to wrong location.
  • Fix issue 1103: V Scroll not working on Home Tab.
  • Fix issue 1104: SQL extension tabs stopped working.

Visual Studio Code 1.21 platform

A highlight for the April Public Preview is the refresh of the source code for the Visual Studio Code 1.21 platform. This brings several updates to the core editor and workbench from the previous 1.19 sync point. Some examples include the following:


Change Details
New Notifications UI. Easily manage and review SQL Operations Studio notifications.
Integrated Terminal splitting. Work with multiple open terminals at once.
Save large and protected files. Save Admin protected and >256M files within SQL Operations Studio.
Improved large file support. Text buffer optimizations for large files.
Improved Settings search. Easily find the right setting with natural language search.
Global snippets. Create snippets you can use across all file types.
Explorer multi-selection. Perform actions on multiple files at once.
Errors & warnings in Explorer. Quickly navigate to errors in your code base.
Drag & drop, copy & paste across windows. Move files across open SQL Operations Studio windows.
Git submodule support. Perform Git operations on nested Git repositories.
Terminal screen reader support. Integrated Terminal now has Screen Reader Optimized mode.
Centered editor layout. Maximize your code viewing screen real estate.
Horizontal search results (preview). You can now view search results in a horizontal panel.

For additional details, check out the Visual Studio Code February Release Notes, and the Visual Studio Code January Release Notes.

For more information, see the Change Log.

March 2018

March 28, 2018   /   version: 0.27.3   /   Public Preview

The March Public Preview continues to address the top GitHub issues, and is focused on improving our extensibility story. Specifically enabling Extension Manager, improving dashboard management, and providing SQL Agent and insights extensions. This release includes the following enhancements:


Change Details
Enhance the dashboard extensibility model to support tabbed insights and configuration panes. Extension Manager enables simple acquisition of extensions.

Dashboard extensions for sp_whoisactive from

For details, see Extend the functionality of SQL Operations Studio.
Add additional extensibility APIs for connection and object explorer management.  
Continue to fix important customer impacting GitHub issues.  

February 2018

February 15, 2018   /   version: 0.26.7   /   Public Preview

The February Public Preview includes some feature suggestions and high-priority bug fixes. This release includes the following enhancements:


Change Details
Introducing Auto-Update Installation, which provides a notification when a new release is available to download.  
The Connection Dialog Database field is now a dynamically populated drop-down list that will contain a list of databases populated from the specified server.  
Introduce Connection extensibility API.  
VS Code Editor 1.19 integration.  
Update JustinPealing/html-query-plan component to pick up several Query Plan viewer improvements.  

Fixed Issues, February 2018

  • Fix issue 6: Keep connection and selected database when opening new query tabs.
  • Fix issue 22: 'Server Name' and 'Database Name' - Can these be drop downs instead of text boxes?
  • Fix issue 549: Silent/Very Silent Install results in application opening after installation.
  • Fix issue 481: Add "Check for updates" option.
  • SQL Editor colorization and autocompletion fixes:
    • Fix issue 584: Keyword "FULL" not highlighted by IntelliSense.
    • Fix issue 345: Colorize SQL functions within the editor.
    • Fix issue 300: [#tempData] latest "]" will display green color.
    • Fix issue 225: Keyword color mismatch.
    • Fix issue 60: Invalid sql syntax color highlighting when using temporary table in from clause.

January 2018

January 17, 2018   /   version: 0.25.4   /   Public Preview

The January Public Preview includes some feature suggestions and high-priority bug fixes. This release includes the following enhancements:


Change Details
Saved Server connections are available in the Connection Dialog.  
Enable Hot exit. Hot exit is off by default. To enable, see Hot exit setting.  
Tab-coloring based on Server Group. Tab coloring is off by default. To enable, see Tab color setting.  
Change Server name to Server in the Connection Dialog.  
Fix broken Run Current Query command.  
Fix drag-and-drop breaking scripting bug.  
Fix incorrect pinned Start Menu icon.  
Fix missing Azure Account branding icon.  

December 2017

December 19, 2017   /   version: 0.24.1   /   Public Preview

The December Public Preview includes several bugs fixes across all feature areas, as well as the following enhancements:


Change Details
Create Firewall Rule Dialog is now available to assist connecting to Azure SQL Database and Azure Synapse Analytics.  
Added Windows Setup, and Linux DEB and RPM installation packages.  
Manage Dashboard visual layout editor.  
Script As Alter and Script As Execute commands.  
Run Current Query with Actual Plan command.  
Integrate VS Code 1.18.1 editor platform.  
Enable Sideloading of VSIX Extension files.  
Support "GO N" batch iteration syntax.  

November 2017

November 15, 2017   /   version: 0.23.6

  • Initial release of Azure Data Studio.

Next Steps

See one of the following quickstarts to get started:

Contribute to Azure Data Studio: