Softpedia >Windows >Internet >Servers >Database Utils >Azure Data Studio >  Changelog

Azure Data Studio Changelog

What's new in Azure Data Studio 1.48.0

Feb 29, 2024
  • New Item:
  • Backup/Restore:
  • Add restore from S3-compatible storage to restore dialog
  • Add Restore Database option to Database context menu in Object Explorer
  • Add SQL Server Restore from URL to restore dialog
  • Copilot:
  • Add ability to change github account
  • Query Editor:
  • Add Session ID / SPID to query editor tabs
  • Object Explorer:
  • Add ability to enable Ledger in Create Database dialog
  • Shell:
  • Support Connect command when launching ADS from the command line
  • Bug fixes in 1.48.0:
  • Connections:
  • Fixed Azure AD - Universal with MFA support doesn't work on Redhat Linux
  • Fixed Error: “Cannot read properties of undefined (reading 'serverInfo')”
  • Fixed proxy errors browsing Azure resources
  • Fixed Error: “UserName cannot be null or empty when using SqlLogin authentication” message when using ’Active Directory Default' authentication
  • Edit Data:
  • Deleting row causes focus to be in wrong row
  • Notebooks:
  • Fixed Installing Notebook dependencies failed with error: Cannot read property 'version' of undefined
  • Fixed "Open in editor" link in Notebooks search results doesn't work
  • Object Explorer:
  • Removed the drop database icon from the connection browser menu
  • Query Editor:
  • Fixed tabs not visible in query editor
  • Fixed query editor does not display any results when results being with “#”
  • Improved speed when copying data from results grid to clipboard
  • Fixed blank/empty results pane after executing a query
  • Fixed invalid results when field contains HTML or XML

New in Azure Data Studio 1.47.1 (Jan 11, 2024)

  • Bug fixes:
  • Query Editor:
  • Fixed query results with blank string interpreted as XML
  • Shell:
  • Fixed not all installation files signed
  • Security:
  • Update to Microsoft.Data.SqlClient 5.1.3 that patches CVE-2024-0056

New in Azure Data Studio 1.47.0 (Nov 8, 2023)

  • Improved visibility of advanced options in tabs and tooltips
  • Implemented usability improvements to object properties dialogs
  • Allow extensions to hook into provider events
  • Improved charting capability
  • Enabled Mssql: Parallel Message Processing by default to improve application performance when working with MSSQL connections.
  • Added Mssql: Parallel Message Processing Limit with a default of 100 to control the number of threads used for parallel processing.
  • Updated notifications so they close automatically upon task completion
  • Updated version to 6.5.6 and removed traitlets v5.9.0 from required notebook dependencies
  • Added Select Top 1000 menu option for the history table of a system-versioned temporal table
  • Usability improvements including added context menus
  • Added additional options for saving results to Excel
  • Added support to display formatted XML data when stored as a VARCHAR data type
  • References to Azure Active Directory (Azure AD) have been updated to Microsoft Entra, see Azure AD is Becoming Microsoft Entra ID for details.
  • Merges upstream improvements from VS Code 1.80, 1.81, and 1.82. These releases contained numerous new features as well as quality, performance, stability, and compliance enhancements. The full details can be reviewed in the VS Code release notes at: Visual Studio Code June 2023, Visual Studio Code July 2023, and Visual Studio Code August 2023.
  • Bug fixes:
  • Fixed error "multiple matching_tokens occurred when acquiring token." when authenticating to Azure resources
  • Fixed autocomplete suggests "abort" whenever new comment is begun
  • Updated prefix for Clear Pooled Connections in the command palette to use the MSSQL prefix
  • Fixed proxy setting values not being passed to backend SQL Tools Service
  • Removed tenant filter config setting
  • Fixed issue where server dashboard was loading before activation of extension completed
  • Fixed issue where the Notebook Python process continued to run after Azure Data Studio is closed
  • Fixed Jupyter Notebook entry in new file command under command palette does nothing
  • Fixed silent failure when attempting to open script files
  • Removed duplicate entry for Group By Schema from command palette
  • Addressed behavior where selecting Manage for an Azure SQL Database opened the dashboard for the logical server instead of the database
  • Fixed issue where Profiler columns were not resizeable
  • Resolved problem where selecting Ctrl + F in the Profiler extension did not bring up Find dialog
  • Updated maximum value supported for Query: Text Size setting to fix results not being copied to the clipboard
  • Fixed issue where query editor would not open due to initialization errors
  • Fixed error "Cannot connect to the database due to invalid OwnerUri" after saving a new query file
  • Fixed error loading query history items
  • Fixed issue where schema compare does not show that it is running while doing a comparison
  • Fixed issue where Azure Data Studio stops responding after attempting to apply schema compare changes
  • Shortened query tab titles for edit data
  • Updated hyperlinks to use correct theming so they are visible when using dark theme
  • Updated shell default behavior to not open any editor when Show welcome page on startup is not selected
  • Fixed issue where database project fails to build with syntax error when including a database scoped credential object

New in Azure Data Studio 1.46.0 (Sep 20, 2023)

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

New in Azure Data Studio 1.45.1 (Aug 7, 2023)

  • Fixed:
  • Connection:
  • Fixed an issue that prevented all connections from appearing in the server tree view.
  • Updated recent connections list to include connections that are not saved.
  • Database Migration Assessment for Oracle:
  • Resolved issue where links to open the assessment output were no longer working.
  • Database Schema Conversion Toolkit:
  • Resolved issue where links to open the conversion output were no longer working.
  • Installation Addressed error "gyp WARN install" for Windows arm64.
  • Profiler:
  • Fixed an issue where the session dropdown was not populated when an XEL file is opened.
  • Addressed issue where running state was incorrectly set after a session was started.

