# Microsoft SQL Server 2016 Web on Windows Server 2016 Reviews **Vendor:** Amazon Web Services (AWS) **Category:** [AWS Marketplace Software](https://www.g2.com/categories/aws-marketplace) **Average Rating:** 4.1/5.0 **Total Reviews:** 12 ## About Microsoft SQL Server 2016 Web on Windows Server 2016 Microsoft SQL Server 2016 Web on Windows Server 2016 is a pre-configured Amazon Machine Image designed to streamline the deployment of SQL Server databases on Amazon EC2 instances. Built and maintained by Amazon Web Services , this AMI ensures that SQL Server is fully patched and updated within five business days following Microsoft's monthly Patch Tuesday. By launching an instance from this AMI, users can quickly set up a database server without the need for manual installation, benefiting from integrated AWS tools and drivers that enhance management and performance. Key Features and Functionality: - Pre-Configured Environment: The AMI includes SQL Server 2016 Web Edition installed on Windows Server 2016, eliminating the need for manual setup. - Regular Updates: AWS ensures the AMI is updated and fully patched within five business days after Microsoft's Patch Tuesday, maintaining security and stability. - Integrated AWS Tools: The AMI comes with AWS Systems Manager, AWS CloudFormation, AWS Tools for Windows PowerShell, and necessary network and storage drivers, facilitating efficient management and automation. - AWS Launch Wizard Support: Users can leverage AWS Launch Wizard to size, configure, and deploy SQL Server applications according to best practices, supporting both single-instance and high-availability deployments. Primary Value and User Solutions: This AMI simplifies the process of deploying and managing SQL Server databases on AWS infrastructure. By providing a ready-to-use, fully patched environment, it reduces the time and effort required for setup and maintenance. The integration with AWS management tools enhances operational efficiency, while the support for scalable and high-availability configurations ensures that businesses can adapt to varying workloads and maintain reliable database performance. ## Microsoft SQL Server 2016 Web on Windows Server 2016 Reviews ### 1. My experience with SQL Server **Rating:** 4.5/5.0 stars **Reviewed by:** Sadikshya S. | Digital Marketing Manager, Small-Business (50 or fewer emp.) **Reviewed Date:** January 16, 2024 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** What i like most about microsoft sql server is cost effectiveness supporting the web based applications and hosting scenarious.SQL Server 2016 Web Edition supports scalability, allowing businesses to scale their web applications as needed. This is crucial for accommodating growth and increasing demand without facing significant limitations.SQL Server 2016, including the Web Edition, incorporates robust security features to protect data integrity and confidentiality. This includes encryption, access controls, and auditing capabilities. **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** Depending on the scale and complexity of your web applications, SQL Server 2016 Web Edition may be resource-intensive. Businesses with high transaction volumes or complex queries may need to carefully manage server resources to ensure optimal performance.The Web Edition lacks certain enterprise-level features that are available in editions like SQL Server Standard or Enterprise. Organizations with advanced requirements may find themselves needing features that are not present in the Web Edition. **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** SQL Server 2016 Web Edition supports scalability, allowing organizations to scale their web applications as needed. This is particularly beneficial for businesses experiencing growth in web traffic or data volume.SQL Server 2016, including the Web Edition, incorporates robust security features. This helps organizations protect sensitive data and maintain the integrity and confidentiality of their databases, which is crucial for web applications dealing with user information. SQL Server Management Studio (SSMS) provides a user-friendly interface for managing and administering SQL Server databases. This ease of management is beneficial for organizations with web developers and administrators who need efficient tools for database tasks. ### 2. My experience with SQL Server 2016 Web on Windows Server 2016 **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Mid-Market (51-1000 emp.) **Reviewed Date:** August 05, 2021 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** What I like best about Microsoft SQL Server 2016 is its performance on OLTP queries. This version is stable and there is a significant improvement in in-memory queries. Also, SQL Server 2016's Stretch Database feature serves as a true link between your on-premises solution and your data in the Azure cloud. If your business goals allow it, you can offload database administration and management to the cloud with Azure SQL Database or SQL Server on Azure Virtual Machines. **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** What I least like about it is its price. The software is not suitable for small businesses because it is more expensive as compared to the other ones. However, the cost is worth it. Microsoft SQL Server 2016 doesn't support Linux. **Recommendations to others considering Microsoft SQL Server 2016 Web on Windows Server 2016:** I would like to highly recommend it. **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** I have been using this software in my organization in other to manage the database of more than 700 tables and millions of data with 800 + active users. I found this very suitable to handle such large data. It is fast and secure. I would like to recommend using this software if you require secure and fast DBMS for your large business. ### 3. Microsoft SQL Server **Rating:** 5.0/5.0 stars **Reviewed by:** Harini V. | Project Manager, Enterprise (> 1000 emp.) **Reviewed Date:** March 05, 2022 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** The questions which had asked in the assessment made me to learn few new things and that helped me to enhance the skill , competitors feel this is hard assessment to finish **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** I have nothing like dislike there is nothing that is missing or nothing like not working properly , there is nothing to be improved you people are the best and improved me **Recommendations to others considering Microsoft SQL Server 2016 Web on Windows Server 2016:** Yes I will recommend considering Microsoft SQL **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** You're dealing with an application whose newest supported version is only SQL Server 2014 , but not 2016. Or newer . you want to use Always On Availibility Groups ### 4. Scalability, security & standard commits **Rating:** 4.0/5.0 stars **Reviewed by:** Rajendra V. | IT Support Technician, Mid-Market (51-1000 emp.) **Reviewed Date:** April 04, 2022 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** Many more features like DB backup, monitoring and SQL server job creation features are also used and liked **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** I feel that they should bring a document type of database concept **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** maximum benefits to GUI application while support to provide data visibility from the back end. ### 5. Good for consolidating the data of different applications, but does take up a lot of memory doing so **Rating:** 3.0/5.0 stars **Reviewed by:** Michele C. | Financial Services Professional, Financial Services, Enterprise (> 1000 emp.) **Reviewed Date:** January 14, 2022 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** Microsoft has made it easy to export databases. It is easy to configure/implement. **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** There is no graphical report, so when you run the reports, it is all in script, which makes it hard to read. **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** It takes a lot of data from multiple sources and consolidates it into one. It helps when you have many employees that they are all working off of ### 6. Windows Server 2016 recommendation **Rating:** 4.5/5.0 stars **Reviewed by:** Venkat Manoj M. | Admin EUS, Enterprise (> 1000 emp.) **Reviewed Date:** February 28, 2022 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** In memory improvements Row level support **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** Database may face out of space error Client loses connection to the sql server **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** Provides optimized performance Better security and offers large sized database ### 7. Good experience to learning sql **Rating:** 5.0/5.0 stars **Reviewed by:** Naga L. | software Engineer II, Enterprise (> 1000 emp.) **Reviewed Date:** February 27, 2022 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** Easy to learn quiries and procedures for users **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** I don't have any thing to dislike sql server **Recommendations to others considering Microsoft SQL Server 2016 Web on Windows Server 2016:** I **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** Sql provides very fast db access to get huge data. ### 8. Very comprehensive and powerful RDBMS **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Consumer Electronics | Enterprise (> 1000 emp.) **Reviewed Date:** March 24, 2022 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** Cross platform usability along with very complete business intelligence capabilities. Ability to integrate with various applications is another added features. **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** Just need to be more developer friendly with detailed and comprehensive error message. Also need to have additional new and modern functions. **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** Storing high frequency data and a data warehouse for analytical purposes ### 9. 2016 SQL server has OLAP queries performance issues **Rating:** 3.0/5.0 stars **Reviewed by:** Avantika S. | Senior Cloud Engineer(SaaS Application), Enterprise (> 1000 emp.) **Reviewed Date:** December 24, 2021 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** The scalability option is an advantage to mission-critical applications. **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** 2016 SQL server has OLAP queries performance issues **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** SQLserver 2016 Web is being used for hosting databases and storing records, and many more. ### 10. Easy to use and install and configure and we can integrate with other applications **Rating:** 5.0/5.0 stars **Reviewed by:** Ajith P. | Associate Technology, Enterprise (> 1000 emp.) **Reviewed Date:** December 12, 2021 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** Easy to create and write queries comparing to other sql servers **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** nothing, everything is there in the best **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** Customer data and sales data and purchase data ### 11. MS_SQL server ist much easier than Oracle servers. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Banking | Mid-Market (51-1000 emp.) **Reviewed Date:** November 08, 2021 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** TOP relational databases are MS-SQL , Oracle and others. MS-SQL server has very compatible with normal companies to do their Billing System, Customer care , Data management . Oracle Database is much complicated than MS-SQL , but usually better to use big companies who has TB Data-s. **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** I will say migration Data-s to new Versions usually takes lots of time and knowledge. **Recommendations to others considering Microsoft SQL Server 2016 Web on Windows Server 2016:** Best relational database **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** Easy to optimaize, Text search is different, quick. ### 12. Great And easy to use tool **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Insurance | Enterprise (> 1000 emp.) **Reviewed Date:** October 17, 2021 **What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?** Its a great and easy to use tool for managing DB, 2016 is a more stable version with many features needed for day to day activities. Easy to adopt install etc **What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?** Some more features needed which are missing. **What problems is Microsoft SQL Server 2016 Web on Windows Server 2016 solving and how is that benefiting you?** Solving data related issues, fixing DB bugs and developing new datawarehouses. ## Microsoft SQL Server 2016 Web on Windows Server 2016 Discussions - [What is Microsoft SQL Server 2016 Web on Windows Server 2016 used for?](https://www.g2.com/discussions/what-is-microsoft-sql-server-2016-web-on-windows-server-2016-used-for) - [Will suggest to developers to learn SQL](https://www.g2.com/discussions/will-suggest-to-developers-to-learn-sql) - 1 upvote - [View Microsoft SQL Server 2016 Web on Windows Server 2016 pricing details and edition comparison](https://www.g2.com/products/microsoft-sql-server-2016-web-on-windows-server-2016/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-06+00%3A14%3A34+-0500&secure%5Bsession_id%5D=689dce8d-e5ea-4b0b-bab3-d9f4caa4db0c&secure%5Btoken%5D=9f01581afc3aa9c74a274095802f629d75a4aa95cfba92bc9920d21125e9bfa9&format=llm_user) ## Microsoft SQL Server 2016 Web on Windows Server 2016 Features **Agentic AI - AWS Marketplace** - Autonomous Task Execution - Multi-step Planning - Cross-system Integration