# Microsoft SQL Server 2016 Web on Windows Server 2019 Reviews **Vendor:** Amazon Web Services (AWS) **Category:** [AWS Marketplace Software](https://www.g2.com/categories/aws-marketplace) **Average Rating:** 3.9/5.0 **Total Reviews:** 5 ## About Microsoft SQL Server 2016 Web on Windows Server 2019 SQL Server on AWS has lower TCO, higher performance, and the broadest and deepest capabilities. This SQL Server Amazon Machine Images (AMI) is built by Amazon Web Services (AWS) for use on Amazon EC2, the proven, reliable, and secure place for SQL Server. ## Microsoft SQL Server 2016 Web on Windows Server 2019 Pros & Cons **What users like:** - Users praise the **performance** of Microsoft SQL Server 2016 Web for its smooth interface and scalability for various applications. (2 reviews) - Users appreciate the **easy installation and effective data management** of Microsoft SQL Server 2016 Web on Windows Server 2019. (1 reviews) - Users find Microsoft SQL Server 2016 Web on Windows Server 2019 incredibly **easy to use and install** , enhancing data management. (1 reviews) - Users appreciate the **easy installation** of Microsoft SQL Server 2016 Web, finding it user-friendly and efficient. (1 reviews) - Users appreciate the **scalability** of Microsoft SQL Server 2016 Web, effectively handling applications from small to large levels. (1 reviews) **What users dislike:** - Users find **MS SQL costly and resource-intensive** , particularly due to licensing fees and optimization needs. (1 reviews) - Users find MS SQL Server 2016 Web **not cost-effective** due to high licensing fees and resource demands. (1 reviews) - Users find MS SQL Server 2016 Web **not cost-effective** due to high licensing fees and resource demands. (1 reviews) - Users report **slow performance** in SQL Server 2016 Web, often due to fragmented indexes affecting overall efficiency. (1 reviews) ## Microsoft SQL Server 2016 Web on Windows Server 2019 Reviews ### 1. Microsoft SQL server Benefits **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** March 11, 2025 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2019?** MS SQL is the data base with smooth interface . Scales well from small applications to large level. **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2019?** MS SQL not a cost effective Need to purchase license with high cost Can consume high system resources if not optimized properly. Unlike MySQL or PostgreSQL, MS SQL is not open-source. **What problems is Microsoft SQL Server 2016 Web on Windows Server 2019 solving and how is that benefiting you?** MS SQL database is master for data engineering where we store different type in data in tabular column All developers will use this data from database to fullfill there business requirements ### 2. Very good data management **Rating:** 4.5/5.0 stars **Reviewed by:** Aishwarya T. | Staff Product Developer, Enterprise (> 1000 emp.) **Reviewed Date:** January 05, 2025 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2019?** It’s very easy to use and install. Data management is good. Its features are very helpful and time consuming **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2019?** Some common performance issues in SQL Server include fragmented indexes. To improve performance, users can review and optimize their SQL Server queries **What problems is Microsoft SQL Server 2016 Web on Windows Server 2019 solving and how is that benefiting you?** robust data management features with improved scalability and security while maintaining compatibility with existing applications ### 3. Microsoft sql server used for DB management. **Rating:** 4.5/5.0 stars **Reviewed by:** Vishal B. | Senior System Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** May 05, 2022 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2019?** 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 Microsoft SQL Server 2016 Web on Windows Server 2019?** 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 Microsoft SQL Server 2016 Web on Windows Server 2019 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. ### 4. The web version of Microsoft's greatest database server on their most feature-packed and secure OS **Rating:** 5.0/5.0 stars **Reviewed by:** David W. | Head of Engineering - Data and Business Intelligence, Small-Business (50 or fewer emp.) **Reviewed Date:** January 13, 2022 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2019?** 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 Microsoft SQL Server 2016 Web on Windows Server 2019?** 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 Microsoft SQL Server 2016 Web on Windows Server 2019 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. ### 5. MS SQL Server is just a nuisance that we need to stick to when dealing with legacy environments. **Rating:** 2.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Mid-Market (51-1000 emp.) **Reviewed Date:** December 16, 2021 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2019?** 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 Microsoft SQL Server 2016 Web on Windows Server 2019?** 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 Microsoft SQL Server 2016 Web on Windows Server 2019 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. ## Microsoft SQL Server 2016 Web on Windows Server 2019 Discussions - [What is Microsoft SQL Server 2016 Web on Windows Server 2019 used for?](https://www.g2.com/discussions/what-is-microsoft-sql-server-2016-web-on-windows-server-2019-used-for) - [View Microsoft SQL Server 2016 Web on Windows Server 2019 pricing details and edition comparison](https://www.g2.com/products/microsoft-sql-server-2016-web-on-windows-server-2019/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-13+13%3A39%3A53+-0500&secure%5Bsession_id%5D=03d1c031-0d10-422e-865a-fab5aa918519&secure%5Btoken%5D=31e3bae10511a79ca4e696985713ddcdebb3edb02f51013c5bf5a8232a6afff8&format=llm_user) ## Microsoft SQL Server 2016 Web on Windows Server 2019 Features **Agentic AI - AWS Marketplace** - Autonomous Task Execution - Multi-step Planning - Cross-system Integration