{"id":42638,"date":"2022-07-27T08:00:00","date_gmt":"2022-07-27T15:00:00","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=42638"},"modified":"2024-04-19T10:40:47","modified_gmt":"2024-04-19T17:40:47","slug":"azure-data-studio-july-release-with-vs-code-updates","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2022\/07\/27\/azure-data-studio-july-release-with-vs-code-updates\/","title":{"rendered":"Azure Data Studio July Release with VS Code Updates\u00a0"},"content":{"rendered":"\n
Hello, community! As you may already know, Azure Data Studio (ADS)<\/a> is and has always been focused on building out its own ecosystem of extensions and customized tabs for handling databases, using the UI framework of Visual Studio (VS) Code<\/a>. As a result, all improvements and\/or fixes that are performed on the VS Code codebase need to be periodically merged from upstream into the Azure Data Studio codebase to maintain the integrity of its UI framework on ADS. In this v1.38 release, we are excited to announce some improvements to Azure Data Studio, thanks to a recent Visual Studio code merge. Azure Data Studio now runs on the Visual Studio Code 1.62 version<\/a> (previously 1.59). \u202fThis release also features improvements and fixes to the Query Plan Viewer and Table Design features. <\/p>\n\n\n\n The Query Plan Viewer feature continues to add functionality with this release of Azure Data Studio. There are several UX improvements users may notice: the icon to enable the capture of an actual plan has been updated, operator selection is now noted with a solid green line, and the plan labels are updated in the Properties window when plans are compared and the orientation is toggled from horizontal to vertical, and back. We have updated the Command Palette to make it easier to find the commands for execution plans, and while the CTRL + M command still enables actual plan capture for a query window, it no longer executes the selected query (or queries) in the window. <\/p>\n\n\n\n The Top Operations pane, which appears secondary to the plan, now includes the Actual Rows column for plans with runtime statistics to expediate the evaluation of estimated and actual rows when analyzing a plan. In each row of the Top Operations pane, the Operation (Clustered Index Seek, Nested Loop) is now a clickable link, and when selected will take you directly to that operator in the plan.<\/p>\n\n\n\nUpdates to Query Plan Viewer<\/h2>\n\n\n\n