Microsoft SQL Server 2016 Web on Windows Server 2016 Pros and Cons

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.

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 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 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.

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.

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.

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.

I feel that they should bring a document type of database concept Review collected by and hosted on G2.com.

Microsoft has made it easy to export databases. It is easy to configure/implement. Review collected by and hosted on G2.com.

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.

In memory improvements

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

Database may face out of space error

Client loses connection to the sql server Review collected by and hosted on G2.com.

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

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

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.

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.

The scalability option is an advantage to mission-critical applications. Review collected by and hosted on G2.com.

2016 SQL server has OLAP queries performance issues Review collected by and hosted on G2.com.

Easy to create and write queries comparing to other sql servers Review collected by and hosted on G2.com.

nothing, everything is there in the best Review collected by and hosted on G2.com.