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 - (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 Plato\SQL2017 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.

About way0utwest

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