Azure SQL Data Warehouse Reviews & Product Details

Azure SQL Data Warehouse Overview

What is Azure SQL Data Warehouse?

Azure SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data.

Azure SQL Data Warehouse Details
Product Description

Azure SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data.


Seller Details
Seller
Microsoft
Ownership
NASDAQ:MSFT
Company Website
Phone
+1 (877) 276-2464
Year Founded
1975
HQ Location
Redmond, WA
Total Revenue (USD mm)
$125,843
Twitter
@Microsoft
9,300,495 Twitter followers
LinkedIn® Page
www.linkedin.com
193,766 employees on LinkedIn®
Description

Microsoft Corporation develops, licenses, and supports software products and services; and designs and sells hardware worldwide. Flagship products include Windows, Office, Azure, SQL Server, Exchange, SharePoint, Dynamics ERP and CRM, as well as Xbox; Skype; and Windows Phone.

Show More
Answer a few questions to help the Azure SQL Data Warehouse community
Have you used Azure SQL Data Warehouse before?
Yes

Azure SQL Data Warehouse Reviews

Write a Review
Filter reviews
LinkedIn®
Connections
Popular Mentions
Showing 17 Azure SQL Data Warehouse reviews
Popular Mentions
Showing 17 reviews
Filter Reviews
Filter Reviews
Sort by
Ratings
Company Size
User Role
All Industries
Region
Already have Azure SQL Data Warehouse?
Write a Review
Technology Architect
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Supports native SQL and cloud based no code approach to connect systems, create data warehouse and run analytics and reports Review collected by and hosted on G2.com.

What do you dislike?

Challenge implementing outside Azure in a multi cloud environment Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Recommended for storing and analyzing big data for your IT needs Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Ability to generate multiple reports and analyse historical data in landscape Review collected by and hosted on G2.com.

Show More
Show Less
EC
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Operates as a PaaS with data warehouse features Review collected by and hosted on G2.com.

What do you dislike?

I dislike the cost of the system. Even when not using it they charge you Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Review your market choices. But if you are an Azure or Microsoft client, the migration to Azure SQL Data Warehouse is fairly painless and the level of integration and the breadth of offerings is strong. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data warehousing without the capital costs and ability to expand resources quickly Review collected by and hosted on G2.com.

Show More
Show Less
UC
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I love the easy of data transfer between on premise and cloud capabilities. Review collected by and hosted on G2.com.

What do you dislike?

It can be costly if you don't watch your data processes tightly. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you are a Microsoft shop already this is a nice fit. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Our SQL users like being able to access the cloud database from their local computers instead of logging on to a virtual machine to get behind a firewall. Review collected by and hosted on G2.com.

Show More
Show Less
II
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Really it is very decent software for storing and retrieving data . it is very simple and responsive . it is same as sql server. it is robust and integrated software . it is very secure . l like pAAS and data mining. Review collected by and hosted on G2.com.

What do you dislike?

nothing ! really it is good

sometimes it lags when RAM is less. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Really it is very good TOOL for running queries .so I highly recommend this to everyone Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

decent warehouse ever

I have used for sql queries

I have used for data mining

I have used for ETL. Review collected by and hosted on G2.com.

Show More
Show Less
Senior Software Engineer - Customer Success
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I work with implementations where Azure SQL DWH is used and the scalability it provides is best in the market Review collected by and hosted on G2.com.

What do you dislike?

Pricing . The pricing is high considering the open source competitors, Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

With Azure SQL DWH I am resolving the scalability issues which I saw with other vendors Review collected by and hosted on G2.com.

Show More
Show Less
II
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

it 's provide very high storage big data capacity we can store the data in petabytes that makes the most excite for everyone.it has massive parallel processing capability that execute thousands of queries parallely Review collected by and hosted on G2.com.

What do you dislike?

we can not execute the merge statement for doing SCD2 implementation and higher cost.if we have very less data then it we can not use because of high cost Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

storing data on very large size,easy to use,integration is easy Review collected by and hosted on G2.com.

Show More
Show Less
Senior Sql Server developer
Computer Software
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I like below features of azure sql data warehouse.

1)It support cloud computing. This makes it high availability.

2) It allows to create Virtual machine. It is easy and saves time.

3)Its GUI is simple. It is easy to use. Review collected by and hosted on G2.com.

What do you dislike?

1) It do not support some features of T-SQL like Error_LIne.

2)It do not provide support for entity framework.

3) The column store tables do not support secondary non-clustered indexes.

4)SQL azure database do not support sql jobs as provided by sql agent . Review collected by and hosted on G2.com.

Recommendations to others considering the product:

If you need 24/7 availability of database with high performance then this is a good choice. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We have huge data distributed at different locations. It helps us to analyze this data.

I consider below benifit's of using azure sql data warehouse.

1) It provides 24/7 availability .

2) It provides lost data by using backups.

3) It provides inbuilt support for optimized performance. Review collected by and hosted on G2.com.

Show More
Show Less
Programmer Analyst
Computer Software
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Flexibility, and scalability also dont have to worry about maintaining it can also do schedule maintenance Review collected by and hosted on G2.com.

