Azure Data Studio is a free Microsoft tool, initially called as SQL Operations Studio.
It is used to manage SQL server databases & cloud-based Azure SQL Database & Azure SQL data ware house systems.
It is a Light weight software designed to make routine database development, querying & administration work easier than SSMS software.
Aimed not only at DBA but also at software developers & other Non-DBAs who manage databases.
Also referred as SQL Ops Studio earlier, offers a consistent user experience across Windows, Linux, MacOS clients.
Remain in preview mode from Nov 2017 to Sept 2018.
After that Product made available & named as Azure Data Studio.
Features of ADS
ADS uses Microsoft Visual Studio code source code editor as its foundation.
It provides a set of T-Sql code snippets used to streamline the process of writing T-Sql statements.
Code snippets are templates that generate the T-Sql syntax needed to perform different administrative actions — Like updating existing database objects to create new databases, tables or views.
Ability to create Insight Widgets, that visualize the results T-Sql queries to make it easier for DBAs & other users to see what’s happening in databases.
ADS supports SQL server from 2014 to 2019.
ADS vs SSMS