[ Microsoft Reviews ](https://www.g2.com/products/sql-server-2019/reviews) [ Microsoft Reviews ](https://www.g2.com/products/sql-server-2019/reviews) # SQL Server 2019 Features ##### ## Data Management (6) Data Integration Consolidates, Cleanses and Normalizes data from multiple disparate sources. Data Compression Helps save storage capacity and improves query performance. Data Quality Eliminates data inconsistency and duplications ensuring data integrity. Built-In Data Analytics SQL based analytics functions like Time series, pattern matching, geospatial analytics etc. In-Database Machine Learning Provides built in capabilities like machine learning algorithms, data preparation functions, model evaluation and management etc. Data Lake Analytics Allows data querying across data formats like parquet, ORC, JSON etc and analyze complex data types on HDFS Show More ##### ## Integration (3) AI/ ML Integration Integrates with data science workflows, Machine Learning and artificial intelligence (AI) capabilities. BI Tool Integration Integrates with BI Tools to transform data into Actionable Insights. Data lake Integration Provides speed in data processing and capturing unstructured, semi-structured and streaming data. Show More ##### ## Deployment (2) On-Premise Provides On-Premise deployment options. Cloud Provides Cloud deployment options (private or public cloud, hybrid cloud). Show More ##### ## Performance (1) Scalability Manages huge volumes of data, upscale or downscale as per demand. Show More ##### ## Security (2) Data Governance Policies, procedures and standards to manage and access data. Data Security Restricts data access at a cell level, mask or hide parts of cells, and encrypt data at rest and in motion Show More ##### ## Generative AI (2) AI Text Generation Allows users to generate text based on a text prompt. AI Text Summarization Condenses long documents or text into a brief summary. Show More [ ![Cloudera Platform](https://images.g2crowd.com/uploads/product/hd_favicon/9c07d5ce58db04ec4e3a0f0c8ec46039/cloudera-platform.svg "Cloudera Platform") Sponsored Cloudera Platform 4.1/5 (136) Visit Website ](javascript:void(0)) ## Top-Rated Alternatives [ ![Databricks](https://images.g2crowd.com/uploads/product/hd_favicon/135d1c9e39e19ef56dc8d0bf90fce20f/databricks.svg "Databricks") Databricks 4.6/5 (780) ](https://www.g2.com/products/databricks/reviews) [ ![Snowflake](https://images.g2crowd.com/uploads/product/hd_favicon/1544409170/snowflake.svg "Snowflake") Snowflake 4.5/5 (705) ](https://www.g2.com/products/snowflake/reviews) [ ![Amazon Redshift](https://images.g2crowd.com/uploads/product/hd_favicon/1528476479/amazon-redshift.svg "Amazon Redshift") Amazon Redshift 4.3/5 (369) ](https://www.g2.com/products/amazon-redshift/reviews) [ View All Alternatives ](https://www.g2.com/products/sql-server-2019/competitors/alternatives) SQL Server 2019 Comparisons ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_2b00e05c107c3273cea5264090c3c1d0/snowflake.jpg "Product Avatar Image") Snowflake 4.5/5 (754) [ Compare Now ](https://www.g2.com/compare/sql-server-2019-vs-snowflake) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_aca40b5464fcf97310dbc332c2296b5c/oracle-exadata-cloud-service.png "Product Avatar Image") Oracle Exadata Cloud Service 4.4/5 (44) [ Compare Now ](https://www.g2.com/compare/oracle-exadata-cloud-service-vs-sql-server-2019) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_b3390b4cc3d92e87d570895f7358c003/amazon-redshift.jpg "Product Avatar Image") Amazon Redshift 4.3/5 (402) [ Compare Now ](https://www.g2.com/compare/amazon-redshift-vs-sql-server-2019) ##### Categories on G2 [ Data Warehouse ](https://www.g2.com/categories/data-warehouse) ##### Explore More [ What live chat tools do you actually use ](https://www.g2.com/discussions/what-live-chat-tools-do-you-actually-rely-on)[ What platform provides real-time task progress tracking? ](https://www.g2.com/discussions/what-platform-provides-real-time-task-progress-tracking)[ Best application performance monitoring tools for medium enterprises ](https://www.g2.com/discussions/best-application-performance-monitoring-tools-for-medium-enterprises) [ Leading password management solution for office use ](https://www.g2.com/discussions/top-rated-password-management-solutions-for-office-use)[ Best Workforce Management Software ](https://www.g2.com/discussions/best-workforce-management-software-for-teams-in-2025)[ Pros and Cons Details ](https://www.g2.com/products/sql-server-2019/reviews?qs=pros-and-cons) Show More [ What live chat tools do you actually use ](https://www.g2.com/discussions/what-live-chat-tools-do-you-actually-rely-on)[ What platform provides real-time task progress tracking? ](https://www.g2.com/discussions/what-platform-provides-real-time-task-progress-tracking)[ Best application performance monitoring tools for medium enterprises ](https://www.g2.com/discussions/best-application-performance-monitoring-tools-for-medium-enterprises) [ Leading password management solution for office use ](https://www.g2.com/discussions/top-rated-password-management-solutions-for-office-use)[ Best Workforce Management Software ](https://www.g2.com/discussions/best-workforce-management-software-for-teams-in-2025)[ Pros and Cons Details ](https://www.g2.com/products/sql-server-2019/reviews?qs=pros-and-cons)