Microsoft Azure SQL Data Warehouse Reviews

Microsoft Azure SQL Data Warehouse is the #2 ranked solution of our top Cloud Data Warehouse tools. It's rated 3.9 out of 5 stars, and is most commonly compared to Snowflake - Microsoft Azure SQL Data Warehouse vs Snowflake

Filter by:
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Jael Sande
Real User
Information Architect at Systems Analysis & Design Engineering
Sep 19 2020

What is most valuable?

What I use the most is the tool to identify the upgrades. When you have a data warehouse on-premise you have jobs that run. Similar to an SQL agent, you are not comparing apples to apples, there are… more »

How has it helped my organization?

With our current COVID situation and being under lockdown, many of the businesses are moving to the cloud and it's been beneficial for us. Many consulting agencies have set up online businesses where… more »

What needs improvement?

Technical support needs to improve. Microsoft improves all of the time, but there are some things where different vendors offer data warehousing and data governance that you can build and workaround… more »

What's my experience with pricing, setup cost, and licensing?

There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be. You can adjust it to include… more »

Which solution did I use previously and why did I switch?

I have used Oracle as a backend, but I am not skilled with Oracle. The frontend has always been with Microsoft.

What other advice do I have?

Clients will look at Pro Dell Compare. They use the tool to determine how simple it is or how complicated it will be to move their data. They consider whether they need to make use of one of… more »
Consultant
Sr. Teradata Consultant at a tech services company with 201-500 employees
Aug 01 2020

What is most valuable?

With this solution, I can better understand buying patterns and user habits. I can tell in real-time a customer's review and purchase based on that. I can tell that from the cloud data of Azure Data Warehouse. The solution offers a variety… more »

What needs improvement?

There are features coming int he next few quarters that will be helpful. Soon, Power BI will be directly integrated into Azure. We need to have some Spark tools also available so we can directly select customers and don't need to install… more »

What's my experience with pricing, setup cost, and licensing?

In comparison, I find that AWS is much more costly.

Which solution did I use previously and why did I switch?

I've had prior data warehouse experience with traditional systems like the Oracle, Superserver, or Teradata. Snowflake is the only provider with no cloud platform. You have to buy a platform in order to adopt it. Microsoft Azure, AWS, and… more »

What other advice do I have?

We're a Microsoft partner. I have experience with the Microsoft Cloud Data Warehouse specifically within the Unix cloud environment. We're using the latest version of the solution. It's important for organizations considering the solution… more »
Learn what your peers think about Microsoft Azure SQL Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2020.
438,360 professionals have used our research since 2012.
Mukul Biswas
Real User
Enterprise Solutions - UK Lead at Celebal Technologies
Sep 19 2020

What is most valuable?

Some of the most valuable features would include Familiarity for practitioners like us and also familiarity for the businesses. SQL servers have been around for several decades and there are many who are familiar with SQL servers, such as SSIS and SSRS. They are available on the Cloud, and the… more »

What needs improvement?

What I would like to see more and more of in Azure is its support for IoT and streaming media information. It needs strong support for social media, internet data, and native support for NoSQL. At this time, it works very well with the structured data Stability could be improved. Technical support… more »

What's my experience with pricing, setup cost, and licensing?

They are cost aggressive, and it integrates well with other Microsoft tools. For example Downstream and Teams.

What other advice do I have?

We use the serverless platform as a service, that is only available with Microsoft Azure. You don't have to hire experienced engineers to set up and implement the solution, saving you money, because it is very intuitive and the turnaround time is very low compared to other data warehouses. I would… more »
Real User
Managing Partner at a tech services company with 11-50 employees
Nov 17 2019

What is most valuable?

The most valuable feature is the scalability. It scales out, so you can build a large database and not have to think about whether it performs, or about connecting to the servers to become larger.

What needs improvement?

There are several specific features and functions available on the on-premises version that do not work with the cloud version. There are many issues regarding migration. They are building it more and more, but if you have the same version on local you cannot just go to the cloud because some of the… more »

What's my experience with pricing, setup cost, and licensing?

This solution starts at €1000.00 a month for just the basics and can go up to €300,000.00 per month for the fastest version. It's pay as you go, so you never know what your bill is going to be beforehand, and that's scary for customers. If you have someone who makes a mistake and the program's a… more »

What other advice do I have?

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… more »
Real User
EMEA IT Program Manager for Sales, Marketing & eCommerce at a transportation company with 10,001+ employees
Jul 30 2019

What is most valuable?

The most valuable features of this solution are its easy setup and ease of use. The SQL functions are ok. I've been working with Microsoft SQL Server, MySQL, and PostgreSQL for a long time, and… more »

What needs improvement?

There are several things that I would like to see improved with this solution, including: * The price of this solution could be improved. * I would like to see better integration with Active… more »

What's my experience with pricing, setup cost, and licensing?

This is a pricey solution.

Which solution did I use previously and why did I switch?

We used Power BI before choosing this solution.

What other advice do I have?

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… more »

Which other solutions did I evaluate?

This solution was my recommendation, and I made it because we are a big Microsoft customer and, as such, felt that the integration would be smoother. It probably was. We did evaluate other options… more »
Real User
Data Architect at a tech services company with 10,001+ employees
Nov 14 2019

What is most valuable?

What I like the most would be MPP (Massively Parallel Processing) architecture. Because we had to migrate a lot of data and it helps us a lot to make things faster.

What needs improvement?

As far as improvements to the product, I think the Data Factory integration should be enhanced to be properly implemented because right now it is still lagging behind other vendors like Informatica. We ended up having to use Data Factory because we don't have any expertise in Informatica. But I want to see Data Factory get better overall. An enhancement I would like to see is in data loading for… more »

What other advice do I have?

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… more »
AveekDas
Real User
Analytics Engineer at a tech services company with 51-200 employees
Dec 17 2019

What is most valuable?

The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis. We have a nightly load where all of the data is updated, and it is a very good feature. The transaction log shipping gives us the ability to replicate the database onto different… more »

What needs improvement?

The major concern is that I have a hard time with having to version control the data warehouse all the time. As it is now, I have to open all of the ports and push everything onto the server. I would like to see version control implemented into the data warehouse. This would make the tool perfect.

Which solution did I use previously and why did I switch?

I began with Microsoft SQL Server and have been on the Microsoft platform ever since.

What other advice do I have?

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.
Real User
Practice Head BI at a tech services company with 1,001-5,000 employees
Dec 12 2019

What is most valuable?

The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range. When we are not using this solution we can simply shut it down saving us costs, which is a nice advantage.

What needs improvement?

With respect to what needs to be improved, concurrent connectivity has some limitations.

What other advice do I have?

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… more »
See 8 More Microsoft Azure SQL Data Warehouse Reviews

What is Microsoft Azure SQL Data Warehouse?

Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.

Also known as
Microsoft Azure SQL DW, Azure SQL Data Warehouse
Microsoft Azure SQL Data Warehouse customers

Toshiba, Carnival, LG Electronics, Jet.com, Adobe,