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

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

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

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

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

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

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

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

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

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

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