Introducing G2.ai, the future of software buying.Try now
Compare Amazon Redshift 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
Mid-Market (39.5% of reviews)
Mid-Market (35.5% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
No pricing available
Amazon Redshift
Star Rating
(397)4.3 out of 5
Market Segments
Mid-Market (39.5% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
Browse all 6 pricing plansSQL Server 2019
Star Rating
(82)4.5 out of 5
Market Segments
Mid-Market (35.5% of reviews)
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 Integration with a score of 9.1, which reviewers mention makes it easier to connect with various data sources compared to Amazon Redshift's score of 8.8.
- Reviewers mention that SQL Server 2019's Built-In Data Analytics feature, rated at 8.4, provides robust analytical capabilities directly within the database, while Amazon Redshift's score of 8.1 indicates it may require additional tools for similar functionality.
- G2 users highlight SQL Server 2019's superior Ease of Setup with a score of 8.3, suggesting that it is more user-friendly for initial deployment compared to Amazon Redshift's score of 8.6, which some users find slightly more complex.
- Users on G2 report that SQL Server 2019 offers better Data Quality management with a score of 8.9, while Amazon Redshift's score of 8.8 indicates it is still strong but may not meet the same level of user satisfaction.
- Reviewers mention that SQL Server 2019's Data Security features, rated at 9.0, are highly regarded, particularly for its role-based authorization and encryption capabilities, whereas Amazon Redshift's score of 8.8 suggests it may not provide the same level of confidence for sensitive data.
- Users say that SQL Server 2019's Quality of Support is rated at 8.8, which many find responsive and helpful, while Amazon Redshift's score of 8.5 indicates that while support is good, it may not be as consistently praised by users.
Pricing
Entry-Level Pricing
Amazon Redshift
RA3.4xlarge
$1.22 - $3.26
Per hour
On-demand, 1-Year, or 3-Year Terms
- Commit to save up to 34%
SQL Server 2019
No pricing availableFree Trial
Amazon Redshift
Free Trial is available
SQL Server 2019
No trial information availableRatings
Meets Requirements
8.7
281
9.0
53
Ease of Use
8.7
281
8.9
53
Ease of Setup
8.6
138
8.3
21
Ease of Admin
8.4
128
8.3
18
Quality of Support
8.5
264
8.8
47
Has the product been a good partner in doing business?
8.7
127
8.3
17
Product Direction (% positive)
8.8
252
9.3
48
Features by Category
Data Management
8.8
133
|
Verified
9.1
33
|
Verified
8.4
125
|
Verified
8.8
30
|
Verified
8.8
131
|
Verified
8.9
31
|
Verified
8.0
127
|
Verified
8.4
27
|
Verified
7.6
102
|
Verified
7.8
19
|
Verified
8.3
118
|
Verified
8.4
19
|
Verified
Integration
7.9
101
|
Verified
7.9
20
|
Verified
8.7
128
|
Verified
8.2
25
|
Verified
8.6
119
|
Verified
8.2
21
|
Verified
Deployment
8.1
102
8.8
26
|
Verified
8.9
130
|
Verified
8.2
29
|
Verified
Performance
8.9
134
|
Verified
8.8
31
|
Verified
Security
8.7
126
|
Verified
8.5
31
|
Verified
8.8
128
|
Verified
9.0
27
|
Verified
Generative AI
7.3
20
Not enough data
7.2
19
Not enough data
Storage
8.4
53
Not enough data
8.4
56
Not enough data
Availability
8.6
47
Not enough data
8.2
50
Not enough data
8.4
48
Not enough data
Performance
8.2
48
Not enough data
Security
8.7
47
Not enough data
8.4
52
Not enough data
8.1
47
Not enough data
8.5
48
Not enough data
Support
7.9
43
Not enough data
8.5
47
Not enough data
Categories
Categories
Shared Categories
Amazon Redshift and SQL Server 2019 are categorized as Data Warehouse
Unique Categories
Amazon Redshift is categorized as Columnar Databases and Big Data Integration Platforms
SQL Server 2019 has no unique categories
Reviews
Reviewers' Company Size
Amazon Redshift
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
Information Technology and Services
15.5%
Computer Software
12.7%
Financial Services
7.7%
Retail
5.2%
Telecommunications
4.7%
Other
54.1%
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
Should I use with a data mart for a frontend tool that make request on it ?
3 Comments
NM
Hi Mehdi
Can you elaborate your question?
AWS Redshift is a DataBase/Data Warehouse service, which is Ideal for Analytical use cases.
You can...Read more
When can I use Amazon redshift?
3 Comments
PG
Redshift is big data warehousing solution to handle petabytes of data and also for real time decisions. If you want highly optimized data warehousing...Read more
What are the characteristics of redshift?
2 Comments
AK
Redshift is mainly used for Big data and analytics to store the data in columner format. Retrieve the data is very fast and parallel processing also most...Read more
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.
