Introducing G2.ai, the future of software buying.Try now

Compare Azure Data Lake Store and Microsoft SQL Server

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
Azure Data Lake Store
Azure Data Lake Store
Star Rating
(39)4.5 out of 5
Market Segments
Enterprise (44.4% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about Azure Data Lake Store
Microsoft SQL Server
Microsoft SQL Server
Star Rating
(2,252)4.4 out of 5
Market Segments
Enterprise (45.6% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about Microsoft SQL Server
AI Generated Summary
AI-generated. Powered by real user reviews.
  • Users report that Microsoft SQL Server excels in query language capabilities, with a score of 9.2, making it a preferred choice for complex queries. In contrast, Azure Data Lake Store, while strong, scores slightly lower at 8.9.
  • Reviewers mention that Azure Data Lake Store shines in data lake functionality, scoring 9.1, which is crucial for handling large volumes of unstructured data. Microsoft SQL Server, however, scores 8.4 in this area, indicating it may not be as robust for data lake needs.
  • G2 users highlight that Azure Data Lake Store offers superior cloud processing capabilities, achieving a score of 9.3 compared to Microsoft SQL Server's 8.5, making it more suitable for cloud-based data operations.
  • Users on G2 report that Microsoft SQL Server provides excellent backup and recovery options, scoring 9.0, which is essential for enterprise-level data management. Azure Data Lake Store does not have a specific score for this feature, indicating a potential gap in its offerings.
  • Reviewers say that Azure Data Lake Store has a better data preparation process, scoring 9.1, which is vital for users looking to clean and organize data efficiently. Microsoft SQL Server scores slightly lower at 8.5 in this area.
  • Users report that both products have strong user, role, and access management features, scoring equally at 9.0, indicating that both solutions provide robust security measures for managing user access.
Pricing
Entry-Level Pricing
Azure Data Lake Store
No pricing available
Microsoft SQL Server
No pricing available
Free Trial
Azure Data Lake Store
No trial information available
Microsoft SQL Server
No trial information available
Ratings
Meets Requirements
9.2
34
9.0
1,847
Ease of Use
8.7
34
8.6
1,863
Ease of Setup
9.2
21
8.1
984
Ease of Admin
8.5
19
8.3
945
Quality of Support
9.1
33
8.3
1,641
Has the product been a good partner in doing business?
8.7
18
8.4
895
Product Direction (% positive)
9.3
33
8.4
1,818
Features by Category
Database Management Systems (DBMS)Hide 10 FeaturesShow 10 Features
Not enough data
9.0
163
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
Not enough data
8.9
1,434
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
Big Data Processing and DistributionHide 10 FeaturesShow 10 Features
9.0
32
8.4
57
Database
9.1
26
8.6
55
8.9
26
8.8
56
9.1
28
8.4
53
Integrations
8.9
23
7.8
44
8.7
24
8.3
44
Platform
8.9
25
8.3
49
9.1
27
8.6
52
8.7
24
8.3
44
Processing
9.3
27
8.6
51
9.2
26
8.5
54
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
Categories
Categories
Shared Categories
Azure Data Lake Store
Azure Data Lake Store
Microsoft SQL Server
Microsoft SQL Server
Azure Data Lake Store and Microsoft SQL Server are categorized as Big Data Processing and Distribution
Unique Categories
Azure Data Lake Store
Azure Data Lake Store has no unique categories
Reviews
Reviewers' Company Size
Azure Data Lake Store
Azure Data Lake Store
Small-Business(50 or fewer emp.)
27.8%
Mid-Market(51-1000 emp.)
27.8%
Enterprise(> 1000 emp.)
44.4%
Microsoft SQL Server
Microsoft SQL Server
Small-Business(50 or fewer emp.)
18.4%
Mid-Market(51-1000 emp.)
36.1%
Enterprise(> 1000 emp.)
45.6%
Reviewers' Industry
Azure Data Lake Store
Azure Data Lake Store
Information Technology and Services
41.7%
Computer Software
8.3%
Automotive
8.3%
Insurance
5.6%
Manufacturing
2.8%
Other
33.3%
Microsoft SQL Server
Microsoft SQL Server
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
Azure Data Lake Store
Azure Data Lake Store Alternatives
Snowflake
Snowflake
Add Snowflake
Google Cloud Dataproc
Google Cloud Dataproc
Add Google Cloud Dataproc
Apache Beam
Apache Beam
Add Apache Beam
Amazon EMR
Amazon EMR
Add Amazon EMR
Microsoft SQL Server
Microsoft SQL Server Alternatives
Teradata Vantage
Teradata Vantage
Add Teradata Vantage
SAP HANA Cloud
SAP HANA Cloud
Add SAP HANA Cloud
Google Cloud SQL
Cloud SQL
Add Google Cloud SQL
Snowflake
Snowflake
Add Snowflake
Discussions
Azure Data Lake Store
Azure Data Lake Store Discussions
Monty the Mongoose crying
Azure Data Lake Store has no discussions with answers
Microsoft SQL Server
Microsoft SQL Server Discussions
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
Afolabi F.
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