SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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.

The Voice of the DBA

Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest

Comments

Leave a comment on the original post [voiceofthedba.com, opens in a new window]

Loading comments...