Azure Data Studio provides the information directly. To do this within SSMS, you would need some add-ins. Users can check all actual data in a visual form to detect and troubleshoot issues quickly. It is the option used for displaying all the necessary statistics in one place. With its help, you can store the database scripts, compare versions of objects, commit changes, and roll them back from Azure Data Studio. Azure Data Studio includes an in-built Git Source Control Manager (SCM). It is also worth mentioning some other helpful Azure Data Studio features, apart from those named above: It also ensures all the existing database objects’ updating. SQL code snippets make a convenient background to ensure correct SQL syntax for databases and such objects as tables, views, stored procedures, users, roles, etc. The solution has a rich query editor, based on IntelliSense (more about it later). Another excellent feature within Azure Data Studio is the possibility to use notebooks and write SQL, Spark, Python, and Scala scripts in them. You can save the results in TXT, JSON, and Excel formats to refer to them afterwards.Īdditionally, you get to edit data, manage connections to the databases, and view database objects. You get all the required options for writing and executing SQL queries and analyzing their work and result. Convenient navigation options make code management faster and easier. Smart code snippets help you create database copies for testing and development and execute the CREATE and INSERT scenarios. Azure Data Studio connects to SQL Server 2014 and higher, PostgreSQL Servers, and, of course, Azure products, such as Azure SQL Database, Azure SQL Data Warehouse, and Azure SQL Managed Instance. That is just one of the available options. What’s more, even though the name contains “Azure”, this does not necessarily mean that it is suitable for Azure products only. The primary benefit of Azure Data Studio is its cross-platform nature as you can run it on other platforms besides Windows OS. So, to be on the safe side, you can get familiar with a comprehensive comparison of Azure Data Studio and SSMS to identify the strengths and weaknesses of both tools. Still, in some respects, Azure Data Studio, formerly known as SQL Operations Studio, is superior. If you consider whether Azure Data Studio can replace the default SSMS product, at this moment, this is hardly the case. The overview of Azure Data Studio features Its goal is to simplify the users’ daily tasks and continually improve their professional experience. This product is a lightweight modern environment for SQL code development with numerous embedded features. Azure Data Studio is one of the best-known and most popular solutions for database specialists who work with local and cloud platforms on Windows, macOS, and Linux.

Azure data studio view stored procedure