{"id":25342,"date":"2018-11-06T14:00:45","date_gmt":"2018-11-06T22:00:45","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=25342"},"modified":"2024-12-23T10:13:12","modified_gmt":"2024-12-23T18:13:12","slug":"the-november-release-of-azure-data-studio-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/","title":{"rendered":"The November release of Azure Data Studio is now available"},"content":{"rendered":"\n<p><strong>We are excited to announce the November 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><strong>Note:<\/strong> If you are currently using the preview version, SQL Operations Studio, and would like to retain your settings when you upgrade to the latest version, <a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/download#move-user-settings\">follow these instructions.<\/a> When you download Azure Data Studio, remember to enable preview features by default at first launch, and then you can disable in settings if you don\u2019t need it otherwise. By not enabling the preview features, you will be missing preview experiences like Query Plans, certain extension support, and more.<\/p>\n\n\n\n<p>Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises 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.&nbsp; If you missed it, catch up by reading the <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/\">GA announcement on the SQL Server blog<\/a>. You won\u2019t want to miss the great orthogonality matrix included comparing SSMS and Azure Data Studio and answers to many of your questions.<\/p>\n\n\n\n<p>In November\u2019s version of the monthly release blog, the emphasis was on fixing customer issues and adding and improving existing extensions.<\/p>\n\n\n\n<p>This includes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\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>Introducing the Paste the Plan extension<\/li>\n\n\n\n<li>Introducing the High Color Queries extension<\/li>\n\n\n\n<li>Improved Logging support<\/li>\n\n\n\n<li>Bug fixes<\/li>\n<\/ul>\n\n\n\n<p>For complete 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=\"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>Adding cells before\/after existing cells is now supported by clicking the \u201cMore Actions\u201d cell button<\/li>\n\n\n\n<li>\u00a0<strong>Add New Connection<\/strong> option has been added to the connections in the \u201cAttach To\u201d drop-down<\/li>\n\n\n\n<li>\u00a0A <strong>Reinstall Notebook Dependencies<\/strong> command has been added to assist with Python package updates, and solve cases where install was halted partway through by closing the application. This can be run from the command palette (use `Ctrl\/Cmd+Shift+P` and type `Reinstall Notebook Dependencies`)<\/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>Error messages are copyable and have been separated into a summary and detailed view for easier<\/li>\n\n\n\n<li>Improved UI layout and significantly improved reliability and error handling<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"fixed-issues\">Fixed issues<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Notebook session could not start on Windows due to PATH issues<\/li>\n\n\n\n<li>Notebook could not be started from the root folder of a drive, such as C:\\ or D:\\<\/li>\n\n\n\n<li>\u00a0[#2820] <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\/2820\">Unable to edit notebooks created from ADS in VS Code<\/a><\/li>\n\n\n\n<li>Spark UI link now works when running a Spark kernel<\/li>\n\n\n\n<li>Renamed \u201cManaged Packages\u201d to \u201cInstall Packages\u201d<\/li>\n\n\n\n<li>Tables with invalid column mappings are shown as disabled and a warning explains the error<\/li>\n<\/ul>\n\n\n\n<p>To download the extension and view the full release notes, <a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/sql-server-2019-extension?view=sql-server-ver15\">follow the instructions here.<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"introducing-the-paste-the-plan-extension\">Introducing the Paste the Plan extension<\/h2>\n\n\n\n<p>In addition to the extensions mentioned above, we are always looking for great community contributed extensions. One of our most active extension authors is Drew Skwiers-Koballa, and he created an integrated experience for Brent Ozar Unlimited\u2019s <a href=\"https:\/\/www.brentozar.com\/pastetheplan\/\">Paste the Plan feature.<\/a><\/p>\n\n\n\n<p>Once you have an execution plan from a saved execution plan file, the extension allows you to open in a browser or copy to a clipboard. You can see this in the gif below from the extension ReadMe.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"1880\" height=\"954\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/OpenInBrowser.gif\" alt=\"a screen shot of a computer\" class=\"wp-image-25372\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>To learn more about the extension, <a href=\"https:\/\/github.com\/dzsquared\/sqlops-pastetheplan\">you can view the extension repo here.<\/a><\/p>\n\n\n\n<p>In addition, Drew wanted to address some expected questions on data privacy. He said:<\/p>\n\n\n\n<p>The Paste the Plan extension for Azure Data Studio brings to the forefront an important topic \u2013 data privacy. It is important to understand the implications of any extensions you might install. While the Paste the Plan extension securely hands your execution plan off to Paste the Plan via https, Paste the Plan is a public website and your execution plan is publicly available from there. One benefit to open source software is that it puts power in the community\u2019s hands to review the code and raise concerns about the way it treats your data. Another benefit to the open source extensions is that they can be used as guidebooks and frameworks when working on your own extensions.&nbsp; If an extension is open source, as many are, you can access the source code from the link in the Extension Gallery.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"introducing-the-high-color-queries-extension\">Introducing the High Color Queries extension<\/h2>\n\n\n\n<p>Drew has shipped not only one extension this month, but two extensions. He must really love writing extensions for Azure Data Studio!<\/p>\n\n\n\n<p>The second extension is the <a href=\"https:\/\/github.com\/dzsquared\/high-color-queries\">High Color Queries extension.<\/a> This extension allows for a great dark and light theme for working with T-SQL. It was interesting to see how the extension evolved based on Twitter feedback where a user wanted to see a theme more closely aligned with the default SSMS theme, and this was incorporated in the extension, as seen below.<\/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\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme.webp\" alt=\"a screenshot of a cell phone\" class=\"wp-image-25375 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme.webp 551w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme-235x300.webp 235w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme-196x250.webp 196w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme-275x350.webp 275w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme-400x510.webp 400w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme.png\" data-orig-srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme.png 551w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme-235x300.png 235w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme-196x250.png 196w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme-275x350.png 275w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/theme-more-closely-aligned-with-the-default-SSMS-theme-400x510.png 400w\"><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>If you have your own themes that you would like to build and share, Drew does a great job explaining how to make an integrated T-SQL theme in his <a href=\"https:\/\/www.drewsk.tech\/2018\/10\/28\/building-a-color-theme-for-azure-data-studio\/\">blog post which can be found here.<\/a> In general, feel free to email <a>yu.alan@microsoft.com<\/a> if you have any questions on how to get started building an Azure Data Studio extension.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"logging-improvements\">Logging improvements<\/h2>\n\n\n\n<p>We are seeking ways to empower users to submit more specific details on issues they run into in Azure Data Studio. Thus, our team has improved logging support, which you can start <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\">including in your issue reports going forward.<\/a><\/p>\n\n\n\n<p>To enable logging, you will need to open settings by:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Open Settings <strong>(Ctrl + ,)<\/strong><\/li>\n\n\n\n<li>Search for <strong>mssql.tracingLevel<\/strong><\/li>\n\n\n\n<li>Copy to User Settings, and change \u201cCritical\u201d to \u201cAll\u201d<\/li>\n<\/ol>\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\/11\/enable-logging.webp\" alt=\"a screenshot of a cell phone\" class=\"wp-image-25378 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging.webp 943w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging-300x160.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging-768x410.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging-330x176.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging-800x427.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging-400x213.webp 400w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging.png\" data-orig-srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging.png 943w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging-300x160.png 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging-768x410.png 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging-330x176.png 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging-800x427.png 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/enable-logging-400x213.png 400w\"><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>You can then view the logs by opening the Output Window by pressing <strong>Ctrl+u<\/strong> and clicking the dropdown for <strong>Log(SqlTools)<\/strong>.<\/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\/11\/view-the-logs-by-opening-the-Output-Window.webp\" alt=\"a close up of a logo\" class=\"wp-image-25381 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window.webp 1081w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-300x59.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-1024x203.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-768x152.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-330x65.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-800x158.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-400x79.webp 400w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window.png\" data-orig-srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window.png 1081w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-300x59.png 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-1024x203.png 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-768x152.png 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-330x65.png 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-800x158.png 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/view-the-logs-by-opening-the-Output-Window-400x79.png 400w\"><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>After some activity and having logging enabled, this is what it may look like.<\/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\/11\/Logging-enabled-activity.webp\" alt=\"a close up of a piece of paper\" class=\"wp-image-25384 webp-format\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity.webp 1097w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-300x182.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-1024x620.webp 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-768x465.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-330x200.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-800x484.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-400x242.webp 400w\" data-orig-src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity.png\" data-orig-srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity.png 1097w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-300x182.png 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-1024x620.png 1024w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-768x465.png 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-330x200.png 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-800x484.png 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/11\/Logging-enabled-activity-400x242.png 400w\"><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"bug-fixes\">Bug fixes<\/h2>\n\n\n\n<p>If you would like to help make Azure Data Studio a great product, share any feedback or report issues through <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\">our Issues page.<\/a> Our engineering team is regularly going through the untriaged issues and assigning issues into different monthly milestones so that you can know we are working on it. Your votes on issues help us prioritize.<\/p>\n\n\n\n<p>Fixed GitHub issues:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\/2717\">#2717<\/a>\u00a0XML Column result click formatting<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\/2993\">#2993<\/a>\u00a0Width&#8217;s Result windows is incomplete<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\/2851\">#2851<\/a>\u00a0TimeSeries chart does not render correctly.<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\/2933\">#2933<\/a>\u00a0Connection lost to Azure SQL DB<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\/2914\">#2914<\/a>\u00a0&#8220;Invalid argument&#8221; exception expanding OE database node<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\/2996\">#2996<\/a>\u00a0Temp table loss due to sudden session change<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/pull\/2935\">#2935<\/a>\u00a0Display multi-line messages correctly in query results<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/pull\/2906\">#2906<\/a>\u00a0Fix Edit Data document name when table name contains special characters<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\/2929\">#2929<\/a>\u00a0Built in extension changelog says to check the VSCode Release Notes for changes<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\/2719\">#2719<\/a>\u00a0High Contrast theme doubles\/triples icons<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/pull\/3047\">#3047<\/a>\u00a0Add a command line interface for connecting to a SQL Server<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/pull\/3031\">#3031<\/a>\u00a0Add query plan theme support<\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqltoolsservice\/pull\/714\">Microsoft\/sqltoolsservice#714<\/a>\u00a0Fix: DATETIMEOFFSET data types should be ISO formatted<\/li>\n<\/ul>\n\n\n\n<p>Extension fixes:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL Agent, Profiler, and Import Wizard all had several bug fixes. In particular, keyboard shortcuts and command palette commands now are working properly.<\/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 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 November 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. Note: If you are currently using the preview version, SQL Operations Studio, and would like to retain your settings when you upgrade to<\/p>\n","protected":false},"author":5562,"featured_media":25459,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ms_queue_force_push":false,"ms_queue_id":"","ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5226,2542,5227,2536,2418],"content-type":[2448],"topic":[2466],"coauthors":[2487],"class_list":["post-25342","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure","product-azure-data-studio","product-sql","product-sql-server-2019","product-sql-server-on-linux","content-type-updates","topic-developer","review-flag-1593580419-556","review-flag-1593580427-503","review-flag-alway-1593580309-407","review-flag-free-1593619513-128","review-flag-ga-1593580755-860","review-flag-new-1593580247-437","review-flag-publi-1593580761-761"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The November release of Azure Data Studio is now available - 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\/2018\/11\/06\/the-november-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 November release of Azure Data Studio is now available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to announce the November 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. Note: If you are currently using the preview version, SQL Operations Studio, and would like to retain your settings when you upgrade to\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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=\"2018-11-06T22:00:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-23T18:13:12+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=\"5 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\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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 November release of Azure Data Studio is now available\",\"datePublished\":\"2018-11-06T22:00:45+00:00\",\"dateModified\":\"2024-12-23T18:13:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/\"},\"wordCount\":1225,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/\",\"name\":\"The November release of Azure Data Studio is now available - 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\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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\":\"2018-11-06T22:00:45+00:00\",\"dateModified\":\"2024-12-23T18:13:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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\/2018\/11\/06\/the-november-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 November release of Azure Data Studio is now available\"}]},{\"@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 November release of Azure Data Studio is now available - 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\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/","og_locale":"en_US","og_type":"article","og_title":"The November release of Azure Data Studio is now available - Microsoft SQL Server Blog","og_description":"We are excited to announce the November 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. Note: If you are currently using the preview version, SQL Operations Studio, and would like to retain your settings when you upgrade to","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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":"2018-11-06T22:00:45+00:00","article_modified_time":"2024-12-23T18:13:12+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":"5 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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 November release of Azure Data Studio is now available","datePublished":"2018-11-06T22:00:45+00:00","dateModified":"2024-12-23T18:13:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/"},"wordCount":1225,"commentCount":1,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/","name":"The November release of Azure Data Studio is now available - 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\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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":"2018-11-06T22:00:45+00:00","dateModified":"2024-12-23T18:13:12+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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\/2018\/11\/06\/the-november-release-of-azure-data-studio-is-now-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/11\/06\/the-november-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\/2018\/11\/06\/the-november-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 November release of Azure Data Studio is now available"}]},{"@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"]}]}},"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/25342","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=25342"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/25342\/revisions"}],"predecessor-version":[{"id":51015,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/25342\/revisions\/51015"}],"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=25342"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=25342"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=25342"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=25342"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=25342"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=25342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}