{"id":26260,"date":"2019-02-13T11:00:39","date_gmt":"2019-02-13T19:00:39","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=26260"},"modified":"2024-12-23T10:12:34","modified_gmt":"2024-12-23T18:12:34","slug":"the-february-release-of-azure-data-studio-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/02\/13\/the-february-release-of-azure-data-studio-is-now-available\/","title":{"rendered":"The February release of Azure Data Studio is now available"},"content":{"rendered":"\n
We\u2019re excited to announce the February release of Azure Data Studio<\/a> (formerly known as SQL Operations Studio) is now available.<\/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: <\/strong>If you\u2019re currently using the preview version, SQL Operations Studio, and would like to retain your settings when upgrading to the latest version, please follow these instructions.<\/a> After downloading Azure Data Studio, say Yes<\/strong> to enabling preview features so that you can use extensions.<\/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 For a list of the complete updates, refer to the release notes.<\/a><\/p>\n\n\n\n For the first time, our Extension marketplace<\/a> now supports extension packs. This makes it easier for you to download all the extensions you need with one install rather than having to search for each individual extension. Going forward, we will look to group similar extensions and provide extension packs to make it easier for you to download the extensions you need daily.<\/p>\n\n\n\n To start off, we\u2019re introducing the Admin pack for SQL Server.<\/strong><\/p>\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n Admin Pack for SQL Server is a collection of popular database administration extensions to help you manage SQL Server. When you download this pack, you will download the following extensions:<\/p>\n\n\n\n If there are extensions you feel should be added to this pack, please submit a feature request on our GitHub Issues<\/a>.<\/p>\n\n\n\n If you missed the January release,<\/a> check out the post to see the UI revamp we made in the SQL Server Profiler extension. This included many Quality of Life bug fixes and an easier to navigate toolbar.<\/p>\n\n\n\n As we reached out to the community for feedback on the revamped Profiler, the most popular request was to add filtering support to the extension. With the February release, you can now filter the events to find the exact events you\u2019re looking for.<\/p>\n\n\n <\/p>\n\n\n\n When you download the Admin pack for SQL Server, try out the new Profiler extension and see if it meets your Profiler needs. The filtering option shows up neatly on the toolbar.<\/p>\n\n\n\n If there are features you would like to see, submit a feature request on our GitHub.<\/a><\/p>\n\n\n\n Currently, you\u2019re easily able to save your SQL results as a .csv, .xls, and .json. Naturally, users have requested an option to save results as XML. We have now provided this as a button in the Results view.<\/p>\n\n\n\n <\/p>\n\n\n\n Saving as XML will automatically open a tab so that you can verify the XML file.<\/p>\n\n\n\n Last month, we introduced the Data-Tier application wizard in the SQL Server Import Extension that includes support for the following actions:<\/p>\n\n\n\n This month, we\u2019ve introduced generate script<\/em> support as requested by the community. This allows users to generate deployment scripts which can be used in automation scenarios.<\/p>\n\n\n <\/p>\n\n\n\n In addition, the wizard now includes a view to see if a deploy action may result in data loss. This helps warn the user before proceeding.<\/p>\n\n\n\n <\/p>\n\n\n <\/p>\n\n\n\n When you download the Admin Pack for SQL Server extension, you can try out the Profiler and Import improvements immediately. Let us know your feedback.<\/p>\n\n\n\n Support for SQL Server 2019 has been updated. On connecting to a SQL Server big data cluster instance, a new Data Services<\/em> folder will appear in the explorer tree. This has launch points for actions such as opening a new Notebook against the connection, submitting Spark jobs, and working with HDFS. Note that for some actions such as Create External Data<\/strong> over an HDFS file\/folder, the SQL Server 2019 Preview extension must be installed.<\/p>\n\n\n\n We\u2019ve made significant updates to the Notebook user interface in this release. We focused on making it easy to read Notebooks that are shared with you. This meant removing all outline boxes around cells unless selected or hovered, adding hover support for easy cell-level actions without the need to select a cell, and clarifying execution state by adding execution count, an animated stop running<\/em> button, and more.<\/p>\n\n\n\n We also added keyboard shortcuts for:<\/p>\n\n\n\n Moving forward we will aim to have all key actions launchable by shortcut, so please let us know what you’re missing!<\/p>\n\n\n <\/p>\n\n\n\n <\/p>\n\n\n\n Other improvements and bug fixes include:<\/span><\/p>\n\n\n\n A number of improvements that help extenders were added in this release including:<\/p>\n\n\n\n To download the extension and view the full release notes, follow these instructions.<\/a><\/p>\n\n\n\n As detailed in January, we announced results streaming for long running queries. In previous versions of Azure Data Studio, when a user ran large queries, no results would appear in the results grid until the query could show all of the results. This was not a great experience for our users, so we did some investigating to improve this experience.<\/p>\n\n\n\n In the latest build of Azure Data Studio, users can now see results streamed in the results grid by default. This makes it a better experience since you can see the results quicker and interact with your data instead of being in a waiting state.<\/p>\n\n\n\n <\/p>\n\n\n\n Please let us know of any feedback you have for this experience, we will continue to make investments in improving the Query Editor and results grid in the upcoming months.<\/p>\n\n\n\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 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 A full list of bug fixes<\/a> for the February release can be found here.<\/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 or tweet us<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":" We\u2019re excited to announce the February 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\u2019re currently using the preview version, SQL Operations Studio, and would like to retain your settings when upgrading to the latest version,<\/p>\n","protected":false},"author":5562,"featured_media":26239,"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,2536],"content-type":[2448],"topic":[2451,2466],"coauthors":[2487],"class_list":["post-26260","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-big-data","topic-developer","review-flag-1593580427-503","review-flag-1593580419-556","review-flag-3-1593580441-293","review-flag-4-1593580446-456","review-flag-free-1593619513-128","review-flag-new-1593580247-437"],"yoast_head":"\nThe key highlights for the February release include:<\/h3>\n\n\n\n
\n
Introducing Admin pack for SQL Server<\/h2>\n\n\n\n
<\/figure>\n\n\n\n
\n
\n
\n
\n
SQL Server Profiler Filtering<\/h2>\n\n\n\n
<\/figure>\n\n\n\n
Save as XML<\/h2>\n\n\n\n
<\/figure>\n\n\n\n
Data-Tier Application Wizard improvements<\/h2>\n\n\n\n
\n
<\/figure>\n\n\n\n
<\/figure>\n\n\n\n
SQL Server 2019 Preview extension<\/h2>\n\n\n\n
Notebook support<\/h3>\n\n\n\n
\n
<\/figure>\n\n\n\n
\n
Known issues<\/h3>\n\n\n\n
\n
Extensibility improvements<\/h3>\n\n\n\n
\n
Streaming enabled by default<\/h2>\n\n\n\n
<\/figure>\n\n\n\n
Bug fixes and Thank you<\/h2>\n\n\n\n
Azure Data Studio bug fixes<\/h3>\n\n\n\n
Contact Us<\/h2>\n\n\n\n