{"id":28161,"date":"2019-09-10T11:00:19","date_gmt":"2019-09-10T18:00:19","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=28161"},"modified":"2024-01-29T10:32:27","modified_gmt":"2024-01-29T18:32:27","slug":"the-september-release-of-azure-data-studio-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/09\/10\/the-september-release-of-azure-data-studio-is-now-available\/","title":{"rendered":"The September release of Azure Data Studio is now available"},"content":{"rendered":"
Today we\u2019re announcing the September release of <\/strong>Azure Data Studio<\/strong><\/a> (formerly known as SQL Operations Studio) is now available.<\/strong><\/p>\n Download Azure Data Studio<\/a>\u00a0and review the Release notes<\/a> to get started.<\/p>\n Please note: <\/strong>After downloading Azure Data Studio, click Yes<\/strong> to enabling preview features so that you can use the extensions.<\/p>\n Azure Data Studio is a multi-database, 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, please visit our GitHub.<\/a><\/p>\n The key highlights to cover this month include:<\/p>\n For a complete list of updates, refer to the Release notes.<\/a><\/p>\n As we continue to bring over key features from SQL Server Management Studio, one highly requested feature was enabling SQL Server command line (SQLCMD) mode in our Query Editor. SQLCMD mode allows users to write and edit queries as SQLCMD scripts. In addition, users can also execute the SQLCMD scripts.<\/p>\n This feature is now possible in Azure Data Studio.<\/p>\n In addition, with the release of the Schema Compare extension<\/a> in Azure Data Studio, users can now output SQLCMD scripts. Having an editing experience in Azure Data Studio helps complete the story where you can output a SQLCMD script, modify, and then execute the SQLCMD script all in a single tool.<\/strong><\/p>\n To learn more about SQLCMD mode in SQL Server Management Studio, check out our documentation.<\/a><\/p>\n Thanks to the hard work from Drew Skwiers-Koballa, the Query Editor Boost extension is now available in the Azure Data Studio extensions marketplace.<\/p>\n Query Editor Boost is an open source extension focused on enhancing the Azure Data Studio query editor for users who are frequently writing queries. The extension\u2019s user experience, including snippet creator and a new query template, is constructed to avoid manually editing JSON files. Here are some of the highlights:<\/p>\n Creating T-SQL snippets helps improve productivity by quickly generating custom snippets and templates that are highly used. However, tinkering with the JSON can be a painful experience. With this extension, through simple keyboard navigation, you no longer have to tinker with the JSON.<\/p>\n This feature alone is a great reason to download this extension so that you can quickly generate more snippets.<\/p>\n To further illustrate improvements in keyboard navigation and accessibility, users can press Ctrl\/CMD + U to have a dropdown appear to switch to the database you need.<\/p>\n If you find yourself running similar queries each day, you can now override the new query option to a custom template of your choice.<\/p>\n Additional feature requests are welcomed and the development of the Query Editor Boost extension is open to all. You can open any issues or feature requests in the GitHub repository.<\/a><\/p>\n The focus for the September release for our Notebooks feature<\/a> was to improve the performance of notebooks. This includes supporting larger notebook files that would have crashed in Azure Data Studio in the past.<\/p>\n A summary of related Notebook performance improvements and bug fixes include:<\/p>\n Let us know of any issues you run into for Notebooks. Many new features will soon be enabled in our daily Insiders build, so keep an eye out this month.<\/p>\n As part of our monthly Visual Studio Code merges, we have updated from Visual Studio Code 1.37 to 1.38.<\/p>\n This includes the following changes:<\/p>\n To see the full list of changes, you can check the Visual Studio Code monthly release notes:<\/p>\n If you would like to help make Azure Data Studio a great product, please share any feedback or report issues through our issues page.<\/a> Our engineering team regularly goes through the untriaged issues and assigns issues into different monthly milestones so that you know we are working on it. Your votes on issues helps us prioritize.<\/p>\n A full list of bug fixes<\/a> for the September release can be found here.<\/p>\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 or tweet us<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":" Today we\u2019re announcing the September release of Azure Data Studio (formerly known as SQL Operations Studio) is now available. Download Azure Data Studio\u00a0and review the Release notes to get started. Please note: After downloading Azure Data Studio, click Yes to enabling preview features so that you can use the extensions. Azure Data Studio is a<\/p>\n","protected":false},"author":5562,"featured_media":26395,"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],"content-type":[2448],"topic":[2466],"coauthors":[2487],"class_list":["post-28161","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure","product-azure-data-studio","product-sql","product-sql-server-2019","content-type-updates","topic-developer"],"yoast_head":"\n\n
SQL Server command line (SQLCMD) mode<\/h2>\n
<\/p>\n
<\/p>\n
Community extension: Query Editor Boost<\/h2>\n
Save the current query as a snippet<\/h3>\n
<\/p>\n
Switch databases using Ctrl+U<\/h3>\n
<\/p>\n
New query from template<\/h3>\n
<\/p>\n
Notebook improvements<\/h2>\n
\n
Visual Studio Code August release merge 1.38<\/h2>\n
\n
\n
Bug fixes<\/h2>\n
Contact us<\/h2>\n