Azure SQL Database vs SQL Data Warehouse

I am sometimes asked to compare Azure SQL Database (SQL DB) to Azure SQL Data Warehouse (SQL DW).  The most important thing to remember is SQL DB is for OLTP (i.e. applications with individual updates, inserts, and deletes) and SQL DW is not as it’s strictly for OLAP (i.e. data warehouses).  So if your going to build a OLTP solution, you would choose SQL DB.  However, both products can be used for building a data warehouse (OLAP).  With that in mind, here is a list of the differences:

screen-shot-2016-11-21-at-7-58-20-am-768x537

I have other blogs that cover SQL DB and SQL DW.

More info:

Comparing Azure SQL Database to SQL Data Warehouse

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in Azure SQL Database, Azure SQL DW, SQLServerPedia Syndication. Bookmark the permalink.

4 Responses to Azure SQL Database vs SQL Data Warehouse

  1. Rolf Tesmer says:

    Thanks James, nice summary!
    An additional one to add if I can – for those application developers out there, ASDB supports Entity Framework (EF) whereas ASDW does not.
    Sorry about this shameless plug — but if EF on ASDW is important then please vote it up here! 🙂
    https://feedback.azure.com/forums/307516-sql-data-warehouse/suggestions/12868725-support-for-entity-framework

  2. Pingback: Making sense of Microsoft technology – Cloud Data Architect

  3. Pingback: Making sense of Microsoft technology | James Serra's Blog

  4. Pingback: Comparing Azure SQL Database to SQL Data Warehouse – Key2 Consulting