What do you dislike?

Security still seems like not up to the mark also security and role vould be more simlar to setup and it would have been great if i could setup a securoty based on region Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

We can move out all data warehouse to azure and so far i can say it can save you a big amount of money rather doing in house Review collected by and hosted on G2.com.

Show More
Show Less
Junior Software Developer
Retail
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

I like how all Azure technologies work side-by-side. Having Azure Storage and Azure Functions setup in our cloud enabled us to deliver solutions to our clients faster. With Azure SQL Data Warehouse, data management becomes a walk in a park in our team. It's easy to use. I feel safe when I'm experimenting with it for the first time. Support is awesome. Review collected by and hosted on G2.com.

What do you dislike?

There is a learning curve to managing data and security. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

With all the confusing configuration and setup, Azure SQL Data Warehouse eliminated all those issues by providing an intuitive and powerful tool for the job. Review collected by and hosted on G2.com.

Show More
Show Less
UC
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

1. This is very high in performance and lower in cost.

2. Provides secure cloud data warehouse.

3. This processes huge amount of data even parallel processing.

4. Native connectivity with data integration and visualization.

5. This uses intelligent caching to accelerate the data.

6. Significant query performance improvement.

7. Very good for OLAP environment.

8. Provides Platform as a service cloud based solution.

9. Built in automated database backups.

10. Combines relational data with cloud scale capabilities. Review collected by and hosted on G2.com.

What do you dislike?

Azure data warehouse Supports only 1024 active connections. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

1. Handled large volume data with massive storage. No storage limit.

2. Performance improvement even for large and complex queries.

3. Reduced dependency on IT team. Review collected by and hosted on G2.com.

Show More
Show Less
AI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Azure SQL has a high-performance, globally available, and lower-cost secure cloud data warehouse. It has independently scale compute and storage. It has Combine with leading data integration and BI solutions. Review collected by and hosted on G2.com.

What do you dislike?

it can improve the user interface and can adds some more shortcuts. some times its hard to find the right function key. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It has a high-performance, globally available, and lower-cost secure cloud data warehouse. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

used for independently scale compute and storage. data integration and visualization services Review collected by and hosted on G2.com.

Show More
Show Less
AH
Mid-Market(51-1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Azure SQL Data Warehouse has been an amazing tool for our small company. We started collecting data just a few years ago and we were constantly running our of space. We migrated our data to Azure SQL Data warehouse and it had been our best move. We now have unlimited space and access to the data. We now are using the data on a daily basis to help make vital decisions. Review collected by and hosted on G2.com.

What do you dislike?

The set up process was a long and tedious process that was an exhausting experience. I would never want to leave because I would never want to go through the process again. Review collected by and hosted on G2.com.

Recommendations to others considering the product:

Give better assistance with the implementation process of the product. Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Using Azure SQL data warehouse has allowed our organization to have access to the data which has helped us make important business decisions. Also as our business grows Azure can grow with us. We now do not face the problem of running out of storage space. Review collected by and hosted on G2.com.

Show More
Show Less
EC
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
Business partner of the seller or seller's competitor, not included in G2 scores.
What do you like best?

SQL Data Warehouse provides a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data. Review collected by and hosted on G2.com.

What do you dislike?

The limitation on the number of connections Review collected by and hosted on G2.com.

Recommendations to others considering the product:

It's a perfect solutions Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Trying to build a cloud based system for 3 clients for my org. Really amazed by the product Review collected by and hosted on G2.com.

Show More
Show Less
AI
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

Azure sql is better performance than on Prem version and this anlystics engine is improved lot..security is very much improved Review collected by and hosted on G2.com.

What do you dislike?

Their integrations are more with enterprises products and limitations with open source Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Bi analytics and reports Review collected by and hosted on G2.com.

Show More
Show Less
UI
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

- Auto querying

- Good UI

- Fast and seamless Review collected by and hosted on G2.com.

What do you dislike?

- It crashes sometimes

- Can be a lighter version on the system Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

Data warehousing (ETL)

SQL Querying Review collected by and hosted on G2.com.

Show More
Show Less
Business Analyst/Product Owner
Food & Beverages
Small-Business(50 or fewer emp.)
Validated Reviewer
Review source: Invitation from G2
What do you like best?

It has friendly version like SQL server. Review collected by and hosted on G2.com.

What do you dislike?

The functions are bit complex to understand (at least for me). Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

It was regular use as a data warehouse, as such nothing specific/additional requirement Review collected by and hosted on G2.com.

Show More
Show Less
Business Intelligence Analyst Intern
Computer Software
Enterprise(> 1000 emp.)
Validated Reviewer
Review source: Organic
What do you like best?

integrity, PaaS, Data mining, can use to build a data warehouse from scratch Review collected by and hosted on G2.com.

What do you dislike?

none, very well covered for data warehouse projects Review collected by and hosted on G2.com.

What problems are you solving with the product? What benefits have you realized?

building data warehouse Review collected by and hosted on G2.com.

Show More
Show Less