What is ADS ( Azure Data Studio)?

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

OS Support