SQL Server 2019 Features
What are the features of SQL Server 2019?
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
Top Rated SQL Server 2019 Alternatives
(584)
4.5 out of 5
Visit Website
Sponsored
Microsoft Categories on G2
Filter for Features
Data Management
Data Integration | Based on 33 SQL Server 2019 reviews and verified by the G2 Product R&D team. Consolidates, Cleanses and Normalizes data from multiple disparate sources. | 91% (Based on 33 reviews) | |
Data Compression | Based on 30 SQL Server 2019 reviews and verified by the G2 Product R&D team. Helps save storage capacity and improves query performance. | 88% (Based on 30 reviews) | |
Data Quality | Based on 31 SQL Server 2019 reviews and verified by the G2 Product R&D team. Eliminates data inconsistency and duplications ensuring data integrity. | 89% (Based on 31 reviews) | |
Built-In Data Analytics | Based on 27 SQL Server 2019 reviews and verified by the G2 Product R&D team. SQL based analytics functions like Time series, pattern matching, geospatial analytics etc. | 84% (Based on 27 reviews) | |
In-Database Machine Learning | Based on 19 SQL Server 2019 reviews and verified by the G2 Product R&D team. Provides built in capabilities like machine learning algorithms, data preparation functions, model evaluation and management etc. | 78% (Based on 19 reviews) | |
Data Lake Analytics | Based on 19 SQL Server 2019 reviews and verified by the G2 Product R&D team. Allows data querying across data formats like parquet, ORC, JSON etc and analyze complex data types on HDFS | 84% (Based on 19 reviews) |
Integration
AI/ ML Integration | Based on 20 SQL Server 2019 reviews and verified by the G2 Product R&D team. Integrates with data science workflows, Machine Learning and artificial intelligence (AI) capabilities. | 79% (Based on 20 reviews) | |
BI Tool Integration | Based on 25 SQL Server 2019 reviews and verified by the G2 Product R&D team. Integrates with BI Tools to transform data into Actionable Insights. | 82% (Based on 25 reviews) | |
Data lake Integration | Based on 21 SQL Server 2019 reviews and verified by the G2 Product R&D team. Provides speed in data processing and capturing unstructured, semi-structured and streaming data. | 82% (Based on 21 reviews) |
Deployment
On-Premise | Based on 26 SQL Server 2019 reviews and verified by the G2 Product R&D team. Provides On-Premise deployment options. | 88% (Based on 26 reviews) | |
Cloud | Based on 29 SQL Server 2019 reviews and verified by the G2 Product R&D team. Provides Cloud deployment options (private or public cloud, hybrid cloud). | 82% (Based on 29 reviews) |
Performance
Scalability | Based on 31 SQL Server 2019 reviews and verified by the G2 Product R&D team. Manages huge volumes of data, upscale or downscale as per demand. | 88% (Based on 31 reviews) |
Security
Data Governance | Based on 31 SQL Server 2019 reviews and verified by the G2 Product R&D team. Policies, procedures and standards to manage and access data. | 85% (Based on 31 reviews) | |
Data Security | Based on 27 SQL Server 2019 reviews and verified by the G2 Product R&D team. Restricts data access at a cell level, mask or hide parts of cells, and encrypt data at rest and in motion | 90% (Based on 27 reviews) |
