{"id":25273,"date":"2018-10-18T14:00:22","date_gmt":"2018-10-18T21:00:22","guid":{"rendered":""},"modified":"2024-12-23T10:07:31","modified_gmt":"2024-12-23T18:07:31","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":"\n
We are excited to announce the October release of Azure Data Studio<\/a> (formerly known as SQL Operations Studio) is now available.<\/strong><\/p>\n\n\n\n Download Azure Data Studio<\/a> and review the Release Notes<\/a> to get started.<\/p>\n\n\n\n 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, 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\n\n\n 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, visit our GitHub<\/a>.<\/p>\n\n\n\n Azure Data Studio was announced Generally Available last month at Microsoft Ignite. If you missed the GA announcement, you can see “Azure Data Studio for SQL Server<\/a>” 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\n\n\n 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\n\n\n This includes:<\/p>\n\n\n\n For complete updates, refer to the Release Notes<\/a>.<\/p>\n\n\n\n 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 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\n\n\n 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, follow the documentation here<\/a>.<\/p>\n\n\n\n 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\n\n\n To download the extension, follow the instructions here<\/a>.<\/p>\n\n\n\n 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\n\n\n 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\n\n 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\n\n <\/p>\n\n\n\n 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\n\n\n To learn more about the Azure Resource Explorer, check out our documentation<\/a>.<\/p>\n\n\n\n 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\n\n <\/p>\n\n\n\n Now you can edit your Job steps, schedules, alerts, and notifications within the dialog.<\/p>\n\n\n\n If you are an avid user of SQL Server Agent, 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->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\n\n\n To learn more about SQL Agent or how to acquire the extension, check out our documentation<\/a>.<\/p>\n\n\n\n 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\n\n\n To see a full list of the connection investments, see below:<\/p>\n\n\n\n <\/p>\n\n\n\n As requested on our 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\n\n\n This shows up as the last input box in the connection dialog as you can see in the screenshot below:<\/p>\n\n\n <\/p>\n\n\n\n This will then appear in your Servers pane.<\/p>\n\n\n\n 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\n\n\n 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\n\n\n A summary of changes:<\/p>\n\n\n\n To see the full list of changes, you can view the updates at the Visual Studio Code updates page<\/a>. Be sure to view the changes in also the May and June changes.<\/p>\n\n\n\n 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\n\n\n 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\n\n\n If you have any feature requests or issues, please submit to our Github issues page<\/a>. For any questions, feel free to comment below, message us on Gitter<\/a>, or tweet us @AzureDataStudio<\/a>.<\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" 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.<\/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,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","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-free-1593619513-128","review-flag-ga-1593580755-860","review-flag-new-1593580247-437"],"yoast_head":"\n\n
\n
\n
SQL Server 2019 Preview extension<\/h2>\n\n\n\n
\n
\n
\n
\n
Introducing the Azure Resource Explorer<\/h2>\n\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\nSQL Server Agent extension improvements<\/h2>\n\n\n\n
<\/figure>\n\n\n\nImprove Object Explorer and Query Editor connectivity robustness<\/h2>\n\n\n\n
\n
Custom connection name option to provide alternative name<\/h2>\n\n\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
VS Code refresh from 1.23 to 1.26.1<\/h2>\n\n\n\n\n
Thank you to contributors<\/h2>\n\n\n\n
\n
Contact us<\/h2>\n\n\n\n