Installing Azure Data Studio

Azure Data Studio is the newest tool from Microsoft for working on the data platform. Last year we saw the preview release of this, called SQL Operations Studio. No one liked the name, and as the tools team at Microsoft worked to update the tool, they changed the name this year. At Ignite the rename and release was announced, and this is now a 1.x tool, available on Widows, OSX, and Linux.

If you search for Azure Data Studio, you should end up at this link:

2018-10-19 16_24_03-What is Azure Data Studio_ _ Microsoft Docs

The download link has a series of installed. You can choose installers for all the platforms, in a series of formats. I picked the Windows installer.

2018-10-19 16_24_13-Download and install Azure Data Studio _ Microsoft Docs

When you start the installer, you get a standard setup wizard. Here’s what you see, but these are all really next, next, next dialogs.

2018-10-19 16_27_17-Setup - Azure Data Studio

2018-10-19 16_27_25-Setup - Azure Data Studio

2018-10-19 16_27_38-Setup - Azure Data Studio

2018-10-19 16_27_48-Setup - Azure Data Studio

2018-10-19 16_28_00-Setup - Azure Data Studio

2018-10-19 16_28_10-Setup - Azure Data Studio

2018-10-19 16_29_00-Setup - Azure Data Studio

Running the Program

When you start Azure Data Studio, it opens with a large pane and a connection dialog. Before I can do anything, I need to connect.

2018-10-19 16_40_57-Azure Data Studio

I need to provide details, as expected, but I can optionally group my connections into a name. This is similar to the Registered Servers grouping I can do in SSMS. Here I’ve filled out some details, and given my connection a nickname for quick connections in the future.

2018-10-19 16_42_22-Azure Data StudioOnce I click Connect, I get a dashboard when ADS makes a connection. At a glance, I can see a few things. This is the “Manage” widget that Microsoft provides. You can make your own if you like.

2018-10-19 16_43_30-2017Sandbox_sandbox - Azure Data Studio

There are some mappings for keyboards, and CTRL+N (of File | New Query) gets me a query window. Some basic intellisense is here.

2018-10-19 16_55_26-● SQLQuery1 - Azure Data Studio

It’s no SQL Prompt, which I miss when I use this tool.

2018-10-19 16_55_34-● SQLQuery1 - Azure Data Studio

CTRL+E doesn’t work, so I need to click the arrow to run the query. That’s OK, but it’s not ideal. Fortunately, there’s an extension to help here.

The results are slightly odd for me, since I’ve used SSMS for so long, but they work fine.

2018-10-19 17_02_15-● SQLQuery1 - Azure Data Studio

There is a column of icons on the left, the top of which is my list of server connections. If I click this, I see the list on the left side.

2018-10-19 16_58_21-● SQLQuery1 - Azure Data Studio

There’s lots more to do here, and you should experiment with this if you want a lightweight query tool. I’ll do a bit more work here, and see what I think, but I’m not sold on this for now as any sort of replacement for SSMS. I don’t know if MS will go that way, but for now, this still feels fairly bare bones.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Blog and tagged , . Bookmark the permalink.

4 Responses to Installing Azure Data Studio

  1. Brian K says:

    Does F5 work to run a query? I’m still living the Ctrl-E life myself, but I know SSMS has the two ways.

  2. Chris Fair says:

    I’ve recently switched to a Mac and am playing around with Docker and SQL 2017 for Linux on it. I just installed this the other day and am fumbling my way around. Having spent years on Windows and SSMS, this is taking some time to get used to. I think Azure Data Studio is just okay for now and I really hope they flesh it out some more so I can use it more efficiently in the future.

    • way0utwest says:

      I’d agree. For now it’s an odd structure, not quite like VS Code and certainly not like SSMS. It takes some getting used to, and I’m also not sure how well it really works for me.

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 )

Google+ photo

You are commenting using your Google+ 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

This site uses Akismet to reduce spam. Learn how your comment data is processed.