+8After only a short time lived, Microsoft announced the retirement of ADS. What's Happening to Azure Data Studio? - Azure Data Studio | Microsoft Learn.
If you’re already on ADS, which toolset are you considering migrating to or are you already using another toolset? I’ve never left SSMS and am considering VS Code.
+23It hasn’t gone unnoticed here either. I have tried VS Code using the MSSQL extension, but it just lacks features that I use daily. Such as the sp_help via a shortkey when selecting a table. It seems to be not possible.
Currently I'm running the SSMS 21 Preview (with Dark mode 😏). Currently it does not support Github Copilot for example, but for the time being I run with ADS and SSMS. Best of both worlds.
+4
Sad news. I use VS Code for personal (Python)projects, but never tried it for MSSQL. Will see how it goes...
+8I'm still living onPremise which gives me the opportunity to run the Activity Monitor, see execution plans, run the profiler or record extended events and all that stuff. This is something I am missing in VS code's MSSQL extension. One could say that you don't need it for development. But for a lot of cases it sure helps a lot.
+10The new SSMS version 22 offers support for using Github Copilot. On of the largest benefits is that it allows you to use code completions.
To be old school: so far I haven’t seen a better tool then ssms (when on premise). A lot of the other available tools are missing key features. Like you said. Especially on a production system having Activity Monitor, profiler and extended events etc. is key.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
