Yes! Especially if your application is legacy/old and requires Windows anyway. I used to think why people would do that when you can dockerize SQL Server and just use Debian or Fedora or whatever but I once tried that on a legacy application and things... were not quite right.
It was easier to install on Windows than to debug the issue so I just let it go.
I think things would be different if the code was new or I was familiar with it enough to anticipate how it could break in different ways.
If the code/framework is new enough, it might be worthwhile diving into that rabbithole.
But you need SSMS on a Windows client to manage it effectively. Unless you are doing everything cli, which is just not practical in the enterprise. Anyway, running it in Linux is pretty niche. Cool for show and tell, but you need balls of steel if you're going to try running even a small $100 million dollar business on it.
Last I checked, Azure data studio did not have feature parity with SSMS. Sure you can write TSQL, view and edit procedures. But that’s about where it ends.
You can’t deploy SSIS packages, can’t edit user accounts and permissions, can’t manage linked servers, etc. Sure you might not do those every day, but if you have to jump through all these hoops to do something I wouldn’t call ADS a full replacement.
ADS can't really do this, as others have mentioned. Years in the future, they will get there. It's not remotely capable yet. And even many of the dialogue boxes that they've added recently are just opening in SSMS which still requires Windows.
