SQL Server 2019 Pros and Cons

Advanced indexing and optimized data retrieval in SQL Server 2019 which enhances the handling of complex queries. The integration with .NET Core is smooth which is favorable for backend development as well as for performance-driven applications. Review collected by and hosted on G2.com.

It can be difficult, particularly for smaller projects, dealing with advanced features.It has high licensing costs as well. Review collected by and hosted on G2.com.

Ease of use ,I say. Quite simple. Can be easily synced with various tools like anaconda and Power bi Review collected by and hosted on G2.com.

Installation is bit troublesome with organisation hardwares Review collected by and hosted on G2.com.

It makes data management smart and simple. One great feature is its compatibility with big data, allowing you to manage both conventional and super sized data in one go. Optimizing query performance through adaptive processing and automatic plan correction has advanced significantly with the introduction of Intelligent query processing. It functions similarly to an extremely intelligent assistant that continuously improves at responding to your inquiries about data. Easily integrates with other data sources. Review collected by and hosted on G2.com.

The cost of licensing could be high, particularly for organizations with tight budget constraints. Users transitioning from earlier versions might encounter a learning curve due to new features and changes in functionality. Review collected by and hosted on G2.com.

SQL server 2019 fits my company very well. Installation is easy. It's right choice for medium size companies. Overall the quality is good. It can store a huge number of data. Review collected by and hosted on G2.com.

It's necessary a good server computer to install a SQL Server 2019. When the database is large it gets hard to make backup by sql agent. This version requires to install management studio independently. Review collected by and hosted on G2.com.

SQL server 2019 is good for the performance tuning purpose. We have now multiple new feature in AON. We have recived multiple updates in tuning like resumable online index create. Review collected by and hosted on G2.com.

I'm using it on a daily basis all the updates have some issue but they are fixed with the cu updated, so overall it looks good. In the latest virsion of SQL server we have a connectivity for azure that is the plus point. Review collected by and hosted on G2.com.

It's wonderful platform to store all the largest information. It is much more faster while fetching existing data and reduce complexity of data loading on backend. Review collected by and hosted on G2.com.

It's very complex to connecting with different platform... You need to write connection string to pass the data here.... It must be happen on single click there Review collected by and hosted on G2.com.

It has an intelligent query processing enhancement.

It is always encrypted with secure enclaves.

It is straightforward to enable and makes TempDB more scalable. Review collected by and hosted on G2.com.

It has a poor interface, and it has a 128 GB limit for the database engine

. Review collected by and hosted on G2.com.

Big data clusters, Intelligent query processing, Accelerated data recovery, Advanced analytics with AI, and Security Enhancement help improve data management and analytics capabilities. Review collected by and hosted on G2.com.

Windows-based systems can limit their flexibility and portability for organizations that use multiple operating systems.

Required Updates and Upgrades: To maintain the security and performance of SQL Server 2019, organizations must regularly apply software updates and upgrades. This can be time-consuming and resource-intensive, especially for organizations with large, complex database deployments. Review collected by and hosted on G2.com.

It provides Rich set of in built function.

Very handy tool to analyse data of large amounts.

Easy to use.

It is very fast, robust and a trusted server to use. Review collected by and hosted on G2.com.

Doesn't provide a parallel processing therefore a bit slower than distributed systems.

For first time users it might be challenging to use this but after that user will become used to this server in effective manner.

If possible, should be freely available at all expectations. Review collected by and hosted on G2.com.

It has a lot of user friendly features that helps to manage data in each field.

The In-Memory optimizer is one of my favorites, the always on high availability groups and the query store. Review collected by and hosted on G2.com.

I am a client of the sql server since sql server 2000 and I grow as the sql server has been growth. There has been problems and errors through it but it has been solved in the short time in the next cumulative update or next version. Review collected by and hosted on G2.com.