Installing Azure Data Studio

, 2018-10-31 (first published: )

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.





Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.


1,567 reads

Networking - Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...


1,530 reads

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.


360 reads