Getting Comfortable Writing Code in Azure Data Studio

Question

Post reply

Getting Comfortable Writing Code in Azure Data Studio

Steve Jones - SSC Editor

SSC Guru

Points: 736160
More actions
March 24, 2019 at 9:56 pm

#77389

Comments posted to this topic are about the item Getting Comfortable Writing Code in Azure Data Studio

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply

Marzipan Valued Member Points: 73 More actions · Answer 1

"Version Control" post will you cover checking-in individual .sql files to existing TFS TFVC projects?

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 2

The version control feature is designed to work with Git. I do not think this works with TFCVC

borge SSC Journeyman Points: 83 More actions · Answer 3

Quick question: can you write queries in ADS that span two databases? How do you do that in ADS?

Marzipan Valued Member Points: 73 More actions · Answer 4

Steve Jones - SSC Editor - Monday, March 25, 2019 9:34 PM
The version control feature is designed to work with Git. I do not think this works with TFCVC

There is a way to select Team Foundation Server as the Source Control, same with Visual Code, Microsoft doesn't document it very well since they want everyone to move to the cloud.

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 5

borge - Tuesday, March 26, 2019 4:29 AM
Quick question: can you write queries in ADS that span two databases? How do you do that in ADS?

Do you mean a query that uses objects from two databases? Or execute the same query in multiple databases, like a CMS?

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 6

Marzipan - Tuesday, March 26, 2019 6:24 AM
There is a way to select Team Foundation Server as the Source Control, same with Visual Code, Microsoft doesn't document it very well since they want everyone to move to the cloud.

This has nothing to do with the cloud. I suspect they haven't prioritized work for other VCSes and are sticking with Git since many people use it, and you can use git as an interface with TFS. You can also use TFVC with Azure DevOps (cloud TFS), so they aren't achieving any benefit by ignoring this.

The extensions for VSCode aren't the same as ADS. It's possible they work, and there are VCS providers for TFVC, but I haven't tried them. I don't have a TFS server locally and haven't actually tried to use TFVC with Azure DevOps, though I need to.

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 7

Of course, if you know how to do this, I'd love to have you write an article.

Marzipan Valued Member Points: 73 More actions · Answer 8

Steve Jones - SSC Editor - Tuesday, March 26, 2019 9:55 AM
Of course, if you know how to do this, I'd love to have you write an article.

I don't know how to do it, just seen articles that say it can be done. UGH!!
Thanks anyway.

borge SSC Journeyman Points: 83 More actions · Answer 9

Steve Jones - SSC Editor - Tuesday, March 26, 2019 9:45 AM
borge - Tuesday, March 26, 2019 4:29 AM
Quick question: can you write queries in ADS that span two databases? How do you do that in ADS?
Do you mean a query that uses objects from two databases? Or execute the same query in multiple databases, like a CMS?

I mean a query that uses objects from two databases...

Ken Hiatt SSC-Addicted Points: 469 More actions · Answer 10

You commented that you thought the intellisense seemed a little buggy, but it looks to me that it's quite clever. After you typed the letter 'c' it showed a list with words "starting" with c in the various object names available. Each c is preceded by and underscore or is a change from lower to uppercase lettering indicating the beginning of a word. It's not searching for "anything containing c" it's searching for "words starting with c" that may be contained in object names. The same happens when you start typing the 'a'. I bet someone was patting themselves on the back when they showed the boss that little piece of code. 🙂

Doctor Who 2 SSCrazy Eights Points: 8194 More actions · Answer 11

I really enjoyed reading this article, Steve. I've begun using Azure Data Studio (ADS) a lot more often, frequently going to it before going to SSMS. That is because ADS gives me a much better coding experience than SSMS does. Perhaps, if I were able to use SQL Prompt it would be different. But I'm not, so ADS is just much better for me, when editing T-SQL. Just a couple of additional things.

I've used F5 in SSMS for many years. In fact, I thought that was the only way of executing a T-SQL script, if you wanted to use a keyboard sequence. I didn't even know about Control-E, until I read this article.

It is possible to save a connection to an instance on a server, without specifying a specific database. I've done that a lot. Mainly because I didn't discover, until late, that I could save a database within an instance, as a connection, in ADS.

Now for a question; what is a "server group"? I tried searching, but only got an unhelpful "GROUP BY" results.

Rod

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 12

borge - Tuesday, March 26, 2019 6:46 PM
I mean a query that uses objects from two databases...

That's just writing a query as you would any other query. That works fine.

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 13

Ken Hiatt - Tuesday, March 26, 2019 7:10 PM
You commented that you thought the intellisense seemed a little buggy, but it looks to me that it's quite clever. After you typed the letter 'c' it showed a list with words "starting" with c in the various object names available. Each c is preceded by and underscore or is a change from lower to uppercase lettering indicating the beginning of a word. It's not searching for "anything containing c" it's searching for "words starting with c" that may be contained in object names. The same happens when you start typing the 'a'. I bet someone was patting themselves on the back when they showed the boss that little piece of code. 🙂

It is clever, but in practical use, it sometimes gives me lots of things I wouldn't want and is less helpful in terms of making it easier to write code. I'm biased towards SQL PRompt, but it is harder in practical use.

Steve Jones - SSC Editor SSC Guru Points: 736160 More actions · Answer 14

Doctor Who 2 - Tuesday, March 26, 2019 8:53 PM
Now for a question; what is a "server group"? I tried searching, but only got an unhelpful "GROUP BY" results.

It's a logical grouping of server connections inside the Server menu item on the side. Once you get hundreds of databases/servers, grouping them becomes an easy way of finding things.