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

Compare Amazon EMR and Microsoft SQL Server

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
Amazon EMR
Amazon EMR
Star Rating
(64)4.1 out of 5
Market Segments
Enterprise (58.9% of reviews)
Information
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Amazon EMR
Microsoft SQL Server
Microsoft SQL Server
Star Rating
(2,252)4.4 out of 5
Market Segments
Enterprise (45.5% of reviews)
Information
Pros & Cons
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 its Query Language with a score of 9.2, making it a preferred choice for complex queries, while Amazon EMR, although strong, scores slightly lower at 8.9. Reviewers mention that SQL Server's T-SQL capabilities provide a more robust experience for data manipulation.
  • Reviewers mention that Microsoft SQL Server's Data Migration feature scores a perfect 9.0, indicating a seamless transition for users moving from other databases. In contrast, Amazon EMR's migration capabilities are not as highly rated, which can be a concern for users looking to switch.
  • Users on G2 highlight the superior Backup and Recovery options in Microsoft SQL Server, also scoring 9.0, which provides peace of mind for data integrity. Amazon EMR, while functional, does not match this level of reliability, scoring lower in this critical area.
  • G2 users report that Microsoft SQL Server's Performance and Reliability is rated at 9.2, showcasing its ability to handle high workloads efficiently. In comparison, Amazon EMR's performance rating of 8.8 suggests it may not be as reliable under heavy data processing tasks.
  • Reviewers mention that Microsoft SQL Server's User, Role, and Access Management features score 9.0, providing robust security and control over data access. Amazon EMR, with a score of 8.5, offers decent management but lacks some of the advanced features that SQL Server provides.
  • Users say that Microsoft SQL Server's Data Dictionary feature, rated at 8.9, is highly praised for its comprehensive documentation and ease of use, while Amazon EMR's documentation is less extensive, leading to a score that does not meet the same user expectations.
Pricing
Entry-Level Pricing
Amazon EMR
No pricing available
Microsoft SQL Server
No pricing available
Free Trial
Amazon EMR
No trial information available
Microsoft SQL Server
No trial information available
Ratings
Meets Requirements
8.6
50
9.0
1,849
Ease of Use
8.2
49
8.6
1,865
Ease of Setup
8.4
22
8.1
986
Ease of Admin
8.6
22
8.3
947
Quality of Support
8.2
49
8.3
1,643
Has the product been a good partner in doing business?
8.9
22
8.4
897
Product Direction (% positive)
7.9
44
8.4
1,820
Features by Category
Database Management Systems (DBMS)Hide 10 FeaturesShow 10 Features
Not enough data
9.0
163
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
Not enough data
8.9
1,434
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
Big Data Processing and DistributionHide 10 FeaturesShow 10 Features
8.7
38
8.4
57
Database
8.1
27
8.5
56
8.5
30
8.8
57
8.1
7
8.4
54
Integrations
8.9
33
7.8
45
8.9
31
8.2
45
Platform
8.7
25
8.2
50
8.7
31
8.5
53
8.9
31
8.2
45
Processing
9.1
31
8.5
52
8.7
31
8.5
55
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
Amazon EMR
Amazon EMR
Microsoft SQL Server
Microsoft SQL Server
Amazon EMR and Microsoft SQL Server are categorized as Big Data Processing and Distribution
Unique Categories
Amazon EMR
Amazon EMR has no unique categories
Reviews
Reviewers' Company Size
Amazon EMR
Amazon EMR
Small-Business(50 or fewer emp.)
21.4%
Mid-Market(51-1000 emp.)
19.6%
Enterprise(> 1000 emp.)
58.9%
Microsoft SQL Server
Microsoft SQL Server
Small-Business(50 or fewer emp.)
18.5%
Mid-Market(51-1000 emp.)
36.0%
Enterprise(> 1000 emp.)
45.5%
Reviewers' Industry
Amazon EMR
Amazon EMR
Financial Services
25.0%
Computer Software
19.6%
Information Technology and Services
14.3%
Retail
5.4%
Health, Wellness and Fitness
3.6%
Other
32.1%
Microsoft SQL Server
Microsoft SQL Server
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
Amazon EMR
Amazon EMR Alternatives
Snowflake
Snowflake
Add Snowflake
Databricks Data Intelligence Platform
Databricks Data Intelligence Platform
Add Databricks Data Intelligence Platform
Qubole
Qubole
Add Qubole
Azure HDInsight
Azure HDInsight
Add Azure HDInsight
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
Amazon EMR
Amazon EMR Discussions
Monty the Mongoose crying
Amazon EMR has no discussions with answers
Microsoft SQL Server
Microsoft SQL Server Discussions
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
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 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