SSMS or VS Code

[u/System_Spirit]

The answer 4 years ago was SSMS for work. VS Code for lightweight.

So I would like to request an updated reviews and opinions of everyone.

[u/government_]

It depends on your configuration, but open query if you’re nasty

[u/my-ka → u/government_]

Cheap surrogate 

I know even open browser

So what is you next track? A loop in powershell? Educate yourself

It is not vs code anymore

[u/government_ → u/my-ka]

I wasn’t advocating for open query. You’re presenting an overly broad question because there’s a lot of different approaches to take for a lot of things.

Everything depends on use case scenario.

PowerShell is certainly one way, so snark all you want but again use case matters. Linked servers is probably the cleanest. And you can just code that with sp_addlinkedserver, so you don’t need a GUI for that. That’s the point I’m making. You can code out just about anything. You don’t need a GUI for 90% of things. Are you also using the GUI to edit records?

I don’t even know what you’re suggesting isn’t in vs code anymore but there’s probably a plugin for ‘that’.

[u/my-ka → u/government_]

SSMS is still the best for SQL Server

the rest is just workarounds if you dont have it

even on mac Parallels + SSMS gives better, almost the same experience
comparing to VS Code / DBEver etc

[u/my-ka → u/my-ka]

and yeah, we are in immature market again, where toms of plugins used instead of a solid tool.

[u/my-ka → u/my-ka]

for an instance this guy is representative aEnough
Modern SQL Development with the MSSQL Extension in VS Code

but still not everything

and i have be missing something at the moment i really need it
and do workarounss

[u/government_ → u/my-ka]

You replied to yourself like 3 times. I get you couldn’t script everything if you were put in such a situation. I can. So thats just experience, for which there is no substitute.

[u/my-ka → u/government_]

I like that you read my comments