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

MS SQL is the database with a smooth interface. Scales well from small applications to large level. Review collected by and hosted on G2.com.

MS SQL is not cost-effective. Need to purchase a license at a high cost. Can consume high system resources if not optimized properly. Unlike MySQL or PostgreSQL, MS SQL is not open-source. Review collected by and hosted on G2.com.

It’s very easy to use and install. Data management is good. Its features are very helpful and time consuming Review collected by and hosted on G2.com.

Some common performance issues in SQL Server include fragmented indexes. To improve performance, users can review and optimize their SQL Server queries Review collected by and hosted on G2.com.

Microsoft SQL Server is best for backend database management, we can easily configure this tool with our main code and can use it for CRUD operations and DB changes. Review collected by and hosted on G2.com.

Some versions of Microsoft SQL Server do not have or work with some of the DB features. For example, lower versions do not have commit, stored procedures, and also lack a good debugging tool. Review collected by and hosted on G2.com.

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

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

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

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 transferring the environment to other DBMS. Review collected by and hosted on G2.com.