TrustRadius
SQL Data Warehouse from Microsoft is a data warehouse-as-a-service for enterprises.SQL Data Warehouse- everything you need to knowSQL Data Warehouse is being used to hold all of our summary level reporting. The data is loaded using SSIS and transformed into a star schema. SQL does a great job mapping all of the OLAP values and providing efficient structures to house all of the reporting data. We then use a reporting tool to build cubes and publish the data,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,More features would be a plus I would like to see Microsoft offer some diagramming tools for data warehouse I believe processing time and speed could always be improved,9,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,Oracle Data Warehouse,Solarwinds Database Performance Analyzer for SQL Server, Team Foundation Server, SQL Server Business Intelligence ManagerBetter than querying off your OLTPWe use it to store large amounts of SQL data for our predictive analytics and big data modeling. We use it across several team but I cannot say it is used for the entire organization as my department operates relatively independently of the rest of the organization. We have an extremely large data sets and need to store it in a way that makes it accessible and fast.,Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes. Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.,It takes some time to setup a proper SQL Datawarehouse architecture. Without proper SSIS/automation scripts, this can be a very daunting task. It takes a lot of foresight when designing a Data Warehouse. If not properly designed, it can be very troublesome to use and/or modify later on. It takes a lot of effort to maintain. Businesses are continually changing. With that, a full time staff member or more will be required to maintain the SQL Data Warehouse.,9,It definitely has a positive impact on ROI. We are able to use it to generate MORE revenue through predictive analytics and pricing optimization. Because of the SQL Data Warehouse design, we're able to set up some self service reporting tools which allow our users to generate reports ad hoc instead of having a full time employee creating these by hand. Having visibility into the data is very useful for management to make good business decisions.,MongoDB, Amazon Elastic MapReduce and Microsoft Azure HDInsight,Microsoft SQL Server, dbForge SQL Complete, SQL Server Business Intelligence Manager, SQL Server Integration Services
Unspecified
SQL Data Warehouse
13 Ratings
Score 8.2 out of 101
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>TRScore

SQL Data Warehouse Reviews

SQL Data Warehouse
13 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.2 out of 101
Show Filters 
Hide Filters 
Filter 13 vetted SQL Data Warehouse reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-2 of 2)
  Vendors can't alter or remove reviews. Here's why.
Samir Patel, PMP profile photo
July 22, 2016

Review: "SQL Data Warehouse- everything you need to know"

Score 9 out of 10
Vetted Review
Verified User
Review Source
SQL Data Warehouse is being used to hold all of our summary level reporting. The data is loaded using SSIS and transformed into a star schema. SQL does a great job mapping all of the OLAP values and providing efficient structures to house all of the reporting data. We then use a reporting tool to build cubes and publish the data
  • 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
  • More features would be a plus
  • I would like to see Microsoft offer some diagramming tools for data warehouse
  • I believe processing time and speed could always be improved

SQL Data Warehouse is always well suited in a Microsoft SQL environment. When you are using tools like SSIS, SSAS and SSRS, SQL Data Warehouse fits in nicely as the OLAP backend.

Some challenges faced for this product are in very large expansive environments where the transact databases might be coming from different sources like Oracle or Sybase.

Read Samir Patel, PMP's full review
No photo available
July 15, 2016

SQL Data Warehouse Review: "Better than querying off your OLTP"

Score 9 out of 10
Vetted Review
Verified User
Review Source
We use it to store large amounts of SQL data for our predictive analytics and big data modeling. We use it across several team but I cannot say it is used for the entire organization as my department operates relatively independently of the rest of the organization. We have an extremely large data sets and need to store it in a way that makes it accessible and fast.
  • Quick to return data. Queries in a SQL data warehouse architecture tend to return data much more quickly than a OLTP setup. Especially with columnar indexes.
  • Ability to manage extremely large SQL tables. Our databases contain billions of records. This would be unwieldy without a proper SQL datawarehouse
  • Backup and replication. Because we're already using SQL, moving the data to a datawarehouse makes it easier to manage as our users are already familiar with SQL.
  • It takes some time to setup a proper SQL Datawarehouse architecture. Without proper SSIS/automation scripts, this can be a very daunting task.
  • It takes a lot of foresight when designing a Data Warehouse. If not properly designed, it can be very troublesome to use and/or modify later on.
  • It takes a lot of effort to maintain. Businesses are continually changing. With that, a full time staff member or more will be required to maintain the 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.
Read this authenticated review

SQL Data Warehouse Scorecard Summary

About SQL Data Warehouse

SQL Data Warehouse from Microsoft is a data warehouse-as-a-service for enterprises.
Categories:  Data Warehouse

SQL Data Warehouse Technical Details

Operating Systems: Unspecified
Mobile Application:No