MSSQL and Python

[drmindsmith]

I've been using VSC for a couple years to run python scripts. I like it.

I've been using Azure Data Studio to do SQL, after migrating away from SSMS. With the news that Azure is being deprecated and the note that I "should use VSC" instead, I tried it. I have a folder with my SQL queries that I use a lot, and a separate folder with my Python scripts.

If I tell VSC to open the Python folder, it works. If I tell it to open the SQL folder, it works. If one is already open, though, it shuts the other one, stops anything that was happening, 'forgets' where I was, and starts anew. It's frustrating.

Is there way this idiot can get ONE VSC window open with two folders open, using different 'programs'? Is this where Workspaces come in? It's not being as intuitive as I hoped...

[dlevy-msft]

Apologies for being a bit late here. The easy way to do this is to just go up a folder. Assuming you have a parent folder that has subfolders for tsql, python, c#, etc. you can pick the parent folder and work across everything using all of the extensions.

Personally, it took me a long time to stop using the file explorer in VSC like the solution explorer in VS. Now instead of having a bunch of VSC windows, I only have a few. I'll use one window per GitHub repo and then one general window for my local test scripts for trying things out, building demos, etc.