Microsoft SQL Server 2016 Standard on Windows Server 2019
Amazon Web Services | 2024.04.10Windows, Windows Server 2019 Base 10 - 64-bit Amazon Machine Image (AMI)
External reviews
External reviews are not included in the AWS star rating for the product.
Microsoft sql server used for DB management.
What do you like best about the product?
Microsoft sql server is best for backend database management, we can easily configured this tool with our main code and can use for crud operation and DB changes.
What do you dislike about the product?
Some version of the Microsoft SQL Server does not have or work some of the DB features, like it, lower version of this does not have commit, stored procedure and also does not have a good debugging tool.
What problems is the product solving and how is that benefiting you?
The first and best benefit is, that it is a free tool and also using this we can solve our daily basis problems with DB management, it is used for DB management of any product.
- Leave a Comment |
- Mark review as helpful
The web version of Microsoft's greatest database server on their most feature-packed and secure OS
What do you like best about the product?
The web version of SQL Server is always good for using on a web server, offering you and your .NET developers a database server they're comfortable with at reduced licensing costs. SQL Server 2016 introduced a lot of great new features, and SQL Server 2019 offers you vast security (such as headless mode, and modern updates) to ensure your web host is protected.
What do you dislike about the product?
Licensing has got more complex, and of course, there's always an additional fee to pay for hosting when using Microsoft vs. open source products - but the trade-off is you will find many more .NET / SQL devs than others.
What problems is the product solving and how is that benefiting you?
We used SQL Server 2016 Web on Windows Server 2019 for our web hosting on an AWS server.
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.
Wrong image!!!! Deploying SQl express instead of SQL standard
as 2019.03.13 version Really bad image, It says SQL server standard but its deploy express version. Didnt realize it until my client complain about using Sql agent. This is a real risk,
showing 1 - 4