New in Azure Data Studio 1.45.0 (Jul 27, 2023)

  • What's new in 1.45.0:
  • Connection Introduced support for Tenant hierarchy in the Azure tree
  • Connection Updated Azure tree icons
  • Connection Updated the Azure tree in the Connection Pane to show only available resource types
  • Connection Added Azure Postgres Flexible Server and Azure CosmosDB for PostgreSQL in the Azure resource tree
  • Connection Added support for advanced connection options for other providers
  • Connection Added capability to clear encryption keys with the 'Clear Azure Account Token Cache' command
  • Connection Introduced support for connection pooling for MSSQL connections
  • GitHub Copilot GitHub Copilot extension version 1.95.239
  • MySQL Extension General Availability
  • Object Explorer Added support for additional Filter options in Object Explorer
  • Object Explorer Reduced size of server group color block
  • Object Explorer Enabled 'Async Server tree' for the Server tree view
  • Object Explorer Added inline actions (e.g. edit, delete, refresh)
  • Object Explorer Introduced an action to collapse all open objects in Object Explorer
  • Object Explorer Added ability to use left and right arrows in OE to open or close trees
  • Object Explorer Right-click menu options updated and order modified
  • Profiler / Extended Events Introduced support for opening .XEL files up to 1GB in size
  • Query Editor Introduced a new configuration option to control whether to add a line break between rows when copying if the previous row has a trailing line break
  • Result Set Introduced keyboard shortcut (Ctrl/CMD + Shift + C) to copy information from the results grid with headers
  • Result Set Introduced keyboard shortcut (Ctrl/CMD + Shift + O) to sort columns in a result set
  • SQL Database Projects Extension Added the ability to create a publish profile from the Add Item… menu
  • Table Designer Added configuration option to prevent DDL triggers from being disabled as part of the table modification
  • User Management Improved table component performance in the Securables dialog of User properties
  • VS Code merge VS Code merges to version 1.79, read their release notes to learn more
  • Bug fixes in 1.45.0:
  • Accessibility Improved contrast for buttons on Welcome page when using light themes
  • Accessibility Improved focus on Home tab when using High Contrast Aquatic/Desert theme
  • Accessibility Corrected border color the issue reporter dialog when using light theme
  • Accessibility Fixed multiple issues with screen readers
  • Accessibility Improved keyboard navigation in select database dropdown and added visual label
  • Accessibility Added required indicator for Server group name when configuring a server group
  • Accessibility Fixed display so contents are visible at 200% zoom in Notebook cell
  • Accessibility Added tooltip for Learn more button in New Deployment window
  • Backup/Restore Addressed issue with backup/restore dialog titles not updating for non-MSSQL databases
  • Central Management Servers Extension Resolved error generated after saving a connection using SQL authentication
  • Charting Addressed issue with mix/max value setting for a chart axis
  • Connection Improved dialog window for adding an Azure account when authentication code is required
  • Connection Fixed throttling of ARM requests when in the Browse Connections tab
  • General Fixed issue with vertical scrolling in dialog windows
  • General Fixed error "Cannot read properties of undefined"
  • Notebooks Addressed inability to open JSON in a new tab from Notebook results cell
  • Notebooks Fixed error "Unable to load and parse grammar for scope markdown.math.inline" when creating a Notebook text cell
  • Object Explorer Addressed connection leak which occurred when renaming a table
  • Object Explorer Improved error handling in server tree expand requests
  • Object Explorer Fixed issue with unexpected connection drops in Object Explorer
  • Query Editor Corrected syntax highlighting for nested multi-line comments
  • Query Editor Addressed issue where folding behavior incorrectly included blank lines at the end of a text block
  • Query Editor Resolved issue when executing USE DATABASE_NAME command and database context did not change in the status bar
  • Query Plan Viewer Fixed issue with filter icon appearing over query text in Top Operations window
  • Result Set Fixed issue where HTML entered in Edit Rows mode was being rendered
  • Result Set Fixed incorrect aggregation (sum) when selecting rows in the result set and implemented performance improvements
  • Result Set Improved support for copying large result sets to the clipboard
  • Result Set Added progress notification when copying result sets and implemented performance improvements
  • Result Set Improved formatting and result set navigation for columns containing XML
  • Result Set Added notification to identify when the number of rows or columns copied exceed Excel limits
  • SQL Database Projects Extension Addressed issue with schema compare dropping constraints
  • SQL Database Projects Extension Removed incorrect delete command from database references node
  • SQL Database Projects Extension Introduced ability to add sqlcmd variables without a default value via the quickpick
  • User Management Removed unsupported database roles for Azure SQL DB user creation
  • User Management Included MUST_CHANGE option for Azure SQL when creating a new login or for a password change

New in Azure Data Studio 1.44.1 (Jun 6, 2023)

  • New Item:
  • Backup & Restore Fixed an issue in Object Explorer where the Restore dialog failed to open. #23257
  • Connection Resolved issue that caused a login failure in Azure SQL for hyphenated user accounts. #23210
  • Object Explorer Addressed inability to open a view using CTRL/CMD + Q or the Open View menu. #23236
  • Query Editor Introduced a performance improvement in the Query Editor language service by enabling connection pooling. #22970

