MS SQL Server is just a nuisance that we need to stick to when dealing with legacy environments.
What do you like best about the product?
AWS is a nice environment, and very configurable, but the experience with MS SQL Server is not good enough. The management of resources and scale are simple, practical and intuitive (although it lack some triggers on AWS side to not scale the cost too quickly)
What do you dislike about the product?
Dealing with MS SQL Server is a true nightmare. It's pretty at the beginning, but it doesn't scale with a better performance than free alternatives such as MariaDB, and the integration with NoSQL tools (Neo4J and MongoDB) is too bureaucratic and non intuitive. I'd just recommend SQL Server if there's too much work in transfering the environment to other DBMS.
What problems is the product solving and how is that benefiting you?
I had a system already running on SQL Server that needed to be moved to cloud (due to storage costs not scaling fast enough). The primary usage was to get information for data prediction, which I had to model in NoSQL environments, and migrating it to MariaDB wasn't a viable alternative. The queries to connect SQL Server to our environment, however, were terrible. I found no benefits other than not migrating the entire DB to another DBMS.
There are no comments to display