Compare Amazon Redshift and SQL Server 2019 
At a Glance
Market Segments
Enterprise (39.8% of reviews)
Mid-Market (35.5% of reviews)
Entry-Level Pricing
$1.22 - $3.26 Per hour
No pricing available
Amazon Redshift
Star Rating
(399)4.3 out of 5
Market Segments
Enterprise (39.8% 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, while Amazon Redshift follows closely with 8.8. Reviewers mention that SQL Server's ability to seamlessly integrate with various data sources enhances its usability for mid-market businesses.
- Reviewers say that SQL Server 2019 shines in Data Quality with a score of 8.9, compared to Amazon Redshift's 8.8. Users on G2 highlight SQL Server's robust data validation features, which help maintain high data integrity.
- Users say that Amazon Redshift offers superior Cloud Deployment capabilities, scoring 8.9 against SQL Server's 8.2. Reviewers mention that Redshift's cloud-native architecture allows for easier scaling and management of large datasets.
- G2 users report that SQL Server 2019 has a slight edge in Quality of Support with a score of 8.8, while Amazon Redshift scores 8.5. Users mention that SQL Server's support team is responsive and knowledgeable, which is crucial for businesses relying on timely assistance.
- Reviewers mention that both products have strong Data Security features, but SQL Server 2019 scores higher at 9.0 compared to Redshift's 8.8. Users report that SQL Server's role-based authorization and encryption features provide a comprehensive security framework.
- Users on G2 highlight that SQL Server 2019's In-Database Machine Learning capabilities, scoring 7.8, are more advanced than Amazon Redshift's 7.7. Reviewers say that SQL Server's integration of machine learning directly within the database allows for more efficient data processing and analysis.
Featured Products
Sponsored
Syncari
(42)
Data Warehouse
Visit Website
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
280
9.0
53
Ease of Use
8.7
281
8.9
53
Ease of Setup
8.6
135
8.3
21
Ease of Admin
8.5
130
8.3
18
Quality of Support
8.5
263
8.8
47
Has the product been a good partner in doing business?
8.7
129
8.3
17
Product Direction (% positive)
8.9
253
9.3
48
Features by Category
Data Management
8.8
129
|
Verified
9.1
33
|
Verified
8.4
121
|
Verified
8.8
30
|
Verified
8.8
127
|
Verified
8.9
31
|
Verified
8.1
123
|
Verified
8.4
27
|
Verified
7.7
98
|
Verified
7.8
19
|
Verified
8.3
114
|
Verified
8.4
19
|
Verified
Integration
7.9
97
|
Verified
7.9
20
|
Verified
8.6
124
|
Verified
8.2
25
|
Verified
8.6
115
|
Verified
8.2
21
|
Verified
Deployment
8.1
98
8.8
26
|
Verified
8.9
126
|
Verified
8.2
29
|
Verified
Performance
8.9
130
|
Verified
8.8
31
|
Verified
Security
8.7
122
|
Verified
8.5
31
|
Verified
8.8
124
|
Verified
9.0
27
|
Verified
Generative AI
Feature Not Available
Feature Not Available
Feature Not Available
Feature Not Available
Storage
8.4
50
Not enough data
8.4
53
Not enough data
Availability
8.7
44
Not enough data
8.2
47
Not enough data
8.4
45
Not enough data
Performance
8.3
45
Not enough data
Security
8.7
44
Not enough data
8.5
49
Not enough data
8.1
44
Not enough data
8.6
45
Not enough data
Support
8.1
40
Not enough data
8.4
44
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.1%
Computer Software
12.4%
Financial Services
8.0%
Retail
5.2%
Telecommunications
4.7%
Other
54.7%
Computer Software
28.6%
Information Technology and Services
18.2%
Banking
6.5%
Financial Services
5.2%
Insurance
3.9%
Other
37.7%
Most Helpful Reviews
Amazon Redshift
Most Helpful Favorable Review
Vijay K.
Verified User in Accounting
Amazon Redshift is one of the best data warehouse platforms provided by AWS. It uses SQL to analyze structured, semi-structured, and unstructured data on the managed servers, so you don't have to worry about infrastructure and hardware maintenance.
Most Helpful Critical Review
Verified User in Computer Software
I dislike the storage and compute are coupled on Redshift.
SQL Server 2019
Most Helpful Favorable Review
Karen H.
Verified User in Information Technology and Services
database management studio is a great tool for me to manage datasets, build stored procs, develop data automation
Most Helpful Critical Review
Vikash K.
Verified User in Computer Software
Windows-based systems can limit their flexibility and portability for organizations that use multiple operating systems. Required Updates and Upgrades: To maintain the security and performance of SQL Server 2019, organizations must regularly apply software...
Vijay K.
Verified User in Accounting
Amazon Redshift is one of the best data warehouse platforms provided by AWS. It uses SQL to analyze structured, semi-structured, and unstructured data on the managed servers, so you don't have to worry about infrastructure and hardware maintenance.
Karen H.
Verified User in Information Technology and Services
database management studio is a great tool for me to manage datasets, build stored procs, develop data automation
Verified User in Computer Software
I dislike the storage and compute are coupled on Redshift.
Vikash K.
Verified User in Computer Software
Windows-based systems can limit their flexibility and portability for organizations that use multiple operating systems. Required Updates and Upgrades: To maintain the security and performance of SQL Server 2019, organizations must regularly apply software...
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 2.5 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.
or continue with
Gmail.com addresses not permitted. A business domain using Google is allowed.
By proceeding, you agree to our Terms of Use and Privacy Policy
