{"id":25792,"date":"2019-01-09T11:00:54","date_gmt":"2019-01-09T19:00:54","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=25792"},"modified":"2024-12-23T10:05:54","modified_gmt":"2024-12-23T18:05:54","slug":"the-january-release-of-azure-data-studio-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/","title":{"rendered":"The January release of Azure Data Studio"},"content":{"rendered":"\n<p><strong>We are excited to announce the January release of <a href=\"https:\/\/github.com\/microsoft\/azuredatastudio\">Azure Data Studio<\/a> (formerly known as SQL Operations Studio) is now available.<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/download\">Download Azure Data Studio<\/a>&nbsp;and review the <a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/release-notes\">Release Notes<\/a> to get started.<\/p>\n\n\n\n<p>Note: If you are currently using the preview version, SQL Operations Studio, and would like to retain your settings when upgrading to the latest version, please <a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/download#move-user-settings\">follow these instructions.<\/a> After downloading Azure Data Studio, click &#8220;Yes&#8221; to enable preview features so that you can use extensions.<\/p>\n\n\n\n<p>Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premise and cloud data platforms on Windows, MacOS, and Linux. To learn more, <a href=\"https:\/\/github.com\/microsoft\/azuredatastudio\">visit our GitHub.<\/a><\/p>\n\n\n\n<p>Azure Data Studio was announced Generally Available at Microsoft Ignite 2018. If you missed it, you can view that <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/\">GA announcement here.<\/a> You won\u2019t want to miss the great orthogonality matrix that compares SQL Server Management Studio (SSMS) and Azure Data Studio, and it may provide answers to many of your questions.<\/p>\n\n\n\n<p>The key highlights for the January release include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Azure Active Directory Authentication support<\/li>\n\n\n\n<li>Announcing Data-Tier Application Wizard support<\/li>\n\n\n\n<li>Announcing IDERA SQL DM Performance Insights (Preview)<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/sql-server-2019-extension?view=sql-server-ver15\">Updates to the SQL Server 2019 Preview extension<\/a><\/li>\n\n\n\n<li>SQL Server Profiler improvements<\/li>\n\n\n\n<li>Preview: results streaming for large queries<\/li>\n\n\n\n<li>User setup installation support<\/li>\n\n\n\n<li>Bug fixes<\/li>\n<\/ul>\n\n\n\n<p>For a complete list of updates, refer to the <a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/release-notes\">Release Notes.<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"azure-active-directory-authentication-support\">Azure Active Directory Authentication support<\/h2>\n\n\n\n<p>When Azure Data Studio was announced for Public Preview in November 2017, we received many requests and upvotes for features users wanted to see in Azure Data Studio. What turned out to be the third most upvoted feature request was Azure Active Directory (AAD) support, and we are excited to announce that AAD is now supported in Azure Data Studio.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD.webp\" alt=\"Screenshot of Feature Request for Azure Active Directory Authentication\" class=\"wp-image-25795 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD.webp 1039w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-300x124.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-1024x425.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-768x319.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-330x137.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-800x332.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-400x166.webp 400w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD.png\" data-orig-srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD.png 1039w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-300x124.png 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-1024x425.png 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-768x319.png 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-330x137.png 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-800x332.png 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Feature-request-AAD-400x166.png 400w\"><\/figure>\n\n\n\n<p>Thanks&nbsp;to feedback from our user community from testing our insider builds, we have made it easier for you to connect with AAD. To see AAD in action, view the gif below.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"571\" height=\"671\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/aad_gif.gif\" alt=\"GIF screenshot of AAD connect\" class=\"wp-image-25798\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>For Azure SQL Database and SQL Data Warehouse users who require AAD, you can now get started with using Azure Data Studio. We challenge you to make a connection with AAD and try our Quickstarts for <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/quickstart-sql-database?view=sql-server-2017\">Azure SQL Database<\/a> and <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/quickstart-sql-dw?view=sql-server-2017\">Azure SQL Data Warehouse.<\/a> If there are feature gaps, you can file an issue on our <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\">Issues page.<\/a><\/p>\n\n\n\n<p>With the release of AAD, we made it a priority to release this feature as soon as dependencies in .NET Core were available.&nbsp;Thank you to our user community for helping us prioritize this feature through <a href=\"https:\/\/twitter.com\/azuredatastudio\">Twitter<\/a>, GitHub, sqlcommunity Slack channel, and at conferences for this feature.<\/p>\n\n\n\n<p>A more immediate way to let us know the importance of your feature request is to look for <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues?q=is%3Aissue+is%3Aopen+sort%3Areactions-%2B1-desc\">an existing issue on this list<\/a> and encourage your coworkers, colleagues, and friends on social media to give a thumbs up on the issue, or blog about it. Even better\u2014comment about what scenarios this feature would help you with. If a feature request doesn\u2019t already exist, feel free to make it yourself. We want you to be part of the journey for this product.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"announcing-data-tier-application-wizard-support\">Announcing Data-Tier Application Wizard support<\/h2>\n\n\n\n<p>Speaking of top customer feature requests, we have also added preview support for the Data-Tier Application Wizard used in SSMS, which is currently among the top 10 most requested features.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/wizard-support-update.webp\" alt=\"a screenshot of a cell phone\" class=\"wp-image-25804 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/wizard-support-update.webp 353w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/wizard-support-update-223x300.webp 223w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/wizard-support-update-186x250.webp 186w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/wizard-support-update-260x350.webp 260w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/wizard-support-update.png\" data-orig-srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/wizard-support-update.png 353w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/wizard-support-update-223x300.png 223w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/wizard-support-update-186x250.png 186w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/wizard-support-update-260x350.png 260w\"><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>These wizards make it easier for users to manage .dacpac and .bacpac files, which simplifies the development, deployment, and management of data-tier elements that support an application. To learn more about using Data-tier applications, <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/data-tier-applications\/data-tier-applications?view=sql-server-2017\">you can read this documentation.<\/a><\/p>\n\n\n\n<p>The current experience combines the four separate wizards from SSMS into one wizard where users can choose which action they need to take. These actions include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Deploying .dacpac<\/strong> to SQL Server instance<\/li>\n\n\n\n<li><strong>Extracting SQL Server instance<\/strong> to a .dacpac<\/li>\n\n\n\n<li><strong>Creating a database<\/strong> from .bacpac<\/li>\n\n\n\n<li><strong>Exporting schema and data<\/strong> to .bacpac<\/li>\n<\/ul>\n\n\n\n<p>You can see <strong>Extract<\/strong> in action in the gif below.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1005\" height=\"531\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/dacfx_gif.gif\" alt=\"a screenshot of a cell phone\" class=\"wp-image-25807\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>In order to use this wizard, you will need to install the <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/sql-server-import-extension?view=sql-server-2017\">SQL Server Import extension.<\/a> This is included with the Import Flat File Wizard, which is also a preview experience. This extension gives you the top two most used wizards from SSMS.<\/p>\n\n\n\n<p>After downloading the extension, you can access the wizard in two ways:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Right click a database in the Object Explorer and click\u00a0<strong>Data-tier Application wizard<\/strong><\/li>\n\n\n\n<li>If you are connected to a SQL Server instance, you can also start the wizard from the command palette (Ctrl+Shift+P) by searching for\u00a0<strong>Data-tier Application wizard<\/strong><\/li>\n<\/ul>\n\n\n\n<p>As we did for SQL Server Agent and Import, we are <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\/3171\">actively seeking community feedback<\/a> on improving this experience.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub.webp\" alt=\"Screenshot of Feedback Forum on GitHub\" class=\"wp-image-25810 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub.webp 1050w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-300x106.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-1024x363.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-768x272.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-330x117.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-800x283.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-400x142.webp 400w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub.png\" data-orig-srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub.png 1050w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-300x106.png 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-1024x363.png 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-768x272.png 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-330x117.png 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-800x283.png 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-feedback-forum-on-GitHub-400x142.png 400w\"><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>If you are interested in having a chat about this experience to help out your team, feel free to reach out on GitHub or email <a>yu.alan@microsoft.com<\/a>.<\/p>\n\n\n\n<p>&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"introducing-the-idera-extension-sql-dm-performance-insights-preview-extension\">Introducing the IDERA extension SQL DM Performance Insights (Preview) extension<\/h2>\n\n\n\n<p>As part of the roadmap for Azure Data Studio, we&#8217;re finding ways to empower our partners to build extensions with our extensibility model. To show the progress we&#8217;re making on our extensibility, we are excited to announce the new IDERA extension.<\/p>\n\n\n\n<p>IDERA SQL DM Performance Insights is an Azure Data Studio (ADS) extension that will display key performance metrics for SQL Server that have been collected and stored in a database repository by <a href=\"https:\/\/nam06.safelinks.protection.outlook.com\/?url=https%3A%2F%2Fwww.idera.com%2Fproductssolutions%2Fsqlserver%2Fsqldiagnosticmanager&amp;data=02%7C01%7Cv-kartie%40microsoft.com%7C3b9f2372c26043975dee08d674f9d487%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636825013696612887&amp;sdata=F2Aj8J8bjiM6uDlmLWHFfFbMV3IltQewBVc%2B4wNwGZc%3D&amp;reserved=0\">IDERA\u2019s SQL Diagnostic Manager<\/a>, a powerful performance monitoring, alerting, and diagnostics solution for SQL Server that proactively notifies administrators to health, performance, or availability problems via a desktop console, web console add-on, or mobile device.<\/p>\n\n\n\n<p>This extension is a free add-in for Azure Data Studio that quickly allows you to see high level aggregated performance issues across multiple servers monitored by SQL Diagnostic Manager.<\/p>\n\n\n\n<p>This preview provides the following features:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Servers<\/strong>: Display metrics such as CPU, Disk I\/O, network, and memory used<\/li>\n\n\n\n<li><strong>Sessions<\/strong>: Display session summary averages such as client connections, logins, user processes, transactions, and oldest open transactions<\/li>\n\n\n\n<li><strong>Databases<\/strong>: Display database summary-related statistics such as reads, writes, transactions, and log activity at the server level, as well as database statistical averages at the database level<\/li>\n\n\n\n<li><strong>Queries<\/strong>: Display wait statistics and summaries of query statistics<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera.webp\" alt=\"a screenshot of a social media post\" class=\"wp-image-26074 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera.webp 854w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera-300x189.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera-768x485.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera-330x208.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera-800x505.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera-400x252.webp 400w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera.jpg\" data-orig-srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera.jpg 854w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera-300x189.jpg 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera-768x485.jpg 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera-330x208.jpg 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera-800x505.jpg 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/01\/idera-400x252.jpg 400w\"><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>This extension is free and will be supported through the <a href=\"https:\/\/nam06.safelinks.protection.outlook.com\/?url=http%3A%2F%2Fcommunity.idera.com%2Ffree-tool-forums%2Ff%2Fidera-sql-dm-performance-insights&amp;data=02%7C01%7Cv-kartie%40microsoft.com%7C3b9f2372c26043975dee08d674f9d487%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636825013696622895&amp;sdata=667jDlTNGVIJjXqy%2BaAUfQ124G4SHKlzJmK7nPtpypI%3D&amp;reserved=0\">IDERA Community Free Tools<\/a>.<\/p>\n\n\n\n<p>With partners joining our marketplace, if you are also interested in joining our extension marketplace or are curious about how to get started, feel free to contact me at&nbsp;<a href=\"mailto:yu.alan@microsoft.com\">yu.alan@microsoft.com<\/a>&nbsp;to get started.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"sql-server-2019-preview-extension\">SQL Server 2019 Preview extension<\/h2>\n\n\n\n<p>Since announcing the Public Preview of SQL Server 2019 at Ignite, we are continuing to make updates to the SQL Server 2019 extension in Azure Data Studio, including improvements in the <a href=\"https:\/\/docs.microsoft.com\/sql\/big-data-cluster\/notebooks-guidance?view=sqlallproducts-allversions\">Azure Data Studio Notebooks<\/a> and the <a href=\"https:\/\/docs.microsoft.com\/sql\/relational-databases\/polybase\/data-virtualization?toc=%2fsql%2fbig-data-cluster%2ftoc.json&amp;view=sqlallproducts-allversions\">Create External Data Wizard.<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"azure-data-studio-notebooks\">Azure Data Studio Notebooks<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The Notebook view UI has moved into Azure Data Studio core. This improves performance when loading and updating a notebook, including Jupyter notebook compatibility.<\/li>\n\n\n\n<li>The PROSE python package has been updated to 1.2.1 and includes a number of bug fixes. Use the Reinstall Notebook Dependencies command\u00a0in the command palette to update this package.<\/li>\n\n\n\n<li>Cells have a simpler look with just one Run Cell button on the action bar, a real context menu with additional actions on the right of the cell. You can also double-click to edit support on Markdown cells.<\/li>\n\n\n\n<li>A Notebook API is in progress. This is included in the proposed API file for Azure Data Studio. As this feature is in active development, we expect some APIs to change, but these can be used to perform basic operations on a Notebook &#8211; Open New\/Existing Notebook, query contents, add cells, etc.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"create-external-data-wizard\">Create External Data Wizard<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A new wizard to create external data sources from HDFS files\/folders in SQL Server 2019 big data clusters has been added.<\/li>\n\n\n\n<li>Support for mapping SQL Server and Oracle Views has been added to the existing Create External Data wizard.<\/li>\n\n\n\n<li>Performance and reliability fixes for the existing wizard were also added.<\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/nam06.safelinks.protection.outlook.com\/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fazure-data-studio%2Fsql-server-2019-extension%3Fview%3Dsql-server-ver15&amp;data=02%7C01%7Cv-kartie%40microsoft.com%7C03a18789c5d14ef60a5b08d660659cfc%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636802386871649263&amp;sdata=wffHUqtu%2FY6UTfc4CWxsxYIwIq2RigDYDNNKyJwb4nk%3D&amp;reserved=0\">Follow these instructions<\/a><a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/sql-server-2019-extension?view=sql-server-ver15\"> to download the extension and view the release notes.<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"sql-server-profiler-improvements\">SQL Server Profiler Improvements<\/h2>\n\n\n\n<p>We know the user community has been asking for a better Profiler experience. While&nbsp;working with Julie Lerman on her <u><a href=\"https:\/\/msdn.microsoft.com\/magazine\/mt832858\">MSDN magazine article<\/a><\/u>, we decided to make some investments to improve the Profiler experience.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates.webp\" alt=\"a screenshot of a cell phone\" class=\"wp-image-25813 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates.webp 1222w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-300x117.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-1024x401.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-768x300.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-330x129.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-800x313.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-400x156.webp 400w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates.png\" data-orig-srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates.png 1222w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-300x117.png 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-1024x401.png 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-768x300.png 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-330x129.png 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-800x313.png 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Screenshot-of-Profiler-experience-updates-400x156.png 400w\"><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>To access SQL Server Profiler, you will need to <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/azure-data-studio\/sql-server-profiler-extension?view=sql-server-2017\">download the extension through the Extensions marketplace.<\/a> You can then right-click your target server and click <strong>Launch Profiler<\/strong>.<\/p>\n\n\n\n<p>In this release, <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues?q=is%3Aissue+milestone%3A%22December+Release%22+is%3Aclosed+label%3Aprofiler\">we fixed 11 bugs<\/a> which include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Consistent Text\/Details pane to pop up<\/li>\n\n\n\n<li>Fixed long time for profiler to refresh events<\/li>\n\n\n\n<li>Fixed Profiler for Azure SQL instances<\/li>\n<\/ul>\n\n\n\n<p>We also added UI updates to the toolbar to make each action or dropdown clearer that the user can change. Please let us know any feedback you have.<\/p>\n\n\n\n<p>In addition, we worked on improving the first-time experience to make it easier to launch Profiler. When you right-click a server and click Profiler, there is a default session name provided for each session template.<\/p>\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Start-new-profiler-session-screenshot.webp\" alt=\"a screenshot of a cell phone\" class=\"wp-image-25816 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Start-new-profiler-session-screenshot.webp 553w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Start-new-profiler-session-screenshot-300x115.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Start-new-profiler-session-screenshot-330x127.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Start-new-profiler-session-screenshot-400x153.webp 400w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Start-new-profiler-session-screenshot.png\" data-orig-srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Start-new-profiler-session-screenshot.png 553w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Start-new-profiler-session-screenshot-300x115.png 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Start-new-profiler-session-screenshot-330x127.png 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/Start-new-profiler-session-screenshot-400x153.png 400w\"><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>When you click start, Profiler will immediately start running. If you have any issues running Profiler, please let us know on GitHub.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"preview-results-streaming-for-large-queries\">Preview: Results streaming for large queries<\/h2>\n\n\n\n<p>In previous versions of Azure Data Studio, when a user ran large queries, no results would appear in the results grid until the query could show all of the results. This was not a great experience for our users, thus we did some investigating to improve this experience. In the latest build of Azure Data Studio, users can now see results streamed in the results grid. This makes it a better experience since users can see the results quicker and interact with their data instead of being in a waiting state.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"582\" height=\"378\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/12\/results-SQL-gif.gif\" alt=\"a screenshot of a social media post\" class=\"wp-image-25873\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>However, this is still a preview feature so it is disabled by default. To enable this feature when you are running large queries, you will need to go to File&nbsp;<span style=\"font-size: 1.4rem\">&gt; Preferences &gt; Settings,&nbsp;and&nbsp;<\/span><span style=\"font-size: 1.4rem\">Search Settings for &#8220;sql.results.streaming&#8221; and set this value to true. Then you will need to&nbsp;<\/span><span style=\"font-size: 1.4rem\">restart Azure Data Studio.<\/span><\/p>\n\n\n\n<p>Please let us know of any feedback you have for this experience, we will continue to be making investments in improving Query Editor and the&nbsp;<span style=\"font-size: 1.4rem\">results grid in the upcoming months.<\/span><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"user-setup-installation-support\">User Setup installation support<\/h2>\n\n\n\n<p>Now featured on the Azure Data Studio download page is user setup installation for Windows only. This downloads the whole executable for Azure Data Studio so you won\u2019t need admin privileges to install Azure Data Studio since the location will be under Local AppData folder. This also makes it easier to get monthly auto-updates.<\/p>\n\n\n\n<p>We encourage users to download User Setup going forward. If you are transitioning from System Setup to User Setup, you will not lose any of your settings or extensions in the process.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"bug-fixes-and-thank-yous\">Bug fixes and thank yous<\/h2>\n\n\n\n<p>If you would like to help make Azure Data Studio a great product, please share any feedback or report issues through <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\">our Issues page.<\/a> Our engineering team is regularly monitoring the untriaged issues and assigning issues into different monthly milestones so that you will know we are working on it. Your votes on issues helps us prioritize.<\/p>\n\n\n\n<p>To see the full list of bug fixes in the January release, <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/milestone\/19?closed=1\">view them here.<\/a><\/p>\n\n\n\n<p>We also want to take this time to thank many of our users who have submitted PR\u2019s or taken time to give us feedback in calls.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tarig0 for\u00a0Add Routine_Type to CreateStoredProc fixes #3257 (#3286)<\/li>\n\n\n\n<li>oltruong for\u00a0typo fix #3025&#8242;<\/li>\n\n\n\n<li>Thomas-S-B for\u00a0Removed unnecessary IErrorDetectionStrategy #749<\/li>\n\n\n\n<li>Thomas-S-B for\u00a0Simplified code #750<\/li>\n\n\n\n<li>Julie Lerman for feedback on Profiler and Import Wizard extensions, as well as writing MSDN magazine article on Azure Data Studio<\/li>\n\n\n\n<li>Dave Dustin for testing AAD, user setup, Data-Tier Application Wizard<\/li>\n\n\n\n<li>Peter Schott for feedback on AAD and Data-Tier Application Wizard<\/li>\n\n\n\n<li>Josh Booker for feedback on Data-Tier Application Wizard<\/li>\n\n\n\n<li>Constantine Kokkinos for feedback on Profiler<\/li>\n\n\n\n<li>Warwick Rudd for feedback on SQL Agent<\/li>\n\n\n\n<li>Mario Ezra for testing user setup<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"contact-us\">Contact us<\/h2>\n\n\n\n<p>If you have any feature requests or issues, please submit them to <a href=\"https:\/\/github.com\/microsoft\/azuredatastudio\/issues\">our Github issues page.<\/a> For any questions, feel free to comment below or tweet us <a href=\"https:\/\/twitter.com\/azuredatastudio\">@AzureDataStudio<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to announce the January release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio&nbsp;and review the Release Notes to get started.<\/p>\n","protected":false},"author":5562,"featured_media":25459,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5226,2542,5227,2521,2406,2536,2418],"content-type":[2448],"topic":[2466],"coauthors":[2487],"class_list":["post-25792","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure","product-azure-data-studio","product-sql","product-sql-operations","product-sql-server-2017","product-sql-server-2019","product-sql-server-on-linux","content-type-updates","topic-developer","review-flag-1593580427-503","review-flag-1593580419-556","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-free-1593619513-128","review-flag-ga-1593580755-860","review-flag-new-1593580247-437","review-flag-on-pr-1593580815-813","review-flag-publi-1593580761-761"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>The January release of Azure Data Studio - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The January release of Azure Data Studio - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to announce the January release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio&nbsp;and review the Release Notes to get started.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-09T19:00:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-23T18:05:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png\" \/>\n\t<meta property=\"og:image:width\" content=\"280\" \/>\n\t<meta property=\"og:image:height\" content=\"180\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/\"},\"author\":[{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/author\\\/sql-server-team\\\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"The January release of Azure Data Studio\",\"datePublished\":\"2019-01-09T19:00:54+00:00\",\"dateModified\":\"2024-12-23T18:05:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/\"},\"wordCount\":2009,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/Azure-Data-Studio_Blog_Thumbnail.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/\",\"name\":\"The January release of Azure Data Studio - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/Azure-Data-Studio_Blog_Thumbnail.png\",\"datePublished\":\"2019-01-09T19:00:54+00:00\",\"dateModified\":\"2024-12-23T18:05:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/Azure-Data-Studio_Blog_Thumbnail.png\",\"contentUrl\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/11\\\/Azure-Data-Studio_Blog_Thumbnail.png\",\"width\":280,\"height\":180,\"caption\":\"a close up of a sign\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/2019\\\/01\\\/09\\\/the-january-release-of-azure-data-studio-is-now-available\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The January release of Azure Data Studio\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/Microsoft-Logo.png\",\"contentUrl\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/08\\\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\\\/\\\/www.microsoft.com\\\/en-us\\\/sql-server\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"http:\\\/\\\/www.facebook.com\\\/sqlserver\",\"https:\\\/\\\/x.com\\\/SQLServer\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The January release of Azure Data Studio - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/","og_locale":"en_US","og_type":"article","og_title":"The January release of Azure Data Studio - Microsoft SQL Server Blog","og_description":"We are excited to announce the January release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio&nbsp;and review the Release Notes to get started.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2019-01-09T19:00:54+00:00","article_modified_time":"2024-12-23T18:05:54+00:00","og_image":[{"width":280,"height":180,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"8 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"The January release of Azure Data Studio","datePublished":"2019-01-09T19:00:54+00:00","dateModified":"2024-12-23T18:05:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/"},"wordCount":2009,"commentCount":2,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/","name":"The January release of Azure Data Studio - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png","datePublished":"2019-01-09T19:00:54+00:00","dateModified":"2024-12-23T18:05:54+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Azure-Data-Studio_Blog_Thumbnail.png","width":280,"height":180,"caption":"a close up of a sign"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/01\/09\/the-january-release-of-azure-data-studio-is-now-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"The January release of Azure Data Studio"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_animated_featured_image":null,"bloginabox_display_generated_audio":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/25792","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/5562"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=25792"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/25792\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media\/25459"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=25792"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=25792"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=25792"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=25792"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=25792"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=25792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}