# SQL Server 2019 Reviews **Vendor:** Microsoft **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.5/5.0 **Total Reviews:** 83 ## About SQL Server 2019 Parallel Data Warehouse offers scalability to hundreds of terabytes and high performance through a massively parallel processing architecture. ## SQL Server 2019 Pros & Cons **What users like:** - Users value the **seamless data integration** in SQL Server 2019, boosting performance and simplifying complex queries. (1 reviews) - Users value the **advanced indexing and optimized data retrieval** in SQL Server 2019 for handling complex queries effectively. (1 reviews) **What users dislike:** - Users find the **high licensing costs** of SQL Server 2019 challenging, especially for smaller projects with limited budgets. (1 reviews) ## SQL Server 2019 Reviews ### 1. Improved performance and scalability: an excellent experience **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer & Network Security | Mid-Market (51-1000 emp.) **Reviewed Date:** January 21, 2026 **What do you like best about SQL Server 2019?** Performance and scalability that have been improved **What do you dislike about SQL Server 2019?** There is nothing about SQL SERVER 2019 that I dislike. In general, its functionalities seem adequate to me and I don't think they require improvements in terms of their use. **What problems is SQL Server 2019 solving and how is that benefiting you?** I have noticed inconsistent performance and poor execution plans, which translates into fewer errors and the ability to generate the required information on time, with acceptable response times. ### 2. SQL Server 2019 Review **Rating:** 4.5/5.0 stars **Reviewed by:** Kavya S. | Senior Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 28, 2024 **What do you like best about SQL Server 2019?** 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. **What do you dislike about SQL Server 2019?** It can be difficult, particularly for smaller projects, dealing with advanced features.It has high licensing costs as well. **What problems is SQL Server 2019 solving and how is that benefiting you?** With the use of SQL Server 2019, the management of data becomes easier, the performance of the queries goes up, the security mechanisms are reinforced, which allows me to develop robust and scalable backend solutions. ### 3. Best tool for beginners to advance **Rating:** 5.0/5.0 stars **Reviewed by:** Vivek R. | Assistant Manager, Enterprise (> 1000 emp.) **Reviewed Date:** September 02, 2024 **What do you like best about SQL Server 2019?** Ease of use ,I say. Quite simple. Can be easily synced with various tools like anaconda and Power bi **What do you dislike about SQL Server 2019?** Installation is bit troublesome with organisation hardwares **What problems is SQL Server 2019 solving and how is that benefiting you?** I help it analysing my daily work data and making simplified reports in fast and very accurate manner ### 4. Modern Data Management **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** February 13, 2024 **What do you like best about SQL Server 2019?** 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. **What do you dislike about SQL Server 2019?** 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. **What problems is SQL Server 2019 solving and how is that benefiting you?** Offers solutions to problems with data volume, performance optimization, security and sophisticated analytics, all of which are important to today's enterprises. ### 5. Good choice for medium and large companies. **Rating:** 4.0/5.0 stars **Reviewed by:** Valerian L. | Customer Support Specialist, Information Technology and Services, Enterprise (> 1000 emp.) **Reviewed Date:** February 29, 2024 **What do you like best about SQL Server 2019?** 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. **What do you dislike about SQL Server 2019?** 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. **What problems is SQL Server 2019 solving and how is that benefiting you?** Our ERP program is integrated with SQL server 2019 and All our data is stored in it. ### 6. SQL server 2019 Review **Rating:** 5.0/5.0 stars **Reviewed by:** Sanjeev P. | Data Analyst, Enterprise (> 1000 emp.) **Reviewed Date:** September 06, 2023 **What do you like best about SQL Server 2019?** 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. **What do you dislike about SQL Server 2019?** 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. **What problems is SQL Server 2019 solving and how is that benefiting you?** SQL server 2019 have multiple features that are helping me like 5 synchronous replicas in AON data virtulization and new DMV sys.dm_db_page_info so there are multiple other benifit are there I have mention some of them. ### 7. SQL server 2019 **Rating:** 5.0/5.0 stars **Reviewed by:** Ajit K. | Senior Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** August 10, 2023 **What do you like best about SQL Server 2019?** 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. **What do you dislike about SQL Server 2019?** 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 **What problems is SQL Server 2019 solving and how is that benefiting you?** It was storing our complex data of banking project and retrieval of data is very fast so that it saves our time as well provided security to data that's how it benefiting us. ### 8. Easy creation of database and tables **Rating:** 5.0/5.0 stars **Reviewed by:** Jhilik B. | Enterprise (> 1000 emp.) **Reviewed Date:** June 19, 2023 **What do you like best about SQL Server 2019?** It has an intelligent query processing enhancement. It is always encrypted with secure enclaves. It is straightforward to enable and makes TempDB more scalable. **What do you dislike about SQL Server 2019?** It has a poor interface, and it has a 128 GB limit for the database engine . **What problems is SQL Server 2019 solving and how is that benefiting you?** It helps us in executing the queries against the database. It also retrieves the data from the database table, and there is a feature for modifying and updating the records in the database. ### 9. A comprehensive review of SQL server 2019 **Rating:** 3.0/5.0 stars **Reviewed by:** Vikash K. | Small-Business (50 or fewer emp.) **Reviewed Date:** February 12, 2023 **What do you like best about SQL Server 2019?** Big data clusters, Intelligent query processing, Accelerated data recovery, Advanced analytics with AI, and Security Enhancement help improve data management and analytics capabilities. **What do you dislike about SQL Server 2019?** 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. **What problems is SQL Server 2019 solving and how is that benefiting you?** Managing Big Data: With the introduction of Big Data Clusters, SQL Server 2019 makes it easier for organizations to store, process, and analyze large amounts of structured and unstructured data, such as log files and social media data, and it helps the organizations to gain valuable insights into their business operations and customer behavior. ### 10. SQL SERVER REVIEW **Rating:** 4.0/5.0 stars **Reviewed by:** Sahil B. | Associate, Small-Business (50 or fewer emp.) **Reviewed Date:** February 28, 2023 **What do you like best about SQL Server 2019?** 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. **What do you dislike about SQL Server 2019?** 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. **What problems is SQL Server 2019 solving and how is that benefiting you?** It solves the problem of maintaining and organizing large amount of data in a structural way. It Provides good ways to perform adhoc analysis on large amount of data. ## SQL Server 2019 Discussions - [What is SQL Server 2019 used for?](https://www.g2.com/discussions/what-is-sql-server-2019-used-for) - 1 comment ## SQL Server 2019 Features **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics **Integration** - AI/ ML Integration - BI Tool Integration - Data lake Integration **Deployment** - On-Premise - Cloud **Performance ** - Scalability **Security** - Data Governance - Data Security **Generative AI** - AI Text Generation - AI Text Summarization ## Top SQL Server 2019 Alternatives - [Databricks](https://www.g2.com/products/databricks/reviews) - 4.6/5.0 (731 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.6/5.0 (666 reviews) - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - 4.3/5.0 (367 reviews)