Azure SQL Database Connect and Query

There is a lightweight and quick way to start querying your database in Azure which doesn’t involve SQL Operations Studio or Management Studio. You can use the query editor within the Azure portal, that is, if you desire.

If you navigate to your database in question and look at the left side menu bar you will see query editor (preview) option.


When you click it you will be presented with the main menu where you will need to login.  You have the choice of SQL authentication and AAD.


For this quick example I decided to use my server admin account. Once you have entered your password click ok.


Let’s be honest, it is very limited and good enough for quick checks etc. There is an edit data section where you need to select a table for it to become active (currently greyed out).


Note: A preview signup acknowledgment is needed

Here you can update, delete and create new rows.



1 thought on “Azure SQL Database Connect and Query

  1. Pingback: Dew Drop – July 26, 2019 (#2998) | Morning Dew

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s