What users are saying about
15 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 8.3 out of 100
Based on 15 reviews and ratings
163 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 8.1 out of 100
Based on 163 reviews and ratings
Likelihood to Recommend
Azure Synapse Analytics (Azure SQL Data Warehouse)
It is very well suited for big data analytics. Predictive modeling, optimization, and other large scale analysis benefit from using a properly defined SQL Data Warehouse. It is also suited for simple business intelligence such as building historical and active dashboards

Verified User
Contributor in Information Technology
Information Technology and Services Company, 10,001+ employeesAzure SQL Database
The most important positive for our organization is the ability to scale up or down at will. As a startup, we needed to quickly adapt to changing space and performance needs. It's also integral as we grow different branches of the business. Thus far, we haven't encountered much of anything with the tool that hasn't been a good fit for our business.

Verified User
Team Lead in Other
Computer Software Company, 11-50 employeesFeature Rating Comparison
Database-as-a-Service
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Azure SQL Database
9.0
Automatic software patching
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Azure SQL Database
8.9
Database scalability
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Azure SQL Database
9.2
Automated backups
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Azure SQL Database
8.9
Database security provisions
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Azure SQL Database
9.2
Monitoring and metrics
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Azure SQL Database
8.8
Automatic host deployment
Azure Synapse Analytics (Azure SQL Data Warehouse)
—
Azure SQL Database
8.9
Pros
Azure Synapse Analytics (Azure SQL Data Warehouse)
- It is very cost-effective
- Development time needed was much less in comparison to other systems
- Played very nicely with our ETL and OLAP reporting tools
SQL Development Team Lead
Allianz Asset ManagementInvestment Management, 1001-5000 employees
Azure SQL Database
- Scalability is #1: if it used to be an almost no-win endeavour to try to modernize your server or migrate to other hardware, with Azure SQL Database it becomes a press of a button.
- All the tools simply work after you are on Azure SQL Database.
- The applications do not need changes in order to start using Azure SQL Database.
- Hybrid Cloud scenarios will work.
- Clustering and failover - already there.
- You can start monitoring the use and extract performance insights in a new way in Azure.
Senior Data Platform Consultant
Generali Global Health ServicesInsurance, 5001-10,000 employees
Cons
Azure Synapse Analytics (Azure SQL Data Warehouse)
- Limited T-SQL query library
- It is not suitable for OLTP environment
- Doesn't support cross-database queries
Associate - Project
CognizantInformation Technology & Services, 10,001+ employees
Azure SQL Database
- A little slow on processing complex or large Views. We use a lot of Views to feed our BI system, and the processing time could see some improvement, IMHO.
- Additional monitoring components would be nice too, automating some built in performance measurement tools would be a nice feature.
- Price can always be improved as well. It’s not bad, but room for improvement.

Verified User
Manager in Finance and Accounting
Consumer Goods Company, 10,001+ employeesLikelihood to Renew
Azure Synapse Analytics (Azure SQL Data Warehouse)
No score
No answers yet
No answers on this topic
Azure SQL Database
Azure SQL Database 8.0
Based on 1 answer
This is best solution as a DBA one could expect from a service provider and as a cloud service, it removes all your hassles.
Software Project Manager
Forman Christian CollegeInformation Technology and Services, 1001-5000 employees
Usability
Azure Synapse Analytics (Azure SQL Data Warehouse)
Azure Synapse Analytics (Azure SQL Data Warehouse) 8.0
Based on 1 answer
It helps us to provide data just in time to our clients. With help of massively parallel processing, it consumes less time for both loading and querying the data and it also helps us to plan a more precise budget to our business and send just-in-time alerts in case of any outrage.
Associate - Project
CognizantInformation Technology & Services, 10,001+ employees
Azure SQL Database
No score
No answers yet
No answers on this topic
Support Rating
Azure Synapse Analytics (Azure SQL Data Warehouse)
Azure Synapse Analytics (Azure SQL Data Warehouse) 7.9
Based on 3 answers
I like their Support team

Verified User
Consultant in Information Technology
Information Technology and Services Company, 10,001+ employeesAzure SQL Database
Azure SQL Database 9.0
Based on 6 answers
We give the support a high rating simply because every time we've had issues or questions, representatives were in contact with us quickly. Without fail, our issues/questions were handled in a timely matter. That kind of response is integral when client data integrity and availability is in question. There is also a wealth of documentation for resolving issues on your own.

Verified User
Team Lead in Other
Computer Software Company, 11-50 employeesAlternatives Considered
Azure Synapse Analytics (Azure SQL Data Warehouse)
SQL Data Warehousing is much easier to manage if you already have SQL Server experience and analysts who are familiar with its interface. We are currently piloting using NoSQL and Hadoop type databases but it is difficult to get set up properly. Additionally, we have to re-train our users to learn how to create python scripts and use spark to query the data

Verified User
Contributor in Information Technology
Information Technology and Services Company, 10,001+ employeesAzure SQL Database
Comparing with Amazon Aurora: Azure SQL DB is 100% compatible with SQL Server and Aurora is compatible with MySQL and PostGreSQL. Because of if, SQL DB suits large enterprises with hundreds of databases better. Comparing with Oracle: the main issue is that Oracle will try to push all other services available in their product offering.

Verified User
Analyst in Information Technology
Mining & Metals Company, 10,001+ employeesReturn on Investment
Azure Synapse Analytics (Azure SQL Data Warehouse)
- We have had an improvement in our overall processing time
- Cost was much lower than most of its competitors
- Our reporting needs have grown and housing the data here has been great
SQL Development Team Lead
Allianz Asset ManagementInvestment Management, 1001-5000 employees
Azure SQL Database
- Our database costs have decreased over time by 20%.
- Our engineer spends much less time managing API calls with some of the new features available.
- Our engineer is planning on using the Power Query embedded feature to streamline some ETL processes.
Director, eCommerce Analytics and Digital Marketing
Franklin SportsSporting Goods, 201-500 employees
Pricing Details
Azure Synapse Analytics (Azure SQL Data Warehouse)
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No
Azure Synapse Analytics (Azure SQL Data Warehouse) Editions & Modules
—
Additional Pricing Details
—Azure SQL Database
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No
Azure SQL Database Editions & Modules
Edition
2 vCORE | $0.50441 |
---|---|
6 vCORE | $1.51311 |
10 vCORE | $2.521 |
- Per Hour