Blog Post

Launching ADS from SSMS

,

If you haven’t heard, SSMS v18 went GA (Generally Availability) recently. You can download it from Microsoft, though if you have a preview version, you do need to uninstall that. You also have to reboot after install Sad smile

There is one cool feature that’s easy to miss, and I wanted to point it out.

Azure Data Studio

I am warming to Azure Data Studio (ADS) as an editor. I like notebooks, and I’m hopeful SQL Prompt will come soon, but it’s a nice, lightweight editor. It’s based on Visual Studio Code, and I like some things, like version control.

Others I find annoying, like the connection dialogs, the results display, trying to use the Object Explorer, and more. That means I am often still using SSMS as a primary tool to work with SQL Server.

Switching between tools is sometimes a pain, but things got easier.

SSMS Integration

With SSMS v18, there’s a small item that you may easily miss. If I right click a database, I see this:

2019-04-25 09_51_17-SQLQuery12.sql - 192.168.1.35.sandbox (sa (58))_ - Microsoft SQL Server Manageme

I have the option to launch ADS with a new query or notebook. The connection context passes along, which is nice. I hate the connection dialog in ADS.

If I click “New Query”, I see this:

2019-04-25 09_54_29-SQLQuery_1 - disconnected - Azure Data Studio

Hmm, an error? No, this is actually good. The connection was SQL Auth to a Linux instance. I haven’t saved the password, so the current context can’t be passed. This is a new connection, and needs to authenticate. This is what I’d expect. When I click OK, I drop into the password box.

2019-04-25 09_54_36-SQLQuery_1 - disconnected - Azure Data Studio

Even if I’ve got a connection, if I go back to SSMS an open either a new query or notebook, I get the same result.

If I have a Windows Auth connection, and I right click and choose New Query, I get this:

2019-04-25 09_59_58-SQLQuery_1 - Plato_SQL2017.MLDemo (Integrated) - Azure Data Studio

In this case, I was connected to PlatoSQL2017 as the instance and right clicked the MLDemo database. I also had ADS closed, with the notebook tab open when it closed. ADS restored my tab and then connected to the new database.

A little thing, but a handy one that I expect more people will use over time.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating