# 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. ### 11. Very friendly, strong and useful software **Rating:** 5.0/5.0 stars **Reviewed by:** Artin L. | Sql Server Database Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** February 10, 2023 **What do you like best about SQL Server 2019?** 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. **What do you dislike about SQL Server 2019?** 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. **What problems is SQL Server 2019 solving and how is that benefiting you?** Accelerated Database Recovery (ADR): This feature provide very fast recovery. Resumable index build: It makes to manage the index rebuild and percent of completion. Memory-optimized Tempdb metadata: It increase the performance. ### 12. SQL server review **Rating:** 4.0/5.0 stars **Reviewed by:** Yashasvi G. | Assistant System Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** March 01, 2023 **What do you like best about SQL Server 2019?** Easy to use Scalable Very effective forthe new comers for building their database system This is very easy to understand and very easy to implement on the new projects **What do you dislike about SQL Server 2019?** We need to remember queries for working on the SQL server. It is cost inefficient and having a poor interface. It will be lesser attractive for the new comers to implement this. **What problems is SQL Server 2019 solving and how is that benefiting you?** We have used it as the database fo our e-commerce website. We have stored all the data of products as well as the data of the users. To update new items in the database, admin can do that ### 13. Reliable and easy to maintain **Rating:** 5.0/5.0 stars **Reviewed by:** Vijay T. | System Analyst, Small-Business (50 or fewer emp.) **Reviewed Date:** February 16, 2023 **What do you like best about SQL Server 2019?** SQL Server 2019 is really very stable and reliable. Processing wise it's fast and pocket friendly too. Better performance compare to other vendors. **What do you dislike about SQL Server 2019?** It's will more better of we have more exposure to the big data or JSON processing in SQL. There are less function to handle it. **What problems is SQL Server 2019 solving and how is that benefiting you?** It's helps with easy data loading and maintaining the data warehouses. It's sqp server data tools are really useful. ### 14. SQL server review **Rating:** 5.0/5.0 stars **Reviewed by:** Ashish C. | Azure data engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 28, 2023 **What do you like best about SQL Server 2019?** Very interactive. Very good tool to store large amount of data. Easy to understand and implement. The best thing is syntax. Easily accessible and easily available. **What do you dislike about SQL Server 2019?** It's processing speed is slow. Can only store data in tables no support for other data types like json. We can integrate it with no SQL database. We can provide free courses. **What problems is SQL Server 2019 solving and how is that benefiting you?** Provide solutions for storing large amount of data in tables for so that it can be used for reporting purposes. Yes it helps in fater and easy storage and help to solve client problem. ### 15. SQL Server Review **Rating:** 4.0/5.0 stars **Reviewed by:** Shubham S. | RPA Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** February 28, 2023 **What do you like best about SQL Server 2019?** 1. Performance : SQL server give us good performance. 2 Robust and Reliable : SQL Server is very robust and reliable. 3. Queries and Analytics : SQL server gives very good result in easy way for queries and Analytics. **What do you dislike about SQL Server 2019?** 1. For first time users its is difficult to understand. 2. It does not provide parallel processing therefore slower than distributed systems. **What problems is SQL Server 2019 solving and how is that benefiting you?** We are using it as server for maintaining our data warehouse. Also we are using to peroform data analysis and also to provide quick responses for the queries. ### 16. SQL SERVER REVIEW **Rating:** 4.0/5.0 stars **Reviewed by:** Ankush S. | System Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 26, 2023 **What do you like best about SQL Server 2019?** -Offers a vibrant set of inbuilt functions. -A premium product from Microsoft. -Once understood properly, it's very easy to use after that. -Easily Configurable. **What do you dislike about SQL Server 2019?** -A bit costly. -Not so much user friendly for 1st time users. -Less security features. -Single user system. Parallaleization is tough. -Offers less compatibility. **What problems is SQL Server 2019 solving and how is that benefiting you?** Solves the problem of storing huge amount of structured data. -helps in easy query and analysis of data. -very much handy tool for adhoc data analysis. -Easy to maintain data. ### 17. SQL Server 2019 Review **Rating:** 5.0/5.0 stars **Reviewed by:** AMIT J. | Data Scientist L3, Enterprise (> 1000 emp.) **Reviewed Date:** February 27, 2023 **What do you like best about SQL Server 2019?** Best Database Server Easy to Install Ideal for learning company is updating the version regularly gives faster result **What do you dislike about SQL Server 2019?** Nothing as such I dislike SQL Server 2019 **What problems is SQL Server 2019 solving and how is that benefiting you?** Mainly we are using it for database queries We have extensive data, and we want faster results So we can use any queries as well as complex ones, also Our performance has improved Client is happy also ### 18. SQL Server 2019 - More power to Database **Rating:** 4.5/5.0 stars **Reviewed by:** Sayam J. | Software Architect, Small-Business (50 or fewer emp.) **Reviewed Date:** January 28, 2023 **What do you like best about SQL Server 2019?** SQL server 2019 has improved itself from its previous releases. It has been enhanced on the bulk transactions and security parameters also. **What do you dislike about SQL Server 2019?** The central painful part of SQL Server 2019 is Licensing which remains the same as the previous versions. **What problems is SQL Server 2019 solving and how is that benefiting you?** SQL Server 2019 has helped us to manage multiple clients on the same server very swiftly. It allowed us to understand the execution plans of more complex queries, which helped us extract the reports faster. ### 19. SQL SERVER 2019 **Rating:** 5.0/5.0 stars **Reviewed by:** Swapnil L. | Systems Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 02, 2023 **What do you like best about SQL Server 2019?** Performance is good. High efficiency. It has in-memory tables. **What do you dislike about SQL Server 2019?** Cost Inefficient. Poor interface. Security issues. **What problems is SQL Server 2019 solving and how is that benefiting you?** It is cost effective. Performance is high. It has in built tables. ### 20. Good product **Rating:** 3.5/5.0 stars **Reviewed by:** Billcates M. | Senior Data Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** February 23, 2023 **What do you like best about SQL Server 2019?** It is a useful tool for analysing and managing database. **What do you dislike about SQL Server 2019?** It needs update as we have databases in cloud currently which would scale as needed ,which is not available in sql server **What problems is SQL Server 2019 solving and how is that benefiting you?** We are using sql server for storing our operational database and we perform reporting analysis using sql as it is a relational database management system. ### 21. It was awesome. The features I wanted are here. **Rating:** 4.5/5.0 stars **Reviewed by:** Jones X. | Enterprise (> 1000 emp.) **Reviewed Date:** February 27, 2023 **What do you like best about SQL Server 2019?** Data manipulation and data mining are awesome. **What do you dislike about SQL Server 2019?** The UI could be a little more advanced. The server seems too pricy, I see the client go with PaaS or FaaS Serveives. **What problems is SQL Server 2019 solving and how is that benefiting you?** We use it mostly for the old servers just in case of an upgrade. Apart from that, We go with the PaaS Serveice ### 22. Excellent performance and better than ever **Rating:** 5.0/5.0 stars **Reviewed by:** Aaron J. | Senior Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** January 04, 2023 **What do you like best about SQL Server 2019?** Fast and powerful. Intellisense is amazing when it works. **What do you dislike about SQL Server 2019?** Start up is slow. Performance tuning is cumbersome. **What problems is SQL Server 2019 solving and how is that benefiting you?** Provides a robust RDB with great integration to SSIS and SSRS which we also use. ### 23. A good data server. **Rating:** 4.5/5.0 stars **Reviewed by:** Chethan B. | Statistician, Mid-Market (51-1000 emp.) **Reviewed Date:** February 28, 2023 **What do you like best about SQL Server 2019?** We can easily review the data and can be retrieve. User friendly. **What do you dislike about SQL Server 2019?** It is working fine for me till now. Not found any difficulties... **What problems is SQL Server 2019 solving and how is that benefiting you?** Data retrieval is easy. Handling the data is easy. ### 24. SQL server review **Rating:** 4.0/5.0 stars **Reviewed by:** Sachin R. | Account Service Operations, Enterprise (> 1000 emp.) **Reviewed Date:** March 13, 2023 **What do you like best about SQL Server 2019?** Easy to use, adaptive, easily understood. **What do you dislike about SQL Server 2019?** limited database engine, longer time execution, connection errors. **What problems is SQL Server 2019 solving and how is that benefiting you?** solutions for storing large amount of data. Adhoc data analysis. ### 25. An excellent software to manage database **Rating:** 5.0/5.0 stars **Reviewed by:** Amit L. | Blockchain Developer, Enterprise (> 1000 emp.) **Reviewed Date:** February 09, 2023 **What do you like best about SQL Server 2019?** Easy implementation and configuration process **What do you dislike about SQL Server 2019?** SQL server doesn't seem to have any feature to dislike. Only thing want to know about it's implementation in blockchain **What problems is SQL Server 2019 solving and how is that benefiting you?** It helps to easily manage the data with respect to the business application. ### 26. Great DBMS solution for professionals **Rating:** 4.5/5.0 stars **Reviewed by:** Piotr N. | System Administrator, Mid-Market (51-1000 emp.) **Reviewed Date:** September 10, 2022 **What do you like best about SQL Server 2019?** Easy to understand (user firendly) It's easy to setup and provide service MS SQL Server is easy to maintain Allow to multiple subqueries, tabs, easy formatting Great connection to Excel Integration of the R programming language **What do you dislike about SQL Server 2019?** Reporting capabilities Upgrading to newer version is difficult and takes a lot of time Cost always could be lower Learning curve Requires a lot of resources for implementation **What problems is SQL Server 2019 solving and how is that benefiting you?** Our company uses Microsoft SQL Server to store data and run jobs. We use SQL Server to write queries to produce desired tables of data. This is also the source for different processes and reports, outside database as QV, Qlik Sense and Excel. ### 27. Nice, Appreciate **Rating:** 4.5/5.0 stars **Reviewed by:** Thahir A. | Senior Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 22, 2023 **What do you like best about SQL Server 2019?** Azure migration service without redesign the app **What do you dislike about SQL Server 2019?** Sql server w019 license prices are too high **What problems is SQL Server 2019 solving and how is that benefiting you?** DIsaster recovery option is highly appreciated ### 28. Best RDBMS **Rating:** 5.0/5.0 stars **Reviewed by:** Saurabh K. | Software Engineering Associate Manager, Enterprise (> 1000 emp.) **Reviewed Date:** November 07, 2022 **What do you like best about SQL Server 2019?** Best and easy to use RDBMS. It provisions both script based and tool based database management **What do you dislike about SQL Server 2019?** Nothing as of now I disliked. Its very user friendly and convenient **What problems is SQL Server 2019 solving and how is that benefiting you?** This is Relational database management system ### 29. Best Database i have ever worked **Rating:** 5.0/5.0 stars **Reviewed by:** Sajidur R. | Lead Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** May 21, 2022 **What do you like best about SQL Server 2019?** In every aspect i liked SQL Server, from large to small range database SQL server is best, installing to default setting or you can say DBA all is good. The new feature memory-optimized table is awesome. **What do you dislike about SQL Server 2019?** Yes, Some of the features should be improved like oracle like Always-on sync should be more real-time sync. **What problems is SQL Server 2019 solving and how is that benefiting you?** Every day of my life we are using SQL Server in my software development jobs. ### 30. Best DataBase Management Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Anurag P. | Information Technology Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 10, 2022 **What do you like best about SQL Server 2019?** The SQL Server 2019 has excellent performance over previous versions; Its new Lightweight query profiling uses fewer resources to analyze query analytics. It has accelerated database recovery that provides fast DB recovery. You can use it on both Windows and Linux environments. It supports Five (4+1) replicas in sync mode, enabling users high availability of servers. For big data processing, you can use T-SQL. Microsoft Customer support is always excellent and quick to resolve your query. **What do you dislike about SQL Server 2019?** The SQL Server 2019 cost is expensive compared to other solutions available in the market. After upgrading to the latest version of the SQL server 2019, sometimes, I feel connection and performance issue. **Recommendations to others considering SQL Server 2019:** SQL Server 2019 is a good product for all your data processing needs; I have used previous versions of the SQL Server as well and feel good experince with SQL Server 2019. So go for it or upgard from your previous versions. **What problems is SQL Server 2019 solving and how is that benefiting you?** We migrated our plant database on SQL Server 2019; Previously, we used SQL Server 2008 R2. Now I can quickly run all CRUD queries fastly for my database. Indexing to DB tables is fast. Using SQL profiling, I can monitor and analyze SQL queries. With excellent GUI, I can import and export database tables and send them for processing to other locations of my organization. It is fast and now supports Big Data processing. ### 31. I'm a software developer having 2 years of experience and working with IIS and DotNet **Rating:** 4.5/5.0 stars **Reviewed by:** Haseeb N. | Associate Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** February 25, 2022 **What do you like best about SQL Server 2019?** Intellisense is quite good, but sometimes it is very hasty when SQL doesn't show Intellisense, and you have to write all the things on your own. IDQ has improved, always encrypted with secure enclaves and memory optimization. **What do you dislike about SQL Server 2019?** Complex performance tuning features, no native support for source control, a burdensome licensing process that is constantly changing, which is quite complicated when you have to pay for multiple licensing. **What problems is SQL Server 2019 solving and how is that benefiting you?** SQL provides us relational database, which is quite good. You can generate the class with all the relations without doing anything if you have created the table with all references in SQL ### 32. Database Manager **Rating:** 5.0/5.0 stars **Reviewed by:** Maulik P. | S, Small-Business (50 or fewer emp.) **Reviewed Date:** October 17, 2021 **What do you like best about SQL Server 2019?** We can Easily manage project data using SQL server 2019. We can easily create, edit, update and delete databases. Easily insert and update data in the database. Securities are best for connecting and use databases. It takes significantly less time very little time to get data from databases, making the project faster. There is an encryption function in which the database saves the password in encrypted, which helps keep the project secure. Store procedure function also available for getting data very fast which help for handling data of the large project. We can create script for make copy of database or transfer data or design of databases. **What do you dislike about SQL Server 2019?** For beginners, it is not easy to use this to handle the data of any project. It is not responding multiple times when changed in the database. **Recommendations to others considering SQL Server 2019:** It would help if you tried this to handle your Project Database. It boosts your project speed and quickly transfers data from one system to another by using a script. **What problems is SQL Server 2019 solving and how is that benefiting you?** We use this to manage the data of the project. Data is saved in a proper manner where we can quickly get required data from the database. We are performing the insert, Update, Delete function using this, and it performs very well. We are also using store procedures for getting and inserting data very fast. This helps boost project speed. We also save and transfer data from one system by creating a script. ### 33. Best For Manage Database **Rating:** 5.0/5.0 stars **Reviewed by:** Ashu S. | Software Devloper, Small-Business (50 or fewer emp.) **Reviewed Date:** October 07, 2021 **What do you like best about SQL Server 2019?** We can easily Manage databases of large projects as well as small projects. Very easy to get and store data in the database. This Provides multiple functions for manage the database as edit, update, delete data. we can easily create store procedures for getting large data in very little time. When using This DBMS then our project perforation is good and very fast. We can also transfer data from one system to another system by creating a script. This is a perfect tool for handle databases. **What do you dislike about SQL Server 2019?** Sometimes when the username and passwords are correct but unable to connect, I think of some network issue. **Recommendations to others considering SQL Server 2019:** This best tool for managing a large database as well as a small database so you must try it. **What problems is SQL Server 2019 solving and how is that benefiting you?** We use this to manage the database for our project. We use this to perform insert, Update, Delete operations. We also create store procedures for getting large data and insert large data in less time. This improves the performance of the project. ### 34. Amazing database **Rating:** 4.5/5.0 stars **Reviewed by:** Christian A. | BI Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** December 10, 2021 **What do you like best about SQL Server 2019?** Since 2012, I have worked with SQL Server with different versions: 2008, 2012, 2014, 2016, and now 2019. I like the visualization of Management Studio and also the integration with the different services. **What do you dislike about SQL Server 2019?** I think that sometimes the improvements are not seeing very significant. I would like to have a way to watch and understand the Explain Plan. Also Explain plain Live is really useful. **What problems is SQL Server 2019 solving and how is that benefiting you?** We solve a really a good problem with the Json files. We have to integrate some rest api and load the files to the database. Then with the help of the functions JSON_VALUE and JSON_QUERY, we could load the columns to a table-. ### 35. A must for DATABASE EXPERT **Rating:** 5.0/5.0 stars **Reviewed by:** Karen H. | IT Application Management Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** January 26, 2022 **What do you like best about SQL Server 2019?** database management studio is a great tool for me to manage datasets, build stored procs, develop data automation **What do you dislike about SQL Server 2019?** I use SQL server for many years in my IT database career. I don't really have many dislikes. If SQL Server can improve to be able to query value search, that would be perfect. **What problems is SQL Server 2019 solving and how is that benefiting you?** Problem resolving Managing data ETL, developing automation, building stored procedures, etc. Benefit is to save labor, save time after developing and launching the automations ### 36. Best Data management tool **Rating:** 4.5/5.0 stars **Reviewed by:** abhilash g. | Assistant System Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** October 11, 2021 **What do you like best about SQL Server 2019?** The best feature in squl server is data recovery and this tool is a Microsoft tool so this application is trusted application. We can use SQL server application in both windows and Linux containers, we can easily import and export data. And this tool support both windows and Linux os. Customer support is very quick. **What do you dislike about SQL Server 2019?** I don't find any dislike in this application, but some small isues in connecting to server and price is little high for different versions. **Recommendations to others considering SQL Server 2019:** I will definitely recommend other to use this application for easily query and retrive the data and handle data. It provide data recovery methode from cloud. **What problems is SQL Server 2019 solving and how is that benefiting you?** I can easily run DDL, DML and TCL queries fastly to my data and easily find errers of PLSQL methos query. I can easily import and export data and save data in encryption formate. I can easily recover data from cloud if it crash. I can easily manage my deployments using kubernetes. And I can manage my servers and data by importing and exporting data I can save XML formate data as well. ### 37. Sql server 2019 - A highly reliable and scalable database for mission critical applications **Rating:** 4.0/5.0 stars **Reviewed by:** Partha M. | Owner and Founder, Small-Business (50 or fewer emp.) **Reviewed Date:** May 03, 2022 **What do you like best about SQL Server 2019?** The New data virtualization feature which allows you to integrate with other databases like mongodb, Hadoop, apache spark etc. **What do you dislike about SQL Server 2019?** Nothing really.it has a plethora of new features. **What problems is SQL Server 2019 solving and how is that benefiting you?** Seamless integration with other data sources like mongodb, Hadoop, apache spark, etc ### 38. Good Software to work on SQL as DBA **Rating:** 4.5/5.0 stars **Reviewed by:** Siddhant K. | CTO, Small-Business (50 or fewer emp.) **Reviewed Date:** September 09, 2021 **What do you like best about SQL Server 2019?** 1 - It provides options to view, edit, delete and insert data without needing to mugging up the query, from its UI thus making it very handy. 2 - Can connect to any MSSQL database on any network. 3 - Can connect to multiple servers simultaneously **What do you dislike about SQL Server 2019?** 1 - It is slow and needs to work on its RAM management 2 - Edit options from the UI is buggy 3 - If you perform the heavy operation of SELECT of many records then the UI becomes unresponsive until all the records are fetched **What problems is SQL Server 2019 solving and how is that benefiting you?** 1 - Being a DBA it is the most important tool for me, WIthout MSSQL Server I am useless as a DBA ### 39. SQL Server **Rating:** 4.0/5.0 stars **Reviewed by:** Narendra M. | Professional Integration Developer, Enterprise (> 1000 emp.) **Reviewed Date:** April 29, 2022 **What do you like best about SQL Server 2019?** SQL server is Microsoft RDBMS system comes with a lot of functionalities like SSIS packages. **What do you dislike about SQL Server 2019?** MS SQL Server 2019 Dependency on Windows OS. **What problems is SQL Server 2019 solving and how is that benefiting you?** Used as relational database system in one of the project ### 40. Database management **Rating:** 3.5/5.0 stars **Reviewed by:** Ramesh P. | Software Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** October 21, 2021 **What do you like best about SQL Server 2019?** We can easy to manage lots of data and easy to read all data when we need it. we can create a table, stored procedure, and function for retrieving data Also, we can use begin the transaction, commit, and rollback for live database management. if we execute the wrong operation, so that time easily manage to roll back data **What do you dislike about SQL Server 2019?** When the database size is very large and difficult to execute the query, it takes some time. **Recommendations to others considering SQL Server 2019:** This is the best software for managing a database, so you must try it **What problems is SQL Server 2019 solving and how is that benefiting you?** I have created lots of applications using SQL server 2019. We get response early behalf of other application and client was satisfied ### 41. Great interface access to database **Rating:** 4.5/5.0 stars **Reviewed by:** Rahul Kumar S. | Associate Software Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** October 06, 2021 **What do you like best about SQL Server 2019?** It provides highly secure data transfer from source to destination. We can configure access of users in-depth and up to minute level. It is highly compatible with dot net and windows. **What do you dislike about SQL Server 2019?** Sometimes it hangs a lot. Several times it slowed down just because of VPN connection loss. It should throw an error message instead of hanging while running a script. **Recommendations to others considering SQL Server 2019:** It is highly recommended for beginers, dotnet, dotnet core developers. **What problems is SQL Server 2019 solving and how is that benefiting you?** Building software applications ### 42. SQL Server: Review **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Banking | Enterprise (> 1000 emp.) **Reviewed Date:** January 10, 2022 **What do you like best about SQL Server 2019?** I like the folder/directory structure easy to navigate. I also find the formatting part where square brackets get enclosed around names of columns when you hit on "script as" to generate scripts. **What do you dislike about SQL Server 2019?** There is no feature of rolling back faulty inserts or deletes. Sometimes, I had no way of retrieving accidentally deleted records. **What problems is SQL Server 2019 solving and how is that benefiting you?** Constantly checking if the transformation logic I write is working correctly. The best use case is to unit test my data pipelines - if I got the data i needed or not. ### 43. SQL Server 2019 Review **Rating:** 4.5/5.0 stars **Reviewed by:** Abid Hussain A. | Manage Databases, Data and Data Analytics , Enterprise (> 1000 emp.) **Reviewed Date:** June 04, 2021 **What do you like best about SQL Server 2019?** -SQL SERVER 2019 has a data virtualization feature that benefits our improved ETL process. Now can integrate different heterogeneous data sources without moving data. -SQL Server 2019 big data cluster has advancement with Polybase. Now we can achieve bidirectional integration with the Help of Hadoop and Spark, and Big Data management is straightforward. -SQL Server 2019 has a vulnerability assessment, which can get a detailed report of vulnerabilities and implement compliance to fix these vulnerabilities. -SQL Server 2019 has the feature of certificate management in the SQL Server configuration manager; it helps to manage certificates effectively. -SQL Server 2019 has the feature Always Encrypted with a secure enclave; it secures data from malware -SQL Server 2019 has the support of Persistent Memory devices. It helps SQL Server to access devices and improve performance directly. -SQL Server 2019 has a feature to create a resumable online index. With the help of this feature, we can pause and resume online index creation. -SQL Server 2019 has an improvement to column store indexes, which has benefits of performance. -SQL Server 2019 has a feature to support UTF-8 character encoding. It helps us to improve the compatibility of database and enhances performance. -SQL Server 2019 has a feature vulnerability assessment. It helps to track compliance and generate a report. **What do you dislike about SQL Server 2019?** -SQL Server 2019 is an expensive product as compared with other databases such as MySQL. Due to its high cost, many companies can afford it. To compete with these databases, Microsoft should consider the pricing factor **What problems is SQL Server 2019 solving and how is that benefiting you?** -We have many distributed and heterogeneous database environments which very complex to manage and integrate; with the help of SQL server 2019, we efficiently manage and integrate these databases. It very helpful for us to get near to real-time business insights with the use of a high-end reporting system -Due to SQL Server 2019 high availability feature, our business remains to continue in case of server or hardware failure. -Due to SQL Server enhanced security features, it makes our business free from any security risk. ### 44. Microsoft's latest iteration of its robust relational database server **Rating:** 4.5/5.0 stars **Reviewed by:** Jonathan H. | Marketing Lead Data Officer, Mid-Market (51-1000 emp.) **Reviewed Date:** May 24, 2021 **What do you like best about SQL Server 2019?** - Comes in several different sizes for differing requirements, Express, Standard, Developer, Enterprise, etc - Developer edition is a no-cost set up ideal for building your sandbox system for developing - Uses SSMS as front end or Visual Studio - Deemed to be still main choice for any company needing a database that works with other standard Microsoft products **What do you dislike about SQL Server 2019?** - rumours from seasoned devs there are many bugs, and maybe not a mature product for a mission-critical solution, compared to 2016/2017. **What problems is SQL Server 2019 solving and how is that benefiting you?** transform and load Excel files and legacy Access DBs into a new SQL server system and be able to query ### 45. Very much secured **Rating:** 5.0/5.0 stars **Reviewed by:** Maria Z. | Junior Software Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** September 27, 2021 **What do you like best about SQL Server 2019?** SQL Server is very faster than other databases as performance wise. We are using SQL Server for desktop applications. The most important feature I like in SQL Server is at the time of deployment on production it does not require large space. **What do you dislike about SQL Server 2019?** Documentation is not as clear as one may expect. You get easily lost between docs for different versions of the database. It is quite expensive. **What problems is SQL Server 2019 solving and how is that benefiting you?** Companies all data store with this database. ### 46. Best version of SQL Server **Rating:** 4.0/5.0 stars **Reviewed by:** akshay R. | Data Warehouse Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 08, 2021 **What do you like best about SQL Server 2019?** SQL language, SQL server integrations, external script execution, Regular updates **What do you dislike about SQL Server 2019?** Nothing significant as of now but lack of scalability. **What problems is SQL Server 2019 solving and how is that benefiting you?** Restoring back ups from 3rd party vendors to use the data. Transactional database for internal applications. ### 47. MS SQL Server, common RDMS for .net apps **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Program Development | Mid-Market (51-1000 emp.) **Reviewed Date:** October 26, 2021 **What do you like best about SQL Server 2019?** - Integrate with .NET framework - It's fast, reliable, secure - Easy to install - A lot of features **What do you dislike about SQL Server 2019?** - Expensive license - Could be better in scalability - Created data diagrams need improvement **What problems is SQL Server 2019 solving and how is that benefiting you?** I use it as a common standard transactional database for enterprise apps, Easily we developed and manage our stored procedures Using execution plan feature to check and optimize my query and increase the efficiency of my developed apps. ### 48. SQL Server 2019 Review **Rating:** 4.0/5.0 stars **Reviewed by:** Atul F. | sql, Enterprise (> 1000 emp.) **Reviewed Date:** December 08, 2020 **What do you like best about SQL Server 2019?** Microsoft Azure is an effective way to modernize your data warehouse. Businesses use Azure SQL Data Warehouse to create net-new data warehouses in the cloud, extend their existing enterprise data warehouse to the cloud, and/or migrate their on-premises data warehouse to Azure SQL Data Warehouse **What problems is SQL Server 2019 solving and how is that benefiting you?** Very good datawarehouse cloud based colution ### 49. SQL server **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Enterprise (> 1000 emp.) **Reviewed Date:** October 15, 2021 **What do you like best about SQL Server 2019?** It is easy to use , connect to your different servers, databases and run queries. A very very useful product to manage Database for any organization. **What do you dislike about SQL Server 2019?** Might be UI can be little more good , apart from that i found it very useful **Recommendations to others considering SQL Server 2019:** May be UI can be better **What problems is SQL Server 2019 solving and how is that benefiting you?** I have been using it to connect to my Server. create databases, tables, and perform queries based on the requirements. ### 50. Best Relational DB manager now comes with big data **Rating:** 5.0/5.0 stars **Reviewed by:** Bhaginath P. | Senior Consultant, Enterprise (> 1000 emp.) **Reviewed Date:** November 30, 2020 **What do you like best about SQL Server 2019?** In earlier versions of sql server there was no support of big data, SQL-2019 gives us this feature. We can do ETL in very simple way for mongoDB kinds of database. I like its UTF feature most as it has saved my life in current project. I'm using SQL2019 since last 8 months and I'm loving it. Below are the features I like most. -Multiplatform installation, now we can install it on any os like windows, apache. -UTF support for multiple characters. -Build image testing with docker and K8S. -Integration with most of the development frameworks. **What do you dislike about SQL Server 2019?** At the moment I didn't found any cons only the prize is expensive for enterprise application. :) **Recommendations to others considering SQL Server 2019:** Go for it if you want to save all kinds of UTF character in database. **What problems is SQL Server 2019 solving and how is that benefiting you?** We were not able to save UTF8 data properly, when we were rendering on UI, its showing ugly characters. With SQL2019 We resolved this issue in our current project. Its integration and documentation is more clear due to this I was able to track the performance hit of one of our long running stored procedure. ## 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 - [View SQL Server 2019 pricing details and edition comparison](https://www.g2.com/products/sql-server-2019/reviews?section=pricing&secure%5Bexpires_at%5D=2026-05-13+11%3A40%3A06+-0500&secure%5Bsession_id%5D=0074f322-19ca-4223-ab55-35718b862779&secure%5Btoken%5D=93cad5b07f48547fc1b7fbf3b46eebaa27380fd8a8f0c65ddee577e7ded21e60&format=llm_user) ## 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 (740 reviews) - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.6/5.0 (687 reviews) - [Amazon Redshift](https://www.g2.com/products/amazon-redshift/reviews) - 4.3/5.0 (368 reviews)