With the March release of Azure Data Studio, Microsoft has added support for PostgreSQL extension, SQL Notebooks, PowerShell extension, and a number of more features to the platform.
Microsoft had released the platform under the name SQL Operations Studio, but then changed it to Azure Data Studio. It is a multi-database, cross-platform desktop environment for data professionals who use on-premises and cloud data platforms on Windows, MacOS, and Linux.
Data Studio provides a modern editing experience to manage data across multiple sources. The editor features fast IntelliSense, code snippets, source control integration, and an integrated terminal.
Microsoft updates the platform on a monthly basis. And this month, Data Studio has got the preview support for PostgreSQL. It already supports SQL Server, Azure SQL Database, Azure SQL Managed Instance, Azure SQL Data Warehouse, and SQL Server 2019 big data clusters.
“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,” wrote Alan Yu, Program Manager, SQL Server, in a blog post.
Second, SQL Notebooks (preview) is now available in Azure Data Studio. The new support will allow users to easily interleave written instructions, analysis, diagrams, and animated GIFs using markdown. They can then add code cells with the SQL code to be executed.
Third, Microsoft has now featured the PowerShell extension from Virtual Studio Code in the Azure Data Studio marketplace.
Fourth, the company has improved the Data-Tier Application Wizard with the addition of SQL Server dacpac as a separate extension.
Fifth, the Queryplan.show extension is coming to Data Studio which will add integration support to visualize query plans. Users can get this extension from the Azure Data Studio marketplace.
Additionally, Microsoft has released updates to the SQL Server 2019 preview extension in Data Studio and fixed a number of bugs.