Microsoft SQL Server 2019 Standard on Windows Server 2019 Pros and Cons

What do you like best about Microsoft SQL Server 2019 Standard on Windows Server 2019?

SQL Server 2019 on Windows Server 2019 is great because it’s fast, secure, and handles both big data and regular databases seamlessly. It’s also easy to integrate with other tools and works well for businesses of all sizes. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server 2019 Standard on Windows Server 2019?

The main downside is the cost—licensing can get expensive as you scale. Also, the Standard edition lacks some advanced features like online indexing or big data clusters, which are only available in Enterprise. Plus, it can feel resource-heavy on smaller servers. Review collected by and hosted on G2.com.

What do you like best about Microsoft SQL Server 2019 Standard on Windows Server 2019?

User interface is simple and intuitive

implementation was straightforward

Helpful support personnel

License was better than Oracle

integration into other Windows apps was simpler Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server 2019 Standard on Windows Server 2019?

preferred OS is windows. Support for linux was spotty

less performant on linux than Oracle

scheduling was clunky and unreliable

became unsuitable as we tried to use it for storing plant historical data, ingest speeds were too low Review collected by and hosted on G2.com.

What do you like best about Microsoft SQL Server 2019 Standard on Windows Server 2019?

The speed is increased compared to previous version and the security is also better Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server 2019 Standard on Windows Server 2019?

The cost of license should be affordable Review collected by and hosted on G2.com.

What do you like best about Microsoft SQL Server 2019 Standard on Windows Server 2019?

It is very good in terms of querying data it's fast and efficient and handling large data also it's very easily handling. Executing sql jobs also very easy and creating also easy. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server 2019 Standard on Windows Server 2019?

Everything good something its hang apart from that everything good Review collected by and hosted on G2.com.

What do you like best about Microsoft SQL Server 2019 Standard on Windows Server 2019?

I am using MS SQL 2019 on windows server at my current organization, it is more reliable and inbuild query tools and export tools are more enhanced when compared to other SQL Tools like Maria, postgress etc. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server 2019 Standard on Windows Server 2019?

First dislike is cost

Second one is Linux compatibility

Third dislike is Free editions lacks in even some basic features where other providers gives in basic versions Review collected by and hosted on G2.com.

What do you like best about Microsoft SQL Server 2019 Standard on Windows Server 2019?

The easy to use interface and it provide suggestions while writing queries. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server 2019 Standard on Windows Server 2019?

There is nothing as much, but in case of large number of tables, the table expansion section takes time. Review collected by and hosted on G2.com.

What do you like best about Microsoft SQL Server 2019 Standard on Windows Server 2019?

There are many things about Microsoft sql server 2019 standard, but personally some of the things are best as per my concern. Like UTF-8, big size of data cluster for industrial level, faster and better, some security features... Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server 2019 Standard on Windows Server 2019?

Till now there are some small small things in have faced during using Microsoft sql server 2019 standard like memory and other, but still I'm not facing any big problem or issues during my development work with the microsoft sql server 2019 standard. Review collected by and hosted on G2.com.

What do you like best about Microsoft SQL Server 2019 Standard on Windows Server 2019?

Online documentation, and new analytic functions help in the statistical calculation. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server 2019 Standard on Windows Server 2019?

enterprise edition is expensive. licensing process is bit complex Review collected by and hosted on G2.com.

What do you like best about Microsoft SQL Server 2019 Standard on Windows Server 2019?

It came up with Apache Spark & Hadoop Distributed system. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server 2019 Standard on Windows Server 2019?

I liked all the features of Microsoft SQL Server. be it SQL based or be it NoSql Based. Review collected by and hosted on G2.com.

What do you like best about Microsoft SQL Server 2019 Standard on Windows Server 2019?

I've been working with SQL Server for 25 years or so and love it; as a WinForms and .NET developer and DBA it's been an excellent, robust, stable, and easily used database server. SQL Server 2019 takes it to new heights with all the advancements of the last decade including query store, in-memory tables, Azure (and AWS) replication, and many other things. Windows Server 2019 is also highly advanced with container support, its GUI-less core low-attack-surface installation and more. SQL Server 2019 on Windows Server 2019 gives you a great foundation for enterprise-grade cloud-first applications. Review collected by and hosted on G2.com.

What do you dislike about Microsoft SQL Server 2019 Standard on Windows Server 2019?

Licensing can be a nuisance to figure out, and can also be expensive when based on cores. Review collected by and hosted on G2.com.