New in Azure Data Studio 1.44.0 (Jun 3, 2023)

  • New Item:
  • Connection Enabled Sql Authentication Provider by default for Azure SQL connections and the MSAL Authentication Library. Learn more at Connect with Azure Data Studio
  • Connection Introduced support for passing in advanced connection options in command line arguments
  • Connection Added ability to provide an Application Name in the connection string parameter
  • General Added support for customizing table keyboard shortcuts
  • General Added warning notification on startup if Azure PII logging is enabled
  • GitHub Copilot GitHub Copilot extension for autocomplete-style suggestions added to extension gallery. Learn more at https://aka.ms/ads-copilot
  • Notebooks Fixed issue where deleted text listed using the Find feature
  • Object Explorer Introduced filtering capability for Object Explorer (preview)
  • Query Editor Shorted text for Change Connection and Export as Notebook button
  • Query Results Increased the default max column width
  • SQL Database Projects Extension Released version 1.1.1
  • SQL Database Projects Extension Improved performance of loading one or more large projects
  • SQL Database Projects Extension Introduced ability to save publish settings to a new or existing publish profile
  • User Management Added support for creating database and server roles (preview)
  • User Management Improved authentication options when creating database users (preview)
  • Bug fixes in 1.44.0:
  • Accessibility Added labels to radio groups in SQL Database Projects dialog
  • Accessibility Fixed issue with narrator reading character twice in network share path for Azure SQL migration extension
  • Accessibility Addressed problem where keyboard focus did not shift to error message when creating a new database
  • Accessibility Fixed issue with voiceover not announcing label names correctly when updating a database project
  • Connection Improved token refresh behavior
  • Connection Enabled support to login with blank passwords when creating MSSQL connection
  • Connection Added change password dialog display after password expiration occurs for a SQL login
  • Connection Addressed scenario where Intellisense stopped working after a connection token expired
  • Connection Fixed behavior where PostgreSQL username was incorrectly replaced
  • Connection Implemented support for connections against the same server but with different properties
  • Connection Resolved issue where connection status changed to red (disconnected) after moving an active connection to a server group
  • Connection Updated Azure node in Connection dialog to include notation when no subscriptions are found
  • Connection Updated firewall dialog to pre-select the account and tenant in the connection dialog
  • Extension Fixed an issue with over-encoded URLs in diagnostic error messages
  • Intellisense Resolved issue with SORT_IN_TEMPDB not recognized as valid T-SQL syntax when creating an object
  • Notebooks Updated Notebook connection to support MySQL and PostgreSQL when connecting to an existing Notebook
  • Query Results Fixed overlapping action display when multiple result sets are returned
  • Schema Compare Update scmp files to be backwards compatible
  • SQL Database Projects Extension Fixed multiple issues related to SQLCMD variables and projects
  • SQL Database Projects Extension Addressed a failure that was occurring when using schema compare with Azure Synapse dedicated pools
  • SQL Database Projects Extension Resolved problem where a database project would not build after a reference to a system database was added from SSDT
  • SQL Database Projects Extension Fixed issue where projects were listed twice when using multi root workspaces
  • SQL Database Projects Extension Fixed an issue where file structure information was not stored in the scmp file after a schema compare
  • SQL Database Projects (VS Code) Updated default folder location when creating a new project from database workflow

New in Azure Data Studio 1.43.0 (Apr 12, 2023)

  • What's New:
  • 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:
  • 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

New in Azure Data Studio 1.42.0 (Mar 23, 2023)

  • New Item:
  • 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:
  • 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.

New in Azure Data Studio 1.41.2 Hotfix 2 (Feb 10, 2023)

  • Fixed:
  • Fixed a regression blocking connections to sovereign Azure clouds
  • Fixed a regression causing the Output window to display on each query execution

New in Azure Data Studio 1.41.1 (Jan 30, 2023)

  • Fixed a bug causing incorrect Azure account tenant selection when connecting to server through the Azure view. #21643
  • Fixed a regression which caused Object Explorer to not show database objects for Azure SQL DB Basic SLO. #21735

New in Azure Data Studio 1.41.0 (Jan 26, 2023)

  • Azure Subscriptions Introduced Azure Synapse Analytics and Dedicated SQL Pools nodes.
  • Azure SQL Migration Extension Premium series memory optimized SQL MI SKUs included in recommendations.
  • Connection Migrated Azure authentication library from ADAL to MSAL. MSAL is the library used by default starting with release 1.41. However, if you encounter issues, you can change back to ADAL within Settings > Azure: Authentication Library.
  • Connection Added ability to provide a description when creating a firewall rule from Azure Data Studio.
  • Connection Include ability to change password for new or expired login.
  • Connection Add support for SQL Server Alias use when connecting to a server.
  • MongoDB Atlas Extension Provides the ability to connect to and query data on MongoDB Atlas (Preview).
  • Notebooks Provide option for users to convert markdown to a table or not when HMTL table tag is present.
  • Object Explorer Databases are no longer brought online in serverless Azure SQL when Databases node is expanded.
  • Object Explorer Added support for Ledger views.
  • Object Explorer Fixed issue with key binding for objectExplorer.manage not working.
  • Query Editor Fixes and updates to SQL grammar (colorization and auto-complete).
  • Query Plan Viewer Changed default folder to be user’s home directory when saving a query plan.
  • Query Results Added ability to only copy Column Headers, and only for cells that are highlighted.
  • Query Results Added option to show or hide the action bar in the results window.
  • Query Results Increased height of horizontal scrollbar in results window.
  • Query Results Added new aggregate details in the results toolbar when selecting multiple cells.
  • SQL Projects Extension Provide the ability select an existing project via a new dropdown.

New in Azure Data Studio 1.40.2 (Dec 27, 2022)

  • Fix potential elevation of privilege issue using Bash shell on Windows. VS Code issue #160827

