Introducing G2.ai, the future of software buying.Try now
Compare Dremio and Microsoft SQL Server 
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
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.
ER/Studio
Visit Website
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.
RaimaDB
Visit Website
At a Glance
Market Segments
Enterprise (47.6% of reviews)
Enterprise (45.6% 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)
Entry-Level Pricing
No pricing available
Learn more about DremioMicrosoft SQL Server
Star Rating
(2,252)4.4 out of 5
Market Segments
Enterprise (45.6% of reviews)
Entry-Level Pricing
No pricing available
Learn more about Microsoft SQL ServerSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- Users report that Microsoft SQL Server excels in its Query Language capabilities, receiving a score of 9.2, which reviewers mention makes complex queries easier to manage and execute efficiently.
- Reviewers mention that Dremio shines in Data Lake Integration, scoring 9.1, allowing users to seamlessly connect and analyze data from various sources, which enhances their data analytics capabilities.
- G2 users highlight that Microsoft SQL Server's Data Replication feature, with a score of 8.8, is robust and reliable, making it a preferred choice for enterprises needing consistent data availability across multiple locations.
- Users on G2 report that Dremio's Cloud Processing capabilities are impressive, scoring 9.3, which allows for efficient handling of large datasets in real-time, a feature that many find beneficial for modern data workflows.
- Reviewers say that Microsoft SQL Server's Backup and Recovery features, both scoring 9.0, provide peace of mind with their reliability, ensuring that data can be restored quickly in case of failures.
- Users report that Dremio's AI/ML Integration capabilities, while scoring lower at 7.9, are still noteworthy, as they allow for advanced analytics and machine learning applications, which some users find essential for their data strategies.
Pricing
Entry-Level Pricing
Dremio
No pricing availableMicrosoft SQL Server
No pricing availableFree Trial
Dremio
Free Trial is available
Microsoft SQL Server
No trial information availableRatings
Meets Requirements
8.7
52
9.0
1,847
Ease of Use
9.2
53
8.6
1,863
Ease of Setup
8.4
47
8.1
984
Ease of Admin
7.8
29
8.3
945
Quality of Support
8.5
50
8.3
1,641
Has the product been a good partner in doing business?
9.1
28
8.4
895
Product Direction (% positive)
9.7
46
8.4
1,818
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
Not enough data
8.5
20
Not enough data
8.3
12
Not enough data
7.7
20
Not enough data
Feature Not Available
Not enough data
8.9
23
Not enough data
Integration
Feature Not Available
Not enough data
8.8
21
Not enough data
9.0
22
Not enough data
Deployment
8.7
15
Not enough data
8.5
19
Not enough data
Performance
8.3
21
Not enough data
Security
8.2
20
Not enough data
Feature Not Available
Not enough data
Generative AI
6.9
12
Not enough data
Not enough data
Not enough data
Management
Not enough data
8.9
150
Not enough data
8.9
150
Not enough data
9.2
155
Not enough data
8.9
150
Not enough data
8.9
152
Maintenance
Not enough data
8.9
150
Not enough data
9.0
155
Not enough data
9.0
151
Security
Not enough data
8.9
149
Not enough data
9.1
151
Management
Not enough data
9.1
147
Not enough data
9.2
148
Not enough data
8.8
134
Not enough data
8.9
140
Support
Not enough data
8.6
143
Not enough data
9.1
147
Not enough data
8.7
142
Not enough data
8.5
146
Security
Not enough data
8.9
146
Not enough data
9.1
146
Not enough data
8.9
143
Not enough data
9.0
146
Performance
Not enough data
8.8
142
Not enough data
8.9
139
Not enough data
8.8
145
Not enough data
8.7
143
Not enough data
8.9
144
Database Features
Not enough data
8.9
1282
Not enough data
9.0
1287
Not enough data
8.9
1294
Not enough data
8.7
1261
Not enough data
8.8
1263
Not enough data
8.8
1269
Not enough data
9.1
1289
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
8.6
55
Feature Not Available
8.8
56
Feature Not Available
8.4
53
Integrations
9.0
18
7.8
44
7.9
13
8.3
44
Platform
9.1
20
8.3
49
8.7
13
8.6
52
7.9
13
8.3
44
Processing
9.1
18
8.6
51
8.6
13
8.5
54
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 Microsoft SQL Server are categorized as Big Data Processing and Distribution
Unique Categories
Dremio is categorized as Big Data Analytics, Data Warehouse, Data as a Service (DaaS), and Semantic Layer Tools
Microsoft SQL Server is categorized as Relational Databases, Database Management Systems (DBMS), and On-Premise Data Integration
Reviews
Reviewers' Company Size
Dremio
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Microsoft SQL Server
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%
Information Technology and Services
24.2%
Computer Software
13.7%
Hospital & Health Care
5.4%
Financial Services
4.3%
Higher Education
2.9%
Other
49.6%
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 the best way to save your queries?
4 Comments
CA
I recommend that you use the saved querys in plain text or .sql or txt format you can use the same sql server query creator or a notepad +++ tool, they are...Read more
How could I make much easier the experience with the order of my database?
4 Comments
AF
You can create different tables with your employee information eg employee table, employee roles etc. Then you can create a single view that will pull data...Read more
How can I work on the same query if the connection is lost (timeout) and then I reconnect?
4 Comments
JE
When this happens to me in SQL Server Management Studio, I just have to type USE {your database name here} and then select only that statement and execute...Read more
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.
