{"id":26698,"date":"2019-03-18T12:30:19","date_gmt":"2019-03-18T19:30:19","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?p=26698"},"modified":"2024-12-23T10:11:40","modified_gmt":"2024-12-23T18:11:40","slug":"the-march-release-of-azure-data-studio-is-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2019\/03\/18\/the-march-release-of-azure-data-studio-is-now-available\/","title":{"rendered":"The March release of Azure Data Studio is now available"},"content":{"rendered":"\n
We\u2019re excited to announce the March release of <\/strong>Azure Data Studio<\/strong><\/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 Please note: <\/strong>If you\u2019re currently using the preview version of SQL Operations Studio, and would like to retain your settings when upgrading to the latest version, 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 multi-database<\/strong>, 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 The key highlights for the March release include:<\/p>\n\n\n\n For the list of complete updates, refer to the Release notes.<\/a><\/p>\n\n\n\n When Azure Data Studio was released, it was with the intent and vision of creating a unified experience and supporting users in their choice of platform and data provider. Today we’re happy to take an important step forward in that direction with the release of preview support for PostgreSQL in the product<\/a>, adding both on-premises and Azure Database for PostgreSQL to its existing support for SQL Server, Azure SQL Database, Azure SQL Managed Instance, Azure SQL Data Warehouse, and SQL Server 2019 big data clusters.<\/p>\n\n\n <\/p>\n\n\n\n As the community\u2019s #1 most requested feature<\/a>, we’re excited to bring the innovative features we’ve built in Azure Data Studio over the past year to the PostgreSQL community. With support for PostgreSQL, we can officially state that Azure Data Studio is a multi-database<\/strong>, cross-platform tool for managing data.<\/p>\n\n\n\n The PostgreSQL extension in Azure Data Studio empowers users with their database development. The Azure Data Studio extension for PostgreSQL is backed up with a Tools API service that provides data management and high performant query execution capabilities. Azure Data Studio also offers a modern, keyboard-focused PostgreSQL coding experience that makes your everyday tasks easier with built-in features such as:<\/p>\n\n\n\n In addition, users can run on-demand SQL queries, view and save results as text, JSON, or Excel. You can also leverage an Edit data UI, organize your favorite database connections, and browse database objects in a familiar object browsing experience.<\/p>\n\n\n\n The extension marketplace for Azure Data Studio makes it easy for developers and partners to build and contribute back into the open source ecosystem. PostgreSQL for Azure Data Studio will be a Microsoft offered extension empowering PostgreSQL developers to not only use a modern tool for their database development but also enable them to contribute back into the ecosystem to build further experiences.<\/p>\n\n\n\n We’re making the PostgreSQL extension experience open source under the MIT license and will seamlessly allow users to connect to all PostgreSQL databases independently if they’re running on Azure (Azure Database for PostgreSQL) or on-premises. Microsoft is committed to providing a great PostgreSQL developer experience through Azure Data Studio and empowering every PostgreSQL developer in the world to enhance their database experience and build richer applications.<\/p>\n\n\n\n To learn more about the PostgreSQL extension, you can visit our extension documentation<\/a> or <\/a>visit our extension GitHub repository<\/span><\/a> to file issues or feature requests.<\/span><\/p>\n\n\n\n <\/p>\n\n\n\n With the excitement of PostgreSQL joining Azure Data Studio, we haven\u2019t forgotten about our passionate SQL Server users.<\/p>\n\n\n\n Today we’re excited to offer the first public preview of SQL Notebooks. Notebooks are a combination of human-readable and executable documents that allow rich text, images, code, and result sets to easily be shared. This is a concept that is widely used in data science and we feel is well suited to SQL work. With a notebook, you can easily interleave written instructions, analysis, diagrams, and even animated GIFs using markdown, then add code cells with the SQL code to be executed.<\/p>\n\n\n <\/p>\n\n\n\n Early users have described to us many use cases they envision for SQL Notebooks, including:<\/p>\n\n\n\n We\u2019re excited to learn what the community can do with them!<\/p>\n\n\n\n The SQL Notebook functionality is now built into the base of the Azure Data Studio product, requiring no additional extensions or downloads in order to connect to servers and execute and save SQL result sets. You can get started with SQL notebooks just like a regular query editor. If you would like to use any other language such as Python, R, or Scala, you\u2019ll be prompted to install some additional dependencies on the first use.<\/p>\n\n\n\n Oh, and it also works for PostgreSQL!<\/p>\n\n\n <\/p>\n\n\n\n To see a live demo of SQL Notebooks, check out Vicky Harp and Chris LaFreniere\u2019s demo at SQL Bits.<\/a> (SQL Notebooks starts at 20:30).<\/p>\n\n\n\n To get started with SQL Notebooks, view our tutorial on our Microsoft docs.<\/a> If you have ideas of what you would like to see in SQL Notebooks or submit bugs, please submit an issue on the Azure Data Studio GitHub repository.<\/a><\/p>\n\n\n\n The well-known PowerShell extension<\/a> from Virtual Studio (VS) Code is now featured in the Azure Data Studio marketplace. This extension was specifically driven by the community and involved partnering with the PowerShell team to make this supported in Azure Data Studio.<\/p>\n\n\n\n Bringing in the PowerShell extension aligns with many of the automation scenarios that database administrators and developers use. With the integrated terminal in Azure Data Studio, this makes it even easier to integrate PowerShell experiences with your data.<\/p>\n\n\n <\/p>\n\n\n\n To learn more about the PowerShell extension and to submit feature requests and issues, visit the PowerShell extension GitHub.<\/a><\/p>\n\n\n\n Thanks to the great feedback from the community,<\/a> we\u2019ve been actively improving the Data-Tier Application Wizard in Azure Data Studio. This feature was originally shipped with the SQL Server Import extension<\/a>, but we\u2019ll now ship this feature as a separate extension. We did this because we plan to bring more features to make it easier to use dacpacs and bacpacs in Azure Data Studio. This extension will also be part of the Admin pack for SQL Server, which is an extension pack that allows you to quickly download many of the popular features from SQL Server Management Studio.<\/p>\n\n\n\n For those unfamiliar with the Data-Tier Application Wizard, features include:<\/p>\n\n\n\n If you have features you would like to see in this extension, please feel free to leave a comment on this issue<\/a> or open a feature request on our GitHub Issues.<\/a><\/p>\n\n\n\n We\u2019re always looking to support community members who are interested in building extensions for Azure Data Studio and having their extension featured in our extension marketplace. If you are interested in building extensions, you can get started here.<\/a><\/p>\n\n\n\n This month, Phil Scott built the Queryplan.show extension for Azure Data Studio. This extension adds integration support to visualize query plans using the community extension Queryplan.show that Phil also created.<\/p>\n\n\n <\/p>\n\n\n\n We asked Phil about his experience and he shared this:<\/p>\n\n\n\n \u201cThe extension stems from some ideas I have had floating around on how to change how we view query plans. I was first getting into serious SQL Server work 20 years ago when I first saw the graphical execution plan, and I remember how excited I was that I could easily see the inner working of how SQL Server was running my plans. But the visualization really hasn’t changed all that much since then. A few coats of paint here and there but it really hasn’t rocked the boat. So, I created a website that gave me an opportunity to try out some different visualizations for the query plans. I’m able to take ideas like “what if the query plan had the data operations on the left hand of the chart instead of scattered about on the right hand side” or “how can I view all the costs of the operators on one chart without having to scroll all over the place.” In addition to visualizing the whole plan, I’ve been trying to create specific operation displays. This way I can show the fields that are important to an Inner Join<\/em> differently than the way an Index Scan<\/em> would be displayed.<\/p>\n\n\n\n While I was getting closer to having visualizations that I was happy with, I was far from happy with how to get your plans into the site. It required users to paste in the XML of the query plan or uploading a saved sqlplan file. I briefly looked into the extensibility of SSMS but I was quickly in over my head there. Looking at the extensibility of Azure Data Studio was another story. I was able to get the extension running thanks to the WebView component in about 4 hours<\/strong>. Now with a few clicks you can load up the visualization within Azure Data Studio right from your query plan. I’m looking forward to future releases where hopefully the visualization with show by default when running an Explain operation.\u201d<\/p>\n\n\n\n You can get this extension from our Azure Data Studio marketplace. To submit issues or feature requests, you can visit the GitHub repository.<\/a><\/p>\n\n\n\n As we build new features into Azure Data Studio, we periodically refresh Azure Data Studio with stable and mature VS Code releases. This allows Azure Data Studio users to get the latest UI features implemented in VS Code.<\/p>\n\n\n\n Here are the latest refresh updates from the July release (1.26.1<\/a>) to the November release (1.30.2<\/a>) of VS Code. This includes many UI updates and you can get the full release notes by going to the respective release pages from August-November 2018.<\/a> Highlights include:<\/p>\n\n\n\n We will continue to bring VS Code refreshes into Azure Data Studio. Let us know if there are feature gaps you feel are missing.<\/p>\n\n\n\n Over the last few releases, we\u2019ve been moving features from the SQL Server 2019 preview extension into the core Azure Data Studio tool such as Notebook support. Here is a summary of the features moved into the core tool and bug fixes made to the External Data wizards.<\/p>\n\n\n\n If you would like to help continuing to 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 know we are working on it. Your votes on issues helps us prioritize.<\/p>\n\n\n\n Please see the full list of bug fixes<\/a> for the March release to learn more.<\/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 March 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. Please note: If you\u2019re currently using the preview version of SQL Operations Studio, and would like to retain your settings when upgrading to the<\/p>\n","protected":false},"author":5562,"featured_media":26239,"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,2391],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-26698","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","product-azure","product-azure-data-studio","product-azure-sql-database","content-type-updates","review-flag-1-1593580431-15","review-flag-2-1593580436-981","review-flag-3-1593580441-293","review-flag-4-1593580446-456","review-flag-alway-1593580309-407","review-flag-free-1593619513-128","review-flag-integ-1593580287-179","review-flag-lever-1593580264-545","review-flag-new-1593580247-437","review-flag-publi-1593580761-761"],"yoast_head":"\n\n
PostgreSQL extension for Azure Data Studio<\/h2>\n\n\n\n
<\/figure>\n\n\n\n
\n
SQL Notebooks<\/h2>\n\n\n\n
<\/figure>\n\n\n\n
\n
<\/figure>\n\n\n\n
PowerShell extension<\/h2>\n\n\n\n
<\/figure>\n\n\n\n
SQL Server dacpac extension<\/h2>\n\n\n\n
\n
Community extension highlight: Queryplan.show<\/h2>\n\n\n\n
<\/figure>\n\n\n\n
Visual Studio Code Refresh from 1.26.1 to 1.30.2<\/h2>\n\n\n\n
\n
SQL Server 2019 Preview extension<\/h2>\n\n\n\n
Changes in release 0.11<\/h3>\n\n\n\n
\n
\n
Bug fixes and feedback<\/h2>\n\n\n\n
Contact Us<\/h2>\n\n\n\n