New in Azure Data Studio 1.41.0 (Nov 23, 2022)

  • Bug fixes in 1.40.1:
  • Fixed bug that caused folders in the servers tree to display incorrect contents (#21245)

New in Azure Data Studio 1.40.0 (Nov 17, 2022)

  • New Item:
  • 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.

New in Azure Data Studio 1.39.1 (Aug 31, 2022)

  • Fixed bug that caused Database Trees in server connections to not expand in the Object Explorer.

New in Azure Data Studio 1.38.0 (Jul 27, 2022)

  • VS Code merges to 1.62:
  • This release includes updates to VS Code from the three previous VS Code releases. Read their release notes to learn more.
  • Table Designer:
  • New column added to Table Designer for easier access to additional actions specific to individual rows.
  • Query Plan Viewer:
  • The Top Operations pane view now includes clickable links to operations in each of its rows to show the runtime statistics which can be used to evaluate estimated and actual rows when analyzing a plan.
  • Improved UI on selected operation node in the Execution Plan.
  • The keyboard command CTRL + M no longer executes queries. It now just enables or disables the actual execution plan creation when a query is executed.
  • Plan labels are now updated in the Properties window when plans are compared and the orientation is toggled from horizontal to vertical, and back.
  • Updates were made to the Command Palette. All execution plan commands are prefixed with "Execution Plan", so that they are easier to find and use.
  • A collapse/expand functionality is now available at the operator level to allow users to hide or display sections of the plan during analysis.

New in Azure Data Studio 1.37.0 (Jun 16, 2022)

  • New Features:
  • Backup & Restore - Backup & Restore to URL is now available in preview for Azure SQL Managed Instances.
  • Table Designer - Added API to support computed column capabilities on Table Designer.
  • Table Designer - Can now specify where to add new columns and columns can now be re-arranged by mouse dragging.
  • Table Designer - Table Designer is now supported by SQL Projects to add or modify database schema without need to be connected to a server instance.
  • Query Plan Viewer - Smart plan comparison is now available. Can now compare execution plans and view detailed differences between plans in the Properties Table.
  • Query Plan Viewer - Added toggle button to switch between estimated and actual execution plans.
  • Query Plan Viewer - Query Plan now comes with improved precision to operator costs for larger plans.
  • MongoDB Extension for Azure Cosmos DB (Preview) - This extension introduces support for access to Mongo resources for Cosmos DB.
  • Bug Fixes:
  • Table Designer - Fixed issue that caused app to not prompt user to save before closing.
  • Table Designer - Fixed issue that returned empty data set upon attempting to edit the first cell of a new row.
  • Table Designer - Improved resize to fit experience when zooming in on user interface as well as tab behavior issues.
  • Query Plan Viewer - Fixed bug that caused custom zoom level spinner to allow values outside valid range.
  • Schema Compare - Fixed issue with indexes not being added correctly when updating project from database.
  • Notebooks - Fixed inconsistencies with notebook cell behavior and toolbars.
  • Notebooks - Fixed issues with keyboard navigation.

New in Azure Data Studio 1.36.2 Hotfix 2 (May 20, 2022)

  • Fixed issue with execution plan zoom and operator icons
  • Updated parallelism icon direction

New in Azure Data Studio 1.36.1 (Apr 23, 2022)

  • Fixed:
  • Connection explorer is unable to retrieve tables' list Area - Object Explorer Bug
  • Increase nps survey probability

New in Azure Data Studio 1.36.0 (Apr 20, 2022)

  • General Availability of the Azure SQL Migration Extension for ADS
  • Support for .NET Interactive Notebooks Extension
  • New Table Designer Features including support for System Versioned, Graph and Memory Optomized Tables
  • Query Plan Viewer Updates includign warning and parallelism icons, the option to disable tooltips and support for opening .sqlplan files
  • Improvements in SQL Projects and Schema Compare

New in Azure Data Studio 1.35.1 (Mar 18, 2022)

  • Fix for [Excel number format #18615] (#18615)
  • Fix for [Geometry Data Type Returned as Unknown Charset in Results Grid #18630] (#18630)

New in Azure Data Studio 1.35.0 (Feb 24, 2022)

  • New Features:
  • 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:
  • 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

New in Azure Data Studio 1.34.0 (Dec 16, 2021)

  • New Features:
  • 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
  • Enhancements to diagnostics in Azure SQL Migration extension
  • Support for project build with .NET 6 in SQL Database Projects extension
  • Publish to container in SQL Database Projects extension
  • Undo and redo support for notebook cell-level operations
  • Extension Updates:
  • Azure SQL Migration
  • Langpacks
  • SQL Database Projects
  • Bug Fixes:
  • Fix for multiple database migrations when using network share as backup files location in Azure SQL Migration extension
  • Fix for multiple database migrations when using blob storage containers as backup files location in Azure SQL Migration extension
  • Fix to pre-populate target database names in the migration wizard in Azure SQL Migration extension
  • Fix to column sorting in grids where the presence of null values could lead to unexpected results
  • Fix for Python upgrades when two or more notebooks were open

New in Azure Data Studio 1.33.1 (Nov 4, 2021)

  • New Notebook Features:
  • WYSIWYG link improvements
  • Extension Updates:
  • Import
  • Langpacks
  • Schema Compare
  • Sql Database Projects
  • Bug Fixes
  • Fix Notebook performance updates

New in Azure Data Studio 1.33.0 (Oct 28, 2021)

  • New Notebook Features:
  • Notebook Views
  • Split cell support
  • Keyboard shortcuts for Markdown Toolbar Cells
  • 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
  • Book improvements:
  • Add a new section
  • Drag and Drop
  • Extension Updates:
  • Import
  • Langpacks
  • Schema Compare
  • Sql Database Projects
  • Bug Fixes:
  • Notebook linking improvements
  • Horizontal Scrollbar improvement (when word wrap is off in MD Splitview / MD mode) in Notebooks
  • Vertical Scrollbar improvement for MD Splitview in Notebooks

New in Azure Data Studio 1.32.0 (Aug 18, 2021)

  • Extension Updates:
  • Arc/Az CLI extensions - Azure Arc extension now uses Azure CLI instead of Azure Data CLI for deploying and interacting with Azure Arc instances
  • Langpacks
  • SQL Database Projects
  • Azure Monitor
  • Machine Learning

New in Azure Data Studio 1.31.1 (Jul 29, 2021)

  • Hotfix release:
  • Fix for #16436 Database Connection Toolbar Missing
  • What's new in this version
  • New Notebook Features:
  • WYSIWYG link improvements
  • Extension Updates:
  • Import
  • SandDance
  • SQL Database Projects
  • Bug Fixes:
  • Accessibility bug fixes
  • Fix SQL/Notebook editors opening as plaintext

New in Azure Data Studio 1.31.0 (Jul 21, 2021)

  • What's new in this version
  • New Notebook Features:
  • WYSIWYG link improvements
  • Extension Updates:
  • Import
  • SandDance
  • SQL Database Projects
  • Bug Fixes
  • Accessibility bug fixes

New in Azure Data Studio 1.30.0 (Jun 18, 2021)

  • New:
  • 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.
  • Added a status bar item to show summary of the selected cells if there are multiple numeric values
  • Notebooks:
  • Added new book icon
  • Notebook URI Handler File Support
  • Python:
  • Updated Python to 3.8.10
  • Bug fixes:
  • Notebooks:
  • Fixed WYWIWYG Table cell adding new line in table cell
  • Fixed issue that Kusto notebook does not change kernels properly

New in Azure Data Studio 1.29.0 (May 19, 2021)

  • Release status: General Availability
  • Extension Updates:
  • SQL Database Projects
  • Schema Compare
  • Bug Fixes

New in Azure Data Studio 1.28.0 (Apr 17, 2021)

  • New Notebook Features:
  • Added Add Notebook and Remove Notebook commands
  • Extension Updates:
  • SQL Database Projects
  • Schema Compare
  • Bug Fixes

New in Azure Data Studio 1.27.0 (Mar 18, 2021)

  • New Notebook Features:
  • Added create book dialog
  • Extension Updates:
  • Import
  • Dacpac
  • Machine Learning
  • SQL Assessment
  • Arc
  • SQL Database Projects
  • ASDE Deployment
  • Bux Fixes

New in Azure Data Studio 1.26.1 (Feb 26, 2021)

  • Fixes #14382 (Since the upgrade to 1.26.0 I can no longer connect to any server.)

New in Azure Data Studio 1.26.0 (Feb 23, 2021)

  • 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
  • Extension Updates:
  • Azure Arc
  • Multiple data controllers now supported
  • New connection dialog options like kube config file
  • Postgres dashboard enhancements
  • Azure Data CLI
  • Kusto
  • Machine Learning
  • Profiler
  • Server Reports
  • Schema Compare
  • SQL Server Dacpac
  • SQL Database Projects

New in Azure Data Studio 1.25.2 (Jan 23, 2021)

  • Fixes #13899

New in Azure Data Studio 1.25.1 (Dec 11, 2020)

  • Hotfix release:
  • Fixes Mac upgrade to 1.25.0 broke connections
  • What's new in this version:
  • Kusto extension improvements
  • SQL Project extension improvements
  • Notebook improvements
  • Azure Browse Connections Preview performance improvements
  • Bug Fixes

New in Azure Data Studio 1.25.0 (Dec 10, 2020)

  • Kusto extension improvements
  • SQL Project extension improvements
  • Notebook improvements
  • Azure Browse Connections Preview performance improvements
  • Bug Fixes

New in Azure Data Studio 1.24.0 (Nov 12, 2020)

  • What's new in this version:
  • SQL Project improvements
  • Notebook improvements, including in WYSIWYG editor enhancements
  • Azure Arc improvements
  • Azure SQL Deployment UX improvements
  • Azure Browse Connections Preview
  • Bug Fixes

New in Azure Data Studio 1.23.0 (Oct 14, 2020)

  • Release date: October 14, 2020
  • Release status: General Availability
  • Added deployments of Azure SQL DB and VM
  • Added PowerShell kernel results streaming support
  • Added improvements to SQL Database Projects extension
  • Bug Fixes
  • Extension Updates:
  • SQL Server Import
  • Machine Learning
  • Schema Compare
  • Kusto
  • SQL Assessment
  • SQL Database Projects
  • Azure Arc
  • azdata

New in Azure Data Studio 1.22.1 (Sep 30, 2020)

  • Fix bug #12615 Active connection filter doesn't untoggle
  • Fix bug #12572 Edit Data grid doesn't escape special characters
  • Fix bug #12570 Dashboard Explorer table doesn't escape special characters
  • Fix bug #12582 Delete row on Edit Data fails
  • Fix bug #12646 SQL Notebooks: Cells being treated isolated

New in Azure Data Studio 1.22.0 (Sep 22, 2020)

  • Added 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.
  • Added 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.
  • 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.
  • Address issues in September 2020 Milestone
  • 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
  • Added 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
  • Added new deployment options:
  • Azure SQL Database Edge
  • (Edge will require Azure SQL Edge Deployment Extension)

New in Azure Data Studio 1.20.1 (Jul 17, 2020)

  • Fix bug #11372 Object Explorer drag-and-drop table incorrectly wraps table names
  • Fix bug #11356 Dark theme is now the default theme

New in Azure Data Studio 1.20.0 (Jul 15, 2020)

  • Feature Tour
  • Drag and drop columns and tables into Query Editor
  • Azure Account icon added to Activity Bar
  • Address issues in July 2020 Milestone
  • Bug fixes
  • New Notebook Features:
  • Header support in Markdown Toolbar
  • Side-by-side Markdown preview in Text Cells

New in Azure Data Studio 1.19.0 (Jun 15, 2020)

  • Address issues in https://github.com/microsoft/azuredatastudio/milestone/55?closed=1
  • Bug fixes

New in Azure Data Studio 1.18.1 (May 27, 2020)

  • Hotfix for #10538
  • Hotfix for #10537

New in Azure Data Studio 1.18.0 (May 20, 2020)

  • Announcing Redgate SQL Prompt extension
  • Announcing the new machine learning extension
  • Added new Python dependencies wizard
  • Added support for parameterization for Always Encrypted
  • Improvements to the notebook markdown toolbar
  • Bug fixes

New in Azure Data Studio 1.17.0 (Apr 30, 2020)

  • 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.

New in Azure Data Studio 1.16.0 (Mar 18, 2020)

  • Postgres extension update - Users can now authenticate to Azure Postgres servers with their linked Azure account
  • Accessibility bugs
  • VS Code merge
  • In the next release, GitHub releases will no longer contain the binary files to the latest version. Rather, they will contain links to the latest release. This will have no impact on users using the in-app update functionality.
  • Notebooks:
  • Charting
  • Creating Jupyter books

New in Azure Data Studio 1.15.1 (Feb 20, 2020)

  • What's new in this version:
  • Resolved #9145 Edit Data render the result grid incorrectly when using custom query.
  • Resolved #9149 Show Active Connections.

New in Azure Data Studio 1.15.0 (Feb 13, 2020)

  • 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.

New in Azure Data Studio 1.14.1 (Dec 27, 2019)

  • Hotfix for 1.14.0 bug #8747
  • Added bigdatacluster.ignoreSslVerification setting to allow ignoring SSL verification errors when connecting to a BDC #8129
  • Changed attach to connection dropdown in Notebooks to only list the currently active connection #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.

New in Azure Data Studio 1.14.0 (Dec 19, 2019)

  • Added bigdatacluster.ignoreSslVerification setting to allow ignoring SSL verification errors when connecting to a BDC #8129
  • Changed attach to connection dropdown in Notebooks to only list the currently active connection #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.

New in Azure Data Studio 1.13.1 (Nov 15, 2019)

  • Fix bug #8210 Copy/Paste results are out of order

New in Azure Data Studio 1.13.0 (Nov 4, 2019)

  • General Availability release for Schema Compare and DACPAC extensions
  • Resolved bugs and issues.

New in Azure Data Studio 1.12.2 (Oct 11, 2019)

  • Announcing the Query History extension
  • Improved Query Results Grid copy selection support
  • TempDB page added to Server Reports extension
  • PowerShell extension update
  • Announcing the Simple Data Scripter extension
  • Resolved bugs and issues.

New in Azure Data Studio 1.12.1 (Oct 8, 2019)

  • What's new in this version:
  • Announcing the Query History extension
  • Improved Query Results Grid copy selection support
  • TempDB page added to Server Reports extension
  • PowerShell extension update
  • Announcing the Simple Data Scripter extension
  • Resolved bugs and issues.

New in Azure Data Studio 1.12.0 (Oct 2, 2019)

  • Announcing the Query History extension
  • Improved Query Results Grid copy selection support
  • TempDB page added to Server Reports extension
  • PowerShell extension update
  • Announcing the Simple Data Scripter extension
  • Resolved bugs and issues.

New in Azure Data Studio 1.11.0 (Sep 10, 2019)

  • Resolved bugs and issues.

New in Azure Data Studio 1.10.0 (Aug 16, 2019)

  • What's new:
  • SandDance integration — A new way to interact with data. Download the extension here
  • Notebook improvements
  • Better loading performance
  • Ability to right click SQL results grid to save your results as CSV, JSON, etc.
  • Buttons to add code or text cells in-line
  • Other fixes and improvements
  • SQL Server Dacpac extension can support Azure Active Directory authentication
  • Updated SQL Server 2019 extension
  • Visual Studio Code May Release Merge 1.37 - this includes changes from 1.36 and 1.37
  • Resolved bugs and issues.

New in Azure Data Studio 1.9.0 (Jul 11, 2019)

  • Release of SentryOne Plan Explorer Extension
  • Visual Studio Code May Release Merge 1.35 - the latest improvements can be found here
  • Resolved bugs and issues.
  • SQL Server 2019 Support
  • New Language Packs Available
  • Schema Compare fixes and improvements:
  • Schema Compare File Support (.SCMP)
  • Cancel support
  • Other fixes and improvements
  • Notebooks Improvements:
  • Plotly Support
  • Open Notebook from Browser
  • Python Package Management
  • Performance & Markdown Enhancements
  • Improved Keyboard Shortcuts
  • Other fixes and improvements
  • SQL Server Profiler Improvements:
  • Filtering by Database Name
  • Copy & Paste Support
  • Save/Load Filter

New in Azure Data Studio 1.8.0 (Jun 7, 2019)

  • What's new in this version:
  • Initial release of the Database Admin Tool Extensions for Windows Preview extension
  • Initial release of the Central Management Servers extension
  • Schema Compare
  • 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
  • Messages panel moved into results panel - when users ran SQL queries, results and messages were in stacked panels. Now they are in separate tabs in a single panel similar to SSMS.
  • Notebook
  • 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 and fixes here
  • Visual Studio Code May Release Merge 1.34 - the latest improvements can be found here
  • Resolved bugs and issues.

New in Azure Data Studio 1.7.0 (May 8, 2019)

  • Announcing Schema Compare Preview extension
  • Tasks Panel UX improvement
  • Announcing new Welcome page
  • Resolved bugs and issues.

New in Azure Data Studio 1.6.0 (Apr 18, 2019)

  • Unified Azure Explorer connection experience
  • Align with latest VS Code editor platform (currently 1.33.1)
  • Resolved bugs and issues.

New in Azure Data Studio 1.5.2 (Mar 23, 2019)

  • Announcing T-SQL Notebooks
  • Announcing PostgreSQL extension
  • Announcing SQL Server Dacpac extension
  • Resolved bugs and issues.

New in Azure Data Studio 1.5.1 (Mar 19, 2019)

  • Announcing T-SQL Notebooks
  • Announcing PostgreSQL extension
  • Announcing SQL Server Dacpac extension
  • Resolved bugs and issues.

New in Azure Data Studio 0.33.7 Preview (Sep 19, 2018)

  • Query Results Grid performance and UX improvements for large number of result sets
  • VS Code 1.26.1 source code refresh with Grid Layout and Improved Settings Editor (Preview)
  • Accessibility improvements for screen reader, keyboard navigation and high-contrast
  • Connection name option to provide a alternative display name in the Servers viewlet

New in Azure Data Studio 0.33.6 Preview (Sep 18, 2018)

  • Query Results Grid performance and UX improvements for large number of result sets
  • VS Code 1.26.1 source code refresh with Grid Layout and Improved Settings Editor (Preview)
  • Accessibility improvements for screen reader, keyboard navigation and high-contrast
  • Connection name option to provide a alternative display name in the Servers viewlet

New in Azure Data Studio 0.33.5 Preview (Sep 14, 2018)

  • Add OE node refresh API method (#2578)
  • Use latest slickgrid library (#2584)
  • Maintain Query State (#2571)
  • Accessibility setting based select database dropdown (#2579)
  • Added context to chart buttons so they work (#2575)
  • Disabled connection name input when connecting to a server. (#2566)
  • Fix the connection issue when opening new query after connection (#2561)

New in Azure Data Studio 0.33.4 Preview (Sep 13, 2018)

  • Query Results Grid performance and UX improvements for large number of result sets
  • VS Code 1.26.1 source code refresh with Grid Layout and Improved Settings Editor (Preview)
  • Accessibility improvements for screen reader, keyboard navigation and high-contrast
  • Connection name option to provide a alternative display name in the Servers viewlet

New in Azure Data Studio 0.33.3 Preview (Sep 12, 2018)

  • Note: insiders builds are produced directly off master. They provide access to the latest bug fixes and improvements. They may also have more bugs in some areas. For the latest stable build checkout the August Public Preview release.
  • The September release is focused on stabilization of the core Connection, Query Editor and Object Explorer feature areas. The Query Editor has been improved to better support SQL scripts that produce a large number of result sets. The Visual Studio Code 1.26.1 source code refresh brings many new features such as grid layout and improved settings editor.
  • Query Results Grid performance and UX improvements for large number of result sets
  • VS Code 1.26.1 source code refresh with Grid Layout and Improved Settings Editor (Preview)
  • Accessibility improvements for screen reader, keyboard navigation and high-contrast
  • Connection name option to provide a alternative display name in the Servers viewlet

New in Azure Data Studio 0.33.2 Preview (Sep 10, 2018)

  • Security: Added user setting for extension policies (#2426)
  • Remove redundant getChildren method in IModelViewTreeViewDataProvider. (#2463)
  • Change some variable names that used reserved keywords (#2457)
  • Security: Added warning for all vsix extensions (#2406)
  • Fix formatting on time stamps (#2456)
  • Add table options to fix column widths (#2458)
  • Fix select box's screen reader issues (#2462)
  • Pixel perfect support for buttons showing correctly in vertical mode (#2460)
  • Change the default lang in editor component to plaintext and fix sample (#2459)
  • Fix extension installation that broke in merge (#2448)
  • Change layout for gridpanel to correctly handle header size (#2452)
  • Add fix for flashing during dragging and resize drag box (#2451)
  • Enable the support for post-connection behaviors for openConnectionDialog (#2455)
  • Add css styles options to all components (#2454)
  • Fix bug where webview options weren't revived, causing URI lookup to fail (#2453)
  • Fix Extension Manager marketplace sorting (#2450)
  • Accounts: Enable notification for accounts change (#2432)
  • Add listeners to make grid the largest (#2447)
  • Fix off by one in query messages (#2446)
  • Add copy keybind (#2445)
  • Update SQL Ops to 0.33.2
  • Fix break opening SQL files (#2449)
  • Fix for findSubstr not doing URI.file(<filename>).fspath (#2441)
  • Fix dragging (#2438)
  • Add "preview features" config switch (#2334)
  • Simplify GitHub templates (#2440)
  • Fix SQLPLAN custom editor support (#2439)

New in Azure Data Studio 0.31.3 Preview (Jul 16, 2018)

  • The July release will focus on the initial release of the SQL Server Agent configuration scenarios, SQL Server Profiler session and view template enhancements, and continued bug fixes for customer reported GitHub issues.
  • SQL Server Agent for SQL Operations Studio extension improvements
  • SQL Server Profiler for SQL Operations Studio extension improvements
  • Fix GitHub Issues:
  • #728 No response to Add Connection on macOS
  • #1718 Unable to connect to any datasource
  • #1713 Number of rows affected
  • #1843 Better Table organisation
  • #1847 MFA Login to Azure SQL Databases
  • #1845 Bug Scroll change tab query
  • #1612 Results grid text display is messed up by international characters
  • #1749 BUG: HTML data in a column gets interpreted
  • #1830 Setting iconPath in ButtonComponent after component() is called does not change icon
  • #1789 Extensibility: if you add a connection provider uninstall will never remove it from the list
  • #1799 Top 10 DB Size chart does not work on case sensitive instances
  • #1724 Extension dialogs have stopped working
  • #1719 TypeError when Connecting to Server
  • #1693 Backup dialog: File browser UI is broken
  • #1817 Error de Ortografia
  • #1791 Sqlops Extensions: queryeditor.connect() connects to the target database, but UI does not show the editor is connected
  • #1814 sqlops.d.ts typo causing implicit 'any' type definition
  • SQL Server Agent for SQL Operations Studio improvements:
  • The SQL Server Agent for SQL Operations Studio extension has the following improvements available in this build.
  • Operators, Alerts and Proxies dashboard panel views
  • "Test build" dialogs for some SQL Agent objects. These dialogs will be improved in subsequent July insiders builds.

New in Azure Data Studio 0.31.2 Preview (Jul 7, 2018)

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

New in Azure Data Studio 0.31.1 Preview (Jul 1, 2018)

  • The July release will focus on the initial release of the SQL Server Agent configuration scenarios, SQL Server Profiler session and view template enhancements, and continued bug fixes for customer reported GitHub issues.
  • SQL Server Agent for SQL Operations Studio extension improvements
  • Fix GitHub Issues
  • #728 No response to Add Connection on macOS
  • #1718 Unable to connect to any datasource

New in Azure Data Studio 0.30.6 Preview (Jun 20, 2018)

  • 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 integrating March 2018 (1.22) and April 2018 (1.23) releases
  • Fix GitHub Issues:
  • #1204 Feature request: Please make the results grid auto-fit column width to data, and/or remember manual changes if the same query is re-run
  • #1398 Should show add message and add account account button when linked account is empty
  • #1399 Linked account tab is broken when the view is collapsed
  • #1374 SQL Tools Service crashes when opening .sql file from disk
  • #1372 Missing SQL keyword "BETWEEN"
  • #1395 'MATCH' keyword crashes SQL Tools Service
  • #1496 "New Profiler" context menu option in Object Explorer does nothing.
  • #1495 Query editor "Explain" query plan is broken

New in Azure Data Studio 0.29.3 Preview (May 7, 2018)

  • The May release is focused on stabilization and bug fixes leading up to the Build conference. This build contains the following highlights:
  • 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!
  • GDPR-compliant build has reduced telemetry collection, improved opt-out experience and in-product links to Privacy Statement
  • Extension Manager has improved Marketplace experience to easily discover community extensions
  • SQL Agent extension Jobs and Job History view improvement
  • Updates for whoisactive and Server Reports extensions
  • Fix GitHub Issues
  • 703 Entering HTML-like text in edit data causes value to display incorrectly until refresh
  • 821 sqlopsstudio.deb package dependency
  • 1260 keyword 'distinct' not highlighted
  • 1332 Edit data revert row doesn't work
  • 1215 SQL Agent extension and the status bar
  • 1316 SQL Agent Don´t resize after change windows size
  • Improve Manage Dashboard Properties scrolling
  • Announcing Redgate SQL Search extension:
  • Redgate SQL Search in SQL Operations Studio extension is now available in the Extension Manager Marketplace! Redgate SQL Search lets you find database objects across all databases in the active connection. From the search results it's simple to jump to the object in the Object Explorer or to view the object's definition.
  • We definitely recommend installing this extension. As SQL Ops Studio evolves we'll rely heavily on extensions to provide core functionality, so we expect that most users will want to have several extensions installed for the best experience.
  • Community Localization available:
  • Community Localization resources for German, Spanish, French, Italian, Japanese, Korean, Portuguese, Russian, Simplified Chinese and Traditional Chinese are available for the May Public Preview. We'll continue working over the next couple months to get the product 100% localized.
  • GDPR compliance:
  • There are several updates in May Public Preview that were needed for GDPR compliance. Specifically we reduced the telemetry being collected, improved the opt-out experience by adding a notification on first launch and added a Privacy Statement item to the Help menu.
  • Extension Manager enhancements:
  • The Extension Manager Recommended section has been replaced with a Marketplace section. The Marketplace will display all available extensions. Recommended extensions are sorted to the top.
  • Startup Performance improvements:
  • We want SQL Operations Studio to be fast and efficient to maximize user productivity. Reducing the time it takes to launch SQL Ops Studio is one of the key scenarios where we've been making continual investments. Fortunately our upstream platform, Visual Studio Code, is also optimizing this same scenario. One key improvement we merged from VS Code's February release was ASAR Node module bundling.
  • We use product telemetry from the Startup scenario to understand how long users are waiting for SQL Ops Studio to launch. This telemetry allowed us to confirm that the April Public Preview delivered approximately 30%-40% startup time improvements for most users. Particularly users experiencing the slowest startups have seen the largest improvements.
  • The below chart shows startup times bucketed into key percentiles: 25%, 50%, 75%, 90%, 95%, 98%, 99%. This means, for example, at the 50% bucket half the startups were faster than that time and half the startups were slower than that time.

New in Azure Data Studio 0.28.6 Preview (Apr 25, 2018)

  • The April Public Preview 0.28.6 release contains several additional bug fixes and improvements. Checkout the release notes for the 0.28.1 build to see all the core editor and workbench improvements delivered through the Visual Studio Code 1.21 platform source code refresh.
  • Highlights for this build include the following:
  • Improvements to SQL Agent Preview extension
  • Accessibility improvements for keyboard navigation, screen reader support and high-contrast mode.
  • Improved large and protected file support for saving Admin protected and >256M files within SQL Ops Studio
  • Integrated Terminal splitting to work with multiple open terminals at once
  • Reduced installation on-disk file count foot print for faster installs and startup times
  • Improvements to Server Reports extension
  • Continue to fix GitHub issues
  • #37 When the chart viewer throws an error, unexpected behavior occurs.
  • #462 Feature Request: Option for Server Groups to be expanded by default
  • #1023 Add square brackets for ms_foreachdb call from flyfishingdba
  • #1050 Clear insights view before showing error
  • #1057 Restore and new query actions in explorer-widget are broken
  • #1068 Dashboard Output windows pops-up with error message for Azure DB
  • #1069 Connection Dialog shows Server Required error when initially displayed
  • #1070 Server Groups now require a double-click to expand
  • #1072 Select control background is semi-transparent
  • #1115 Fix all high contrast accessibility issues in sqlops
  • #1101 Extension fails to upgrade "Download Manually" link goes to wrong location
  • #1103 V Scroll not working on Home Tab
  • #1104 SQL extension tabs stopped working
  • #967: Expect query plan when select XML showplan in the result grid
  • #606 intellisense - Bad suggestion for 'update' command
  • #1048 Pre-login SSL/TLS handshake error
  • #1150 Various types of query charts throw exceptions and don't render
  • SQL Agent for SQL Operations Studio Preview extension:
  • Since SQL Operations Studio was released for Public Preview, one of the most requested features was providing SQL Agent support. Bringing over the most popular SSMS features has always been on our roadmap, but we wanted to make sure we did this the right way. With SQL Operations Studio, we had an opportunity to bring a modern user experience to our features while maintaining the same functionality that our users are experts with.
  • Please try out our early SQL Agent Preview extension. In this initial release we've focused on Jobs List and Job History scenarios. Configuration scenarios to create Jobs, Operators, Alerts and Schedules will be coming in future releases.

New in Azure Data Studio 0.27.3 Preview (Mar 28, 2018)

  • Tabs should fill entire panel
  • Go back to using VS Code's tab close icons

New in Azure Data Studio 0.26.7 Preview (Feb 17, 2018)

  • 0.26.7 takes an additional update to address #717

New in Azure Data Studio 0.26.6 Preview (Feb 15, 2018)

  • Here's some of the highlights in the February release:
  • Support Auto-Update installation on Windows and macOS
  • Publish RPM and DEB packages to offical Microsoft repos
  • Fix #6 Keep connection and selected database when opening new query tabs
  • Fix #22 'Server Name' and 'Database Name' - Can these be drop downs instead of text boxes?
  • Fix #481 Add "Check for updates" option.
  • Introduce Connection extensibility API
  • VS Code Editor 1.19 integration
  • Update JustinPealing/html-query-plan component to pick-up several Query Plan viewer improvements
  • SQL Editor colorization and auto-completion fixes:
  • #584 Keyword "FULL" not highlighted by IntelliSense
  • #345 Colorize SQL functions within the editor
  • #300 [#tempData] latest "]" will display green color
  • #225 Keyword color mismatch
  • #60 invalid sql syntax color highlighting when using temporary table in from clause

New in Azure Data Studio 0.25.4 Preview (Jan 17, 2018)

  • Fix #494 Connection error when connecting to an Azure SQL Server with no firewall rule (#497)
  • Update changelog and readme for Jan release (#496)
  • Open-url changes
  • Bump SQL Ops to 0.25.4 for next Jan release candidate build (#483)
  • Add cursor snippet (#475)
  • Fix update package download paths (#476)
  • Enable hot exit for saved files (#469)

New in Azure Data Studio 0.24.1 Preview (Dec 19, 2017)

  • Azure Integration with Create Firewall Rule
  • Windows Setup, Linux DEB and Linux RPM installation packages
  • Manage Dashboard visual layout editor
  • Script As Alter and Script As Execute commands
  • Integrate VS Code 1.18.1 editor platform
  • Enable Sideloading of VSIX Extension files
  • Support "GO N" batch iteration syntax
  • "Run Current Query with Actual Plan" command
  • Delete Recent Connection command in Connection Dialog
  • Performance fixes for Object Explorer expansion and Scripting sprocs
  • Fix IntelliSense settings namespace to be mssql.*
  • Only show Disconnect menu item if server is connected
  • Several snippet and default widget improvements
  • Improve Kerberos connection failure error message
  • Add command to hide query results window after running query
  • Retain cursor line positon when switching document tabs
  • Keep cursor focus in editor window after executing query
  • Support shortcuts to execute common queries like sp_who or sp_help
  • Fix tab order behavior when using keyboard to navigate dialog controls
  • Improved chart axis and label behavior
  • Allow expanding databases not in certain non-Online states
  • Connection Dialog selects most common default authentication method based on platform