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.
RaimaDB
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.
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
At a Glance
Market Segments
Enterprise (47.6% of reviews)
Enterprise (45.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 DremioMicrosoft SQL Server
Star Rating
(2,252)4.4 out of 5
Market Segments
Enterprise (45.5% of reviews)
Pros & Cons
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,849
Ease of Use
9.2
53
8.6
1,865
Ease of Setup
8.4
47
8.1
986
Ease of Admin
7.8
29
8.3
947
Quality of Support
8.5
50
8.3
1,643
Has the product been a good partner in doing business?
9.1
28
8.4
897
Product Direction (% positive)
9.7
46
8.4
1,820
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
151
Not enough data
8.9
151
Not enough data
9.2
156
Not enough data
8.9
151
Not enough data
8.9
153
Maintenance
Not enough data
8.9
151
Not enough data
9.0
156
Not enough data
9.0
152
Security
Not enough data
8.9
150
Not enough data
9.1
152
Management
Not enough data
9.1
149
Not enough data
9.2
150
Not enough data
8.8
136
Not enough data
8.9
142
Support
Not enough data
8.6
145
Not enough data
9.0
149
Not enough data
8.7
144
Not enough data
8.4
148
Security
Not enough data
8.9
148
Not enough data
9.0
148
Not enough data
8.9
145
Not enough data
9.0
148
Performance
Not enough data
8.7
144
Not enough data
8.8
141
Not enough data
8.8
147
Not enough data
8.7
145
Not enough data
8.8
146
Database Features
Not enough data
8.9
1284
Not enough data
9.0
1289
Not enough data
8.9
1296
Not enough data
8.7
1263
Not enough data
8.8
1265
Not enough data
8.8
1271
Not enough data
9.1
1291
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.5
56
Feature Not Available
8.8
57
Feature Not Available
8.4
54
Integrations
9.0
18
7.8
45
7.9
13
8.2
45
Platform
9.1
20
8.2
50
8.7
13
8.5
53
7.9
13
8.2
45
Processing
9.1
18
8.5
52
8.6
13
8.5
55
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.2%
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.
