2019-07-28T07:35:00Z

What advice do you have for others considering Microsoft Azure SQL Data Warehouse?


If you were talking to someone whose organization is considering Microsoft Azure SQL Data Warehouse, what would you say?

How would you rate it and why? Any other tips or advice?

Guest
99 Answers

author avatar
Top 10Real User

If you are using Microsoft products, such as Office 365, then this solution is good because it can take the data from multiple sources. This is a good product, but when you compare to Oracle Data Warehouse there are differences in scalability, high availability, and implementation. I would rate this solution a seven out of ten.

2019-12-18T05:44:00Z
author avatar
Top 5Real User

There are certain design concepts that can be used to design a data warehouse. My advice to anybody who is implementing this solution is to first study the user's needs, and then go with that approach. The design will be specific to the needs. I would rate this solution an eight out of ten.

2019-12-15T05:58:00Z
author avatar
Top 5Real User

The core strength of Microsoft technologies is ease of use and administration, regardless of the type of product. This is a good solution to go with, the cost is reasonable, and I recommend it. I would rate this solution an eight out of ten.

2019-12-12T07:48:00Z
author avatar
Top 10Real User

This solution is being changed from day-to-day. Now it has become Synapse Analytics and a lot of things are being added to it. I'm curious to see how that turns out. They have a lot of new integrations and features, including predictive analysis and big data integration. They may have solved the issues with concurrent connectivity, so I'm curious to put my hands on it. The product is being upgraded and updated to support a lot of analytic features, and it is a great tool to use. I would rate this solution a nine out of ten.

2019-12-11T05:40:00Z
author avatar
Top 10Real User

It's a nice solution for a simple data warehousing, but it's still an immature solution. It is stable but it takes a lot of time. Smaller companies have better products, but the problem will always be there and the smaller company will not survive. Customers will have tools that are not supported anymore. Microsoft is so big that people trust them, they will eventually get there but it will take time to get the features with quality. There are, however, some solutions available that are better and cheaper. You can purchase them instead of having to reprogram everything that you have already done. My advice would be to compare this solution with others. Snowflake would be a comparable solution. It's cheaper, faster, and better. I would rate this solution a seven out of ten.

2019-11-13T05:29:00Z
author avatar
Top 10Real User

My advice to other people considering this solution is that this is a great product. But there is one problem and that is the rate that Microsoft is changing its software implementations. The rapid changes could make it hard to keep up with upgrades. Some of the features get enabled and disabled very quickly. So we are waiting now until everything settles down because cloud technology is still evolving. We understand that. But, on the other hand, as they make so many changes to keep up with the technology, it remains hard to predict what the future of the product is. I might say to anyone that they wait for some time in 2020 and then start using the product. On a scale from one to ten where one is the worst and ten is the best, I would rate the product as somewhere between a seven or an eight. If I have to choose seven or eight, I would pick seven-out-of-10.

2019-11-13T05:28:00Z
author avatar
Real User

I will rate this solution an eight out of ten. Not a ten due to the lack of integration.

2019-10-15T05:02:00Z
author avatar
Consultant

I would rate it a seven out of ten.

2019-09-23T06:34:00Z
author avatar
Real User

My advice for anybody researching this or a similar solution is to list the pros and cons, along with the price, and estimate your needs before starting the project. I would also suggest contacting support for Microsoft, Google, and Amazon. Finally, look into other, better-niched providers, like Teradata. Scaling this solution is easy and the uptime is okay. It is easy to use, and the support is excellent. My biggest complaint is the cost. I would rate this solution a nine out of ten.

2019-07-28T07:35:00Z
Learn what your peers think about Microsoft Azure Synapse Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
442,845 professionals have used our research since 2012.