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.

queryeditor.JPG

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.

connectazure.JPG

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

quickssms.JPG

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).

editdata.JPG

Note: A preview signup acknowledgment is needed

Here you can update, delete and create new rows.

UPDATEROW.JPG

Advertisement

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:

WordPress.com Logo

You are commenting using your WordPress.com 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