How to connect to Azure SQL Database using Azure Data Studio?
Azure Data Studio is a very powerful tool to connect and manage an SQL Database in Azure. The most important part is that it would also allow to take a Profiler from the SQL Database. To use, follow the below procedure:
- Download Azure Data Studio from here
- Once installed, open it and a prompt will be shown. Introduce the Server Name, along with the Username + Password:
- Next step will be to sign-in using an Azure Account and to add the local machine's IP to the Azure SQL Firewall:
- The Tool uses the SQL language, so queries using the T-SQL language can be used, just as in SSMS (SQL Server Management Studio).
Useful plugins to troubleshoot SQL issues, using Azure Data Studio:
- SQL Server Profiler:
- Admin Pack for SQL Server:
Is a collection of popular database administration extensions to help manage SQL Server. When downloading this pack, it will download extensions for SQL Server Agent, Profiler, Import flat files, DACPAC.
- Database Admin Tool Extensions for Windows:
This extension adds Windows-specific functionality into Azure Data Studio. Currently this functionality includes the ability to launch a set of SQL Server Management Studio experiences directly from Azure Data Studio. These experiences include SSMS Property dialogs for select object types, such as Databases, Views, Stored Procedures and the Generate Scripts Wizard
- Managed Instance dashboard for Azure Data Studio:
It provides useful insights about the Azure SQL Database Managed Instance related to performance and health of the instance
- Server Reports for Azure Data Studio:
It gives useful insights about the server related to performance. These can be used to see current activity as well as historical activity. Some of the available reports are DB Space Usage, DB Buffer Usage, CPU Utilization, Backup Growth Trend, Wait counts, and so on.
- Microsoft SQL Server Schema Compare for Azure Data Studio:
This extension provides an easy to use experience to compare .dacpac files and databases and apply the changes from source to target.