DEV Community

loading...

Discussion on: Should I install SSMS on a server running SQL Server?

Collapse
kaysauter profile image
Kay Sauter

I 100% agree with this. I'd like to make just one more addition: You should consider if you really need to install SSMS or if you could just install Azure Data Studio. I think for many DEV server you actually could take ADS which does have some interesting features that SSMS does not. Of course, I did NOT say that you shouldn't install SSMS on the server hosting SQL Server instance, but just on DEV servers. My point is, ADS is still so new that it very easily gets forgotten even though it has awesome features like Notebooks.
Thanks for this great post!

Collapse
amtwo profile image
Andy Mallon Author

There's still a really big functionality gap between ADS & SSMS for a DBA. Managing Replication, Availability Groups, Agent Jobs, etc are better supported in SSMS than in ADS.

Also, I like to be able to use my Dev Environment as a testing ground for my own operational changes (like installing a patch update to SSMS). So I need to keep my Dev/Prod installs consistent to be able to test that. Using ADS on Dev & SSMS on Prod would get in my way of that.

Collapse
kaysauter profile image
Kay Sauter

Of course, that is absolutely true!
I usually also work with SSMS but I also like to work in ADS sometimes. ADS is still not really the tool for DBA yet, but it can serve for Devs and Analysts working on queries very well.
Thanks for your reply though! 😁