[HideousKojima]

I've also had queries (usually really large ones) run without issue in SSMS but crash Azure Data Studio. The only advantages that Azure Data Studio really has over SSMS is that it's a lot snappier (unless you're working with really large queries) and it has a dark mode. Other than that SSMS seems better in just about every way still.

[WorldMaker]

SSMS is also a multi-GB install full of stuff not useful to anyone who isn't a 100% fulltime DBA versus Azure Data Studio is barely more than the usual Electron app install footprint and leaves the lesser needed functions to plugins/extensions, and ADS supports cross platform work (the above commenter mentions working on macOS) where SSMS is not cross platform at all. Azure Data Studio has plenty of advantages over SSMS.

As a developer, I understand my need to have all 20-120+ GBs of Visual Studio installed, but between SSDT in Visual Studio and Azure Data Studio, I am happy to avoid spending all that hard drive space on SSMS for features I don't need as a developer.