Introducing G2.ai, the future of software buying.Try now
Compare Dremio and SQL Server 2019 
Featured Products
Sponsored
You’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Starburst
Visit Website
At a Glance
Market Segments
Enterprise (47.6% of reviews)
Mid-Market (35.5% of reviews)
Entry-Level Pricing
No pricing available
No pricing available
Dremio
Star Rating
(69)4.6 out of 5
Market Segments
Enterprise (47.6% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about DremioSQL Server 2019
Star Rating
(82)4.5 out of 5
Market Segments
Mid-Market (35.5% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about SQL Server 2019Summary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that SQL Server 2019 excels in Data Querying with a score of 9.2, making it a preferred choice for complex queries, while Dremio, although strong, scores slightly lower in this area.
- Reviewers mention that Dremio shines in Data Lake Integration with a score of 9.1, allowing seamless connections to various data sources, whereas SQL Server 2019's integration capabilities are rated at 8.2.
- G2 users highlight that SQL Server 2019 offers robust Data Compression features with a score of 8.8, which helps in optimizing storage, while Dremio's score of 8.6 indicates it is slightly less effective in this area.
- Users on G2 report that Dremio provides superior Data Lake Analytics capabilities, scoring 9.0, which is particularly beneficial for organizations leveraging large datasets, compared to SQL Server 2019's score of 8.4.
- Reviewers say that SQL Server 2019 has a strong focus on In-Database Machine Learning with a score of 7.8, which is a significant feature for data scientists, while Dremio does not have a comparable offering in this area.
- Users report that Dremio's Ease of Use is rated at 9.1, making it more user-friendly for non-technical users compared to SQL Server 2019's score of 8.9, which may require more technical expertise to navigate effectively.
Pricing
Entry-Level Pricing
Dremio
No pricing availableSQL Server 2019
No pricing availableFree Trial
Dremio
Free Trial is available
SQL Server 2019
No trial information availableRatings
Meets Requirements
8.7
52
9.0
53
Ease of Use
9.2
53
8.9
53
Ease of Setup
8.4
47
8.3
21
Ease of Admin
7.8
29
8.3
18
Quality of Support
8.5
50
8.8
47
Has the product been a good partner in doing business?
9.1
28
8.3
17
Product Direction (% positive)
9.7
46
9.3
48
Features by Category
Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Self Service
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Advanced Analytics
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Data Management
8.6
23
9.1
33
|
Verified
8.5
20
8.8
30
|
Verified
8.3
12
8.9
31
|
Verified
7.7
20
8.4
27
|
Verified
Feature Not Available
7.8
19
|
Verified
8.9
23
8.4
19
|
Verified
Integration
Feature Not Available
7.9
20
|
Verified
8.8
21
8.2
25
|
Verified
9.0
22
8.2
21
|
Verified
Deployment
8.7
15
8.8
26
|
Verified
8.5
19
8.2
29
|
Verified
Performance
8.3
21
8.8
31
|
Verified
Security
8.2
20
8.5
31
|
Verified
Feature Not Available
9.0
27
|
Verified
Generative AI
6.9
12
Not enough data
Not enough data
Not enough data
Data Management
8.6
11
Not enough data
8.8
11
Not enough data
Feature Not Available
Not enough data
Data as a Service
7.6
11
Not enough data
8.2
11
Not enough data
Architecture
8.2
11
Not enough data
8.6
11
Not enough data
Deployment & Integration - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Data Connectivity & Federation - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Data Modeling & Metrics - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Performance Optimization - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Governance - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Advanced Intelligence - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Agentic AI Enablement - Semantic Layer Tools
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Database
Feature Not Available
Not enough data
Feature Not Available
Not enough data
Feature Not Available
Not enough data
Integrations
9.0
18
Not enough data
7.9
13
Not enough data
Platform
9.1
20
Not enough data
8.7
13
Not enough data
7.9
13
Not enough data
Processing
9.1
18
Not enough data
8.6
13
Not enough data
Data Transformation
Feature Not Available
Not enough data
9.2
24
Not enough data
Connectivity
8.6
22
Not enough data
Feature Not Available
Not enough data
8.9
23
Not enough data
8.9
25
Not enough data
Operations
7.2
25
Not enough data
7.1
25
Not enough data
7.8
27
Not enough data
7.7
21
Not enough data
7.0
21
Not enough data
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
Dremio and SQL Server 2019 are categorized as Data Warehouse
Unique Categories
Dremio is categorized as Big Data Processing and Distribution, Big Data Analytics, Data as a Service (DaaS), and Semantic Layer Tools
SQL Server 2019 has no unique categories
Reviews
Reviewers' Company Size
Dremio
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
SQL Server 2019
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Financial Services
23.8%
Information Technology and Services
11.1%
Computer Software
7.9%
Marketing and Advertising
4.8%
Automotive
4.8%
Other
47.6%
Computer Software
28.6%
Information Technology and Services
18.2%
Banking
6.5%
Financial Services
5.2%
Insurance
3.9%
Other
37.7%
Alternatives
Discussions
What is a Dremio reflection?
1 Comment
Official Response from Dremio
A reflection is an optimized materialization of source data or a query, similar to a materialized view, that is derived from an existing table or view. A...Read more
Dremio has no more discussions with answers
What is SQL Server 2019 used for?
1 Comment
AA
SQL Server 2019 is a popular relational database management system (RDBMS) developed by Microsoft. It is primarily used for managing and storing data in a...Read more
SQL Server 2019 has no more discussions with answers
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
