{"id":27684,"date":"2019-07-11T11:02:37","date_gmt":"2019-07-11T18:02:37","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=27684"},"modified":"2024-01-29T10:32:50","modified_gmt":"2024-01-29T18:32:50","slug":"the-july-release-of-azure-data-studio-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/07\/11\/the-july-release-of-azure-data-studio-is-now-available\/","title":{"rendered":"The July release of Azure Data Studio is now available"},"content":{"rendered":"
This post and release activities were co-authored by Vasu Bhog, an intern on the Azure Data Studio team.<\/em><\/p>\n We\u2019re excited to announce that the July release of\u00a0<\/span><\/strong>Azure Data Studio<\/span><\/strong><\/a>\u00a0is now available.<\/span><\/strong><\/p>\n You can download Azure Data Studio<\/a>\u00a0and review the\u00a0release notes<\/a>\u00a0to get started.<\/p>\n Please note:\u00a0<\/strong>After downloading Azure Data Studio, click yes<\/strong> to enable the preview features so that you can use extensions.<\/p>\n Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals that uses the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. To learn more,\u00a0please visit our GitHub.<\/a><\/p>\n The key highlights to cover this month include:<\/p>\n For a complete list of updates, please refer to the release notes.<\/a><\/p>\n One of the most requested features from customers around the world is enhanced execution plan support. Although we have basic query plan support in Azure Data Studio, it\u2019s not as robust as similar functionality built into SQL Server Management Studio and what other vendors provide.<\/p>\n Today, we\u2019re pleased to announce that one of our valued Microsoft partners, SentryOne<\/a> is shipping their SentryOne Plan Explorer extension for Azure Data Studio<\/a>. This is a free extension that provides enhanced plan diagrams for queries that are run in Azure Data Studio, with optimized layout algorithms and intuitive color-coding to help quickly identify the most expensive operators affecting query performance.<\/p>\n <\/p>\n With the .NET core work the SentryOne engineering team has done, you can now examine your query plans easily through navigation, coloring, and additional functionality no matter the operating system you use to run Azure Data Studio.<\/p>\n To learn more about the extension, check out SentryOne\u2019s Azure Data Studio extension blog post<\/a>.<\/p>\n Since released at Microsoft Build, the schema compare extension has been growing in popularity. To continue this momentum, we have several new features such as SCMP file support and cancel support, to make it even easier to get started using the schema compare extension.<\/p>\n Are you already used to schema compare in SQL Server Data Tools (SSDT)? Now you can bring your own SCMP file and light it up in Azure Data Studio. Simply take your existing SCMP files from SQL Server Data Tools and seamlessly open them from Azure Data Studio. Check out the gif below to see this in action:<\/p>\n <\/strong><\/p>\n Not only will it maintain feature parity, but you can also save your schema compare in Azure Data Studio, and then open it up in SQL Server Data Tools. This makes it even easier to share SCMP files across the team, and it even works cross-platform. Try your existing SCMP files and let us know what else you would like to see.<\/p>\n Sometimes running a schema compare can take a long time, or you realize you want to make a quick modification to the comparison. From user experience studies, there have been many requests for cancel comparison support for schema compare.<\/p>\n With this release, you can now stop the comparison at any time, make modifications, and then run it again. This is one of our most asked for quality of life requests, and we\u2019re happy to bring this feature to our users.<\/p>\n In addition to these two key features, we\u2019ve fixed many bugs that were opened. You can review the full list of bug fixes at your leisure.<\/a><\/p>\n Try out the schema compare extension in our extension marketplace. If you find any bugs or have feature requests, please file it on GitHub. To learn more, please read our schema compare extension documentation.<\/a><\/p>\n SQL Notebooks continues to be adopted by more and more users for demos, troubleshooting, education, and documentation. As we continue to bring new features into SQL Notebooks, we\u2019ve focused on quality and performance to make sure notebooks are a first-class experience for our users.<\/p>\n The Plotly Python graph library makes interactive and professional quality visualizations. It is a popular tool for data exploration and in this release, we\u2019ve added support for viewing Plotly graphs in SQL Notebooks. Simply open a notebook with an existing graph or try out the code in the gif below using an Azure Data Studio notebook with a Python 3 kernel.<\/p>\n <\/strong><\/p>\n We wanted to make sharing Notebooks from any location easier, so in this release we added a Notebook protocol handler. This lets you add links or buttons that open Azure Data Studio and download a Notebook from an online location such as GitHub.<\/p>\n The link format is as follows:<\/p>\n azuredatastudio:\/\/microsoft.notebook\/open?url=[Encoded URL]<\/p>\n So, for example, this notebook on GitHub<\/a> can be opened directly in Azure Data Studio with this link format:<\/p>\n This should make it easier to link to notebooks from emails, chat rooms, documentation, and on blogs.<\/p>\n We have a new dialog that allows users to manage their python packages directly. It can be found when using a notebook along the top menu next to Clear results<\/em>. Users will be able to install and uninstall packages based on specific versions.<\/p>\n <\/p>\n In this release, we adopted a new markdown rendering engine that has helped significantly improve SQL Notebooks functionality and performance. In our tests, we have found that the improvements display and let you edit notebook content up to 5x<\/strong> faster, especially when reopening Azure Data Studio and showing previously opened notebooks.<\/p>\n In addition to this, you can now use relative paths to display images and link to other notebooks and files. For example, use [Another Notebook](.\/anotherNotebook.ipynb) to open a different notebook in the same folder as the current one.<\/p>\n There have been new keyboard shortcuts established for SQL Notebooks on Mac and Windows. Below is the list of updated keyboard shortcuts for SQL Notebooks. For a full list of all keyboard shortcuts, or to make changes, open Azure Data Studio and go to File -> Preferences -> Keyboard shortcuts.<\/p>\n\n
Announcing the SentryOne Plan Explorer extension<\/h2>\n
Highly requested features coming to schema compare<\/h2>\n
Schema compare file support (.SCMP)<\/h3>\n
Cancel support<\/h3>\n
Bug fixes<\/h3>\n
Notebook improvements<\/h2>\n
Plotly support<\/h3>\n
Open a notebook from your browser<\/h3>\n
Python package management<\/h3>\n
Performance and markdown enhancements<\/h3>\n
Keyboard shortcuts<\/h3>\n