> ## Content Index
> Fetch the complete content index at: https://www.techielass.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Query SQL with Azure Data Studio
- URL: https://www.techielass.com/query-sql-with-azure-data-studio/
- Published: 2021-11-16T09:00:00.000Z
- Updated: 2022-01-07T11:33:11.000Z
- Description: Join me as I show you how to use Azure Data Studio to query your SQL databases
- Author: Sarah Lean
- Tags: Azure SQL, SQL, SQL Server, Azure Data Studio, Tips

The official definition of Azure Data Studio is: 

> Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.

And it's a pretty awesome tool. What I want to show you is how to use it to connect to an Azure SQL database and use it to query that database. 

## Installing Azure Data Studio

The first thing you should do install Azure Data Studio, you can find the installer [here](https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver15&ref=techielass.com) or if you use Windows Package Manager you can use the command:

```CMD
winget install microsoft.azuredatastudio

```

## Connect to your Azure SQL Database

When you open up Azure Data Studio down the left hand side you'll have a menu panel, the first option looks like a server, that is the connection area. 

Click on that and you will be asked to add a connection. 

A dialog box will open up on the right hand side of your screen asking for some connection details. 

![Azure Data Studio Connection](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/09/datastudioconnection.PNG)

Azure Data Studio Connection

You will need the server name and the username and password to connect at a very basic level. You might have to provide the database or server group information depending on your database or setup. 

Once you've inputted the information hit the connect button and if you've put in the right information then you should have a live connection to the database. 

![Azure Data Studio Connected](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/09/datastudioconnected.PNG)

Azure Data Studio Connected

You can then click on the "New Query" button to query the database for information. 

## Connect through the Azure Portal

If you have Azure Data Studio installed on your machine and you are in the Azure Portal, there is a button you can use to start the creation of the connection within Azure Data Studio. 

![Azure Portal](https://storage.ghost.io/c/08/96/08960c71-63a2-449b-91b1-8d4628166dd2/content/images/2021/09/datastudioportal.png)

Azure Portal

This will fill in some of the information needed but you will have to put in some authentication details. 

## Call to Action

Azure Data Studio is a very good tool and can help you interact with SQL Server, Azure SQL DB and SQL DW. Let me know what cool features or tips you've found using it, I'd love to hear your stories.