For now, Management Studio remains the flagship program for data professionals and is technically more capable, especially when it comes to some of the highly specialized maintenance tasks that database administrators need to perform on SQL server.
Azure Data Studio does perform many of the same tasks as Management Studio.
Now, if you have experience working with SQL server databases, you might be thinking that this sounds a lot like SQL Server Management Studio or SSMS. Once a connection is established, Azure Data Studio provides a number of tools to help you interact with that server, write queries and execute other management commands, review and edit data, and ensure that the server is in good operational health. Its primary tool set allows you to connect to the full assortment of data platforms based on Microsoft's SQL server and Azure SQL Database Technologies as well as additional relational databases through optional add-on extensions. Azure Data Studio is a modern cross-platform management tool for working with databases. Let's kick off this course by talking about what exactly Azure Data Studio is.
