Azure Data Studio
- Lightweight - Multi-database desktop tool
- Cross-platform - Windows, macOS, and Linux
- Open-source - Source code on GitHub
Supporting Database Development
- Script database objects
- Import flat files
- Compare database schemas
- Manage SQL database projects
Database Connections
- SQL Server
- PostgreSQL
- SQL Server Big Data Cluster
- Azure SQL Database
- Azure SQL Managed Instance
- Azure Database for PostgreSQL
- Azure Synapse Analytics
- Azure Data Explorer (Kusto)
Main Components of Azure Data Studio
- Connections
- Dashboards
- Object Explorer
- Query Editor & Query Results Viewer
- Notebooks
- Extensions
Other Components of Azure Data Studio
- Command Palette
- Integrated Terminal
- Source Control
- Accounts
- Settings
- Deployment Wizard
T-SQL Statements and Categories
Data Manipulation Language
SELECT INSERT UPDATE DELETE MERGE
Data Definition Language
CREATE ALTER DROP