Query tab toolbar should show current connection/db status and name

[richardtallent-erm]

Currently, it is impossible to tell whether the tab for an open SQL file is connected to a database or not, and if so, which database.

• The Connect button should have a different color when a connection has been established
• If the connected server and database match one of the saved connections, that profile name should be shown in the toolbar. If not, at least the name of the database should be shown.

I'm moving over from ADS, and so far this has been my biggest concern in using this extension -- My team and I manage a number of databases and multiple environments for each, so it's pretty critical to know which tab is connected to which database at any given moment.

[ClintThtSpn]

this should be standard functionality, we need an easy way to see the server and database of the current query. If we are forced to move away from ADS, then VS Code needs the same features.

[richardtallent-erm]

I did notice that it shows up in the footer, but there's no pattern-matching to translate the bare hostname and db name (both of which can be rather long and thus truncated in the footer) into the connection profile alias. Still, I think up in the tools where you change the connection would be a better place for it. Or a whole separate toolbar, like ADS.

[ClintThtSpn]

Thanks, that's helpful. On a large monitor, it's just so far in the bottom corner I didn't notice it. The option to change the placement would probably be enough for me.

[ashowalt]

I also didn't see it in the lower corner. It is helpful that it exists, but it needs to be more prominent. It would also be extremely helpful to be able to change the tab colors based on the connection so we can tell at a glance if a connection is to a Production or Development server.

[cssuh]

Closing this as a duplicate of #18682. We are planning to address this in our next release.