Microsoft SQL Server 2019 Standard on Windows Server 2019 Reviews & Product Details

It is easy to go tool for my data requirements. Have worked on postgres as well in the past but this Microsoft SQL server RLS feature and integration with third party extension make it a wow product. Review collected by and hosted on G2.com.

Can be enhanced for read heavy operations Review collected by and hosted on G2.com.

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.

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.

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.

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.

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

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

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.

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

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.

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.

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

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.

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.

Till now there are some small things I have faced during using Microsoft SQL Server 2019 Standard like memory and others, 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.

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

Enterprise edition is expensive. Licensing process is bit complex. Review collected by and hosted on G2.com.

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

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.