{"id":25273,"date":"2018-10-18T14:00:22","date_gmt":"2018-10-18T21:00:22","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=25273"},"modified":"2024-01-29T10:34:22","modified_gmt":"2024-01-29T18:34:22","slug":"the-october-release-of-azure-data-studio-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/","title":{"rendered":"The October release of Azure Data Studio is now available"},"content":{"rendered":"<p><strong>We are excited to announce the October 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<p><a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/download\">Download Azure Data Studio<\/a> and review the <a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/release-notes\">Release Notes<\/a> to get started.<\/p>\n<p>Note: 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 on first launch, and then you can disable in settings if you don\u2019t need it otherwise you will be missing preview experiences like Query Plans, certain extension support, and more.<\/p>\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<p>Azure Data Studio was announced Generally Available last month at Microsoft Ignite. If you missed the GA announcement, you can see &#8220;<a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/azure-data-studio-for-sql-server\/\">Azure Data Studio for SQL Server<\/a>&#8221; on the SQL Server blog. 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<p>Check out this video for a general overview of Azure Data Studio.<\/p>\n<p><iframe loading=\"lazy\" title=\"Video Player\" src=\"https:\/\/www.microsoft.com\/en-us\/videoplayer\/embed\/RE2EgJl\" class=\"c-video\" frameborder=\"0\" width=\"960\" height=\"540\" allowfullscreen=\"true\"><\/iframe><\/p>\n<p>In the October\u2019s version of the monthly release blog, we will be covering features shipped in the September GA release as well as what is new in the October release.<\/p>\n<p>This includes:<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/sql-server-2019-extension?view=sql-server-ver15\">Announcing the SQL Server 2019 Preview extension<\/a>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/big-data-cluster\/deploy-big-data-tools?view=sqlallproducts-allversions\">Support for SQL Server 2019 features including big data cluster support<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/big-data-cluster\/notebooks-guidance?view=sqlallproducts-allversions\">Azure Data Studio Notebooks<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/relational-databases\/polybase\/data-virtualization?toc=%2fsql%2fbig-data-cluster%2ftoc.json&amp;view=sqlallproducts-allversions\">SQL Server Polybase Create External Table Wizard<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/azure-resource-explorer\">Azure Resource Explorer<\/a>\n<ul>\n<li>The Azure Resource Explorer view lets you browse data-related endpoints for your Azure accounts and create connections to them in Object Explorer. In this release Azure SQL Databases and servers are supported.<\/li>\n<\/ul>\n<\/li>\n<li>SQL Server Agent Extension improvements<\/li>\n<li>Improve Object Explorer and Query Editor connectivity robustness<\/li>\n<li>Added Connection name option to provide an alternative display name in the Servers view-let<\/li>\n<li>VS Code source code refresh from 1.23 to 1.26.1 with Grid Layout and Improved Settings Editor (Preview)<\/li>\n<li>Thank you to contributors<\/li>\n<\/ul>\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<h2>SQL Server 2019 Preview extension<\/h2>\n<p>As announced at Microsoft Ignite, one of the most exciting extensions to share in our September GA release was the release of the SQL Server 2019 Preview extension. If you were following the <a href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/09\/25\/introducing-microsoft-sql-server-2019-big-data-clusters\/\">blog announcements<\/a>, starting with SQL Server 2019 preview, SQL Server big data clusters allow you to deploy scalable clusters of SQL Server, Spark, and HDFS Docker containers running on Kubernetes.<\/p>\n<p>These components are running side by side to enable you to read, write, and process big data from Transact-SQL or Spark. SQL Server big data clusters allow you to easily combine and analyze your high-value relational data with high-volume big data. To learn about all the excitement of SQL Server Big Data Clusters, <a href=\"https:\/\/docs.microsoft.com\/sql\/big-data-cluster\/deploy-big-data-tools?view=sqlallproducts-allversions\">follow the documentation here<\/a>.<\/p>\n<p>These experiences are built as an extension to Azure Data Studio. We can go into full depth about all the great capabilities this extension includes, but deep-diving into any one of these features can be a full blog post itself. Here is a high-level summary of these features, and then you can see a full demo of the features below.<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/big-data-cluster\/deploy-big-data-tools?view=sqlallproducts-allversions\">Support for SQL Server 2019 features including big data cluster support<\/a>\n<ul>\n<li>Connect to the HDFS\/Spark Gateway shipped with SQL Server 2019<\/li>\n<li>Browse HDFS, upload files, save files, and launch useful actions such as Analyze in Notebook for CSV files<\/li>\n<li>Submit Spark jobs from the dashboard or right-click on a HDFS\/Spark connection in Object Explorer<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/big-data-cluster\/notebooks-guidance?view=sqlallproducts-allversions\">Azure Data Studio Notebooks<\/a>\n<ul>\n<li>Create or open Notebooks using an integrated Notebook viewer. In this release the Notebook viewer supports connecting to local kernels and the SQL Server 2019 big data cluster only.<\/li>\n<li>Use the PROSE Code Accelerator libraries in your Notebook to learn file format and data types for fast data preparation.<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/sql\/relational-databases\/polybase\/data-virtualization?toc=%2fsql%2fbig-data-cluster%2ftoc.json&amp;view=sqlallproducts-allversions\">SQL Server Polybase Create External Table Wizard<\/a>\n<ul>\n<li>Create an external table and its supporting metadata structures with an easy to use wizard. In this release, remote SQL Server and Oracle servers are supported.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Demo of SQL Server 2019 preview extension capabilities:<\/p>\n<p><iframe loading=\"lazy\" title=\"Video Player\" src=\"https:\/\/www.microsoft.com\/en-us\/videoplayer\/embed\/RE2DqVd\" class=\"c-video\" frameborder=\"0\" width=\"960\" height=\"540\" allowfullscreen=\"true\"><\/iframe><\/p>\n<p>To download the extension, <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<h2>Introducing the Azure Resource Explorer<\/h2>\n<p>As part of our goal to unify data management experiences, we have made it easier to manage your Azure subscriptions through the Azure Resource Explorer. Originally shipped as an extension, this feature is now built into the core product of Azure Data Studio.<\/p>\n<p>After downloading the latest version, you will now see an Azure icon on the left bar, which you can click on to navigate to the Azure Resource Explorer.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-25276 size-full\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/Screenshot-to-navigate-to-the-Azure-Resource-Explorer.png\" alt=\"\" width=\"438\" height=\"357\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/Screenshot-to-navigate-to-the-Azure-Resource-Explorer.webp 438w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/Screenshot-to-navigate-to-the-Azure-Resource-Explorer-300x245.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/Screenshot-to-navigate-to-the-Azure-Resource-Explorer-307x250.webp 307w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/Screenshot-to-navigate-to-the-Azure-Resource-Explorer-330x269.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/Screenshot-to-navigate-to-the-Azure-Resource-Explorer-400x326.webp 400w\" sizes=\"(max-width: 438px) 100vw, 438px\" \/>With this feature, you can now manage your Azure SQL Server, Azure SQL Database, and the recently GA\u2019ed Azure SQL Managed Instance resources easily. By clicking the filter icon to the right of the explorer, you can select which subscriptions you want to have displayed.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25279 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/5bc8b0ee6c086-5bc8b0ee6c087By-clicking-the-filter-icon-to-the-right-of-the-explorer-you-can-select-which-subscriptions-you-want-to-have-displayed.png.png\" alt=\"\" width=\"623\" height=\"195\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/5bc8b0ee6c086-5bc8b0ee6c087By-clicking-the-filter-icon-to-the-right-of-the-explorer-you-can-select-which-subscriptions-you-want-to-have-displayed.png.webp 623w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/5bc8b0ee6c086-5bc8b0ee6c087By-clicking-the-filter-icon-to-the-right-of-the-explorer-you-can-select-which-subscriptions-you-want-to-have-displayed.png-300x94.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/5bc8b0ee6c086-5bc8b0ee6c087By-clicking-the-filter-icon-to-the-right-of-the-explorer-you-can-select-which-subscriptions-you-want-to-have-displayed.png-330x103.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/5bc8b0ee6c086-5bc8b0ee6c087By-clicking-the-filter-icon-to-the-right-of-the-explorer-you-can-select-which-subscriptions-you-want-to-have-displayed.png-400x125.webp 400w\" sizes=\"(max-width: 623px) 100vw, 623px\" \/><\/p>\n<p>After drilling down to your target SQL instance through the explorer, you can then click on the plug icon next to each SQL instance to open up the connection dialog to directly connect to that resource and instantly start querying.<\/p>\n<p>To learn more about the Azure Resource Explorer, <a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/azure-resource-explorer\">check out our documentation<\/a>.<\/p>\n<h2>SQL Server Agent extension improvements<\/h2>\n<p>One of our engineering focuses is to improve our first party extensions, which include SQL Server Agent, SQL Server Profiler, and SQL Server Import. As one of the first steps, we have brought a lot of UI and functionality fixes in SQL Server Agent, particularly in the Edit Job experience.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25282 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/5bc8b16c890b4-5bc8b16c890b6edit-your-Job-steps-schedules-alerts-and-notifications-within-the-dialog.png.png\" alt=\"\" width=\"495\" height=\"628\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/5bc8b16c890b4-5bc8b16c890b6edit-your-Job-steps-schedules-alerts-and-notifications-within-the-dialog.png.webp 495w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/5bc8b16c890b4-5bc8b16c890b6edit-your-Job-steps-schedules-alerts-and-notifications-within-the-dialog.png-236x300.webp 236w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/5bc8b16c890b4-5bc8b16c890b6edit-your-Job-steps-schedules-alerts-and-notifications-within-the-dialog.png-197x250.webp 197w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/5bc8b16c890b4-5bc8b16c890b6edit-your-Job-steps-schedules-alerts-and-notifications-within-the-dialog.png-276x350.webp 276w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/5bc8b16c890b4-5bc8b16c890b6edit-your-Job-steps-schedules-alerts-and-notifications-within-the-dialog.png-400x507.webp 400w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/p>\n<p>Now you can edit your Job steps, schedules, alerts, and notifications within the dialog.<\/p>\n<p>If you are an avid user of SQL Server Agent,<strong> this is your chance to have a say in the new Agent experience in Azure Data Studio<\/strong>. You can report an issue directly on GitHub or go to Help-&gt;Report an issue to report directly from the product. Let us know your daily scenarios and how we can help empower you to use SQL Agent on Azure Data Studio daily.<\/p>\n<p>To learn more about SQL Agent or how to acquire the extension, <a href=\"https:\/\/docs.microsoft.com\/sql\/azure-data-studio\/sql-server-agent-extension\">check out our documentation<\/a>.<\/p>\n<h2>Improve Object Explorer and Query Editor connectivity robustness<\/h2>\n<p>As part of addressing customer reported issues, we put an emphasis on improving connectivity robustness across Object Explorer and Query Editor. In particular, queries that lose a connection will automatically attempt to reconnect.<\/p>\n<p>To see a full list of the connection investments, see below:<\/p>\n<ul>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqltoolsservice\/pull\/706\">Load properties used for OE node status by group instead of individually<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqltoolsservice\/pull\/705\">Clear OE node error message when populating children<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqltoolsservice\/pull\/704\">Reopen connections prior to creating query execution data readers<\/a><\/li>\n<li><a href=\"https:\/\/github.com\/Microsoft\/sqltoolsservice\/pull\/702\">Fix OE and Binding Queue reliability bugs<\/a><\/li>\n<\/ul>\n<h2>Custom connection name option to provide alternative name<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25285 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/provide-friendly-connection-names-for-your-connections.png\" alt=\"\" width=\"974\" height=\"268\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/provide-friendly-connection-names-for-your-connections.webp 974w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/provide-friendly-connection-names-for-your-connections-300x83.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/provide-friendly-connection-names-for-your-connections-768x211.webp 768w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/provide-friendly-connection-names-for-your-connections-330x91.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/provide-friendly-connection-names-for-your-connections-800x220.webp 800w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/provide-friendly-connection-names-for-your-connections-400x110.webp 400w\" sizes=\"(max-width: 974px) 100vw, 974px\" \/><\/p>\n<p>As requested on our <a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/issues\">GitHub issues page<\/a>, you can now provide friendly connection names for your connections. This is particularly useful if your connection instance is an ip address, very long, or want to hide the name of the server in a public facing demo or docs.<\/p>\n<p>This shows up as the last input box in the connection dialog as you can see in the screenshot below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25288 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/shows-up-as-the-last-input-box-in-the-connection-dialog.png\" alt=\"\" width=\"476\" height=\"410\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/shows-up-as-the-last-input-box-in-the-connection-dialog.webp 476w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/shows-up-as-the-last-input-box-in-the-connection-dialog-300x258.webp 300w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/shows-up-as-the-last-input-box-in-the-connection-dialog-290x250.webp 290w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/shows-up-as-the-last-input-box-in-the-connection-dialog-330x284.webp 330w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/shows-up-as-the-last-input-box-in-the-connection-dialog-400x345.webp 400w\" sizes=\"(max-width: 476px) 100vw, 476px\" \/><\/p>\n<p>This will then appear in your Servers pane.<\/p>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25291 aligncenter\" src=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/Servers-pane.png\" alt=\"\" width=\"230\" height=\"317\" srcset=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/Servers-pane.webp 230w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/Servers-pane-218x300.webp 218w, https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/10\/Servers-pane-181x250.webp 181w\" sizes=\"(max-width: 230px) 100vw, 230px\" \/>VS Code refresh from 1.23 to 1.26.1<\/h2>\n<p>Since Azure Data Studio forks from Visual Studio Code, our team continues to periodically \u201crefresh\u201d Azure Data Studio with stable and mature VS Code releases. This directly benefits users especially in editor and configuration experience.<\/p>\n<p>The latest refresh picks up the latest changes from the July release of Visual Studio Code. This was implemented in the September release, but is still good to highlight for those coming from SQL Operations Studio.<\/p>\n<p>A summary of changes:<\/p>\n<ul>\n<li>Preview support of <a href=\"https:\/\/code.visualstudio.com\/updates\/v1_26#_new-settings-editor\">improved settings editor<\/a><\/li>\n<li>Small UI changes in grid editor<\/li>\n<\/ul>\n<p>To see the full list of changes, you can view the updates at the <a href=\"https:\/\/code.visualstudio.com\/updates\/v1_26\">Visual Studio Code updates page<\/a>. Be sure to view the changes in also the May and June changes.<\/p>\n<h2>Thank you to contributors<\/h2>\n<p>If you would like to help make Azure Data Studio a great product, share any feedback or report issues through our Issues page. 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 helps us prioritize.<\/p>\n<p>In addition to submitting issues, users can also contribute by submitting pull requests for potential quick fixes, and we welcome those submissions. Here is a shout-out to some of the customers who have submitted PR\u2019s that have been included in the product:<\/p>\n<ul>\n<li>AlexFsmn\u00a0Feature: Ability to add connection name (<a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/pull\/2332\">#2332<\/a>)<\/li>\n<li>AlexFsmn\u00a0Disabled connection name input when connecting to a server. (<a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/pull\/2566\">#2566<\/a>)<\/li>\n<li>philoushka for\u00a0center the icon\u00a0(<a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/pull\/2760\">#2760<\/a>)<\/li>\n<li>anthonypants for\u00a0Typo\u00a0(<a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/pull\/2775\">#2775<\/a>)<\/li>\n<li>kstolte for\u00a0Fix Invalid Configuration in Launch.json\u00a0(<a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/pull\/2789\">#2789<\/a>)<\/li>\n<li>kstolte for\u00a0Fixing a reference to SQL Ops Studio\u00a0(<a href=\"https:\/\/github.com\/Microsoft\/azuredatastudio\/pull\/2788\">#2788<\/a>)<\/li>\n<\/ul>\n<h2>Contact us<\/h2>\n<p>If you have any feature requests or issues, please submit to our <a href=\"https:\/\/github.com\/microsoft\/azuredatastudio\/issues\">Github issues page<\/a>. For any questions, feel free to comment below, message us on <a href=\"https:\/\/gitter.im\/Microsoft\/sqlopsstudio\">Gitter<\/a>, or tweet us <a href=\"https:\/\/twitter.com\/azuredatastudio\">@AzureDataStudio<\/a>.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are excited to announce the October release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio 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<\/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":"","footnotes":""},"post_tag":[],"product":[5226,2542,5227,2521,2406,2409,2418],"content-type":[2448],"topic":[2466],"coauthors":[2487],"class_list":["post-25273","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-2017-on-linux","product-sql-server-on-linux","content-type-updates","topic-developer"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The October 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\/10\/18\/the-october-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 October release of Azure Data Studio is now available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to announce the October release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio 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\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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-10-18T21:00:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-29T18:34:22+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=\"6 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\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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 October release of Azure Data Studio is now available\",\"datePublished\":\"2018-10-18T21:00:22+00:00\",\"dateModified\":\"2024-01-29T18:34:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/\"},\"wordCount\":1524,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/\",\"name\":\"The October 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\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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-10-18T21:00:22+00:00\",\"dateModified\":\"2024-01-29T18:34:22+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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\/10\/18\/the-october-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 October 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 October 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\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/","og_locale":"en_US","og_type":"article","og_title":"The October release of Azure Data Studio is now available - Microsoft SQL Server Blog","og_description":"We are excited to announce the October release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio 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","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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-10-18T21:00:22+00:00","article_modified_time":"2024-01-29T18:34:22+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":"6 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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 October release of Azure Data Studio is now available","datePublished":"2018-10-18T21:00:22+00:00","dateModified":"2024-01-29T18:34:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/"},"wordCount":1524,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/","name":"The October 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\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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-10-18T21:00:22+00:00","dateModified":"2024-01-29T18:34:22+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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\/10\/18\/the-october-release-of-azure-data-studio-is-now-available\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/10\/18\/the-october-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\/10\/18\/the-october-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 October 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\/25273"}],"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=25273"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/25273\/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=25273"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=25273"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=25273"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=25273"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=25273"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=25273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}