It's been two months since this profile received a new review

Microsoft SQL Server 2016 Web on Windows Server 2016 Reviews & Product Details

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.

Seller

Amazon Web Services (AWS)

Discussions

Microsoft SQL Server 2016 Web on Windows Server 2016 Community

Product Description

G2 reviews are authentic and verified.

Here's how.

Sadikshya S.

Digital Marketing Manager

Small-Business (50 or fewer emp.)

1/16/2024

"My experience with SQL Server"

4.5/5

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

8/5/2021

"My experience with SQL Server 2016 Web on Windows Server 2016"

4/5

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Recommendations to others considering Microsoft SQL Server 2016 Web on Windows Server 2016:

I would like to highly recommend it. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Harini V.

Project Manager

Enterprise (> 1000 emp.)

3/5/2022

Business partner of the seller or seller's competitor, not included in G2 scores.

"Microsoft SQL Server"

5/5

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 Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

Recommendations to others considering Microsoft SQL Server 2016 Web on Windows Server 2016:

Yes I will recommend considering Microsoft SQL Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

Rajendra V.

IT Support Technician

Mid-Market (51-1000 emp.)

4/4/2022

"Scalability, security & standard commits"

4/5

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 Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

Michele C.

Financial Services Professional

Financial Services

Enterprise (> 1000 emp.)

1/14/2022

"Good for consolidating the data of different applications, but does take up a lot of memory doing so"

3/5

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.

Venkat Manoj M.

Admin EUS

Enterprise (> 1000 emp.)

2/28/2022

"Windows Server 2016 recommendation"

4.5/5

What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?

In memory improvements

Row level support Review collected by and hosted on G2.com.

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 Review collected by and hosted on G2.com.

Naga L.

software Engineer II

Enterprise (> 1000 emp.)

2/27/2022

"Good experience to learning sql"

5/5

What do you like best about Microsoft SQL Server 2016 Web on Windows Server 2016?

Easy to learn quiries and procedures for users Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server 2016 Web on Windows Server 2016?

I don't have any thing to dislike sql server Review collected by and hosted on G2.com.

Verified User in Consumer Electronics

Enterprise (> 1000 emp.)

3/24/2022

"Very comprehensive and powerful RDBMS"

4.5/5

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. Review collected by and hosted on G2.com.

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. Review collected by and hosted on G2.com.