DB-EnginesCrateDB bannerEnglish
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Microsoft Azure SQL Data Warehouse

Microsoft Azure SQL Data Warehouse System Properties

Please select another system to compare it with Microsoft Azure SQL Data Warehouse.

Our visitors often compare Microsoft Azure SQL Data Warehouse with Amazon Redshift, Snowflake and Google BigQuery.

Editorial information provided by DB-Engines
NameMicrosoft Azure SQL Data Warehouse
DescriptionElastic, large scale data warehouse service leveraging the broad eco-system of SQL Server
Primary database modelRelational DBMS
Secondary database modelsKey-value store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Rank#46  Overall
#26  Relational DBMS
Technical documentationdocs.microsoft.com/­azure/­sql-data-warehouse
License infoCommercial or Open Sourcecommercial
Cloud-based infoOnly available as a cloud serviceyes
Implementation languageC++
Server operating systemshosted
Data schemeyes
Typing infopredefined data types such as float or dateyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.no
Secondary indexesyes
SQL infoSupport of SQLyes
APIs and other access methodsADO.NET
Supported programming languagesC#
Server-side scripts infoStored proceduresTransact SQL
Partitioning methods infoMethods for storing different data on different nodesSharding, horizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsno
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integrityyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACID
Concurrency infoSupport for concurrent manipulation of datayes
Durability infoSupport for making data persistentyes
User concepts infoAccess controlyes
More information provided by the system vendor
Microsoft Azure SQL Data Warehouse
Specific characteristics

Azure SQL Data Warehouse is Microsoft’s SQL analytics platform, the backbone of your Enterprise Data Warehouse. The service is designed to allow customers to elastically (and independently) scale compute and storage with massively parallel processing. SQL DW integrates seamlessly with big data stores and acts as a hub to your data marts and cubes for an optimized and tailored performance of your EDW. Azure SQL DW offers guaranteed 99.9% high availability, compliance, advanced security, and tight integration to upstream and downstream services so you can build a data warehouse that fits your needs. Azure SQL DW is the first and only service enabling enterprises to replicate their data everywhere with a global availability in more than 30 regions.

Competitive advantages

Unlimited scale

Make your data go further. SQL Data Warehouse gives you a highly composable data warehouse solution to remove limits to scale and performance.

Elastic and extensible

Optimize your data warehouse performance and lower your costs by scaling compute and storage independently. 

Trusted and reliable

Count on enhanced security features and industry-leading compliance. SQL Data Warehouse is General Data Protection Regulation (GDPR)-compliant.

Seamless integration

By leveraging SQL Server, SQL Data Warehouse is compatible across Microsoft and third-party services.

Typical application scenarios

Data warehouse modernization: SLQ DW can be the hub of your data analytics and integrate easily with SQL Database and Azure Analysis to provide resource isolation and an unlimited amount of BI analysts.

Data analytics applications: build innovate applications that need resource isolation between your data consumers. With SQL Database Elastic Pools, you have a broad choice of price/performance that can fit your end-user

Key customers

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

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Microsoft Azure SQL Data Warehouse
DB-Engines blog posts

Azure SQL Data Warehouse, the hub for a trusted and performance optimized cloud data warehouse
1 November 2017,  Arnaud Comet, Microsoft (sponsor) 

show all

Recent citations in the news

Microsoft Doubles Performance of Azure SQL Data Warehouse
20 July 2018, eWeek

Microsoft Azure SQL Data Warehouse Gets a Speed Boost
16 July 2018, eWeek

The Customer Experience Technology Stack | Data Visualisation
14 August 2018, Business 2 Community

Google Next 2018: A deeper dive on AI and machine learning ...
2 August 2018, ZDNet

BigQuery vs. Redshift debate centers around cost, management
31 July 2018, TechTarget

provided by Google News

Job opportunities

Data Analytics Solution Architect/Practice Lead
Digital Management, LLC, Indianapolis, IN

Information Data Architect
LaCrosse Footwear, Portland, OR

Manager Big Data Architect
KPMG, Knoxville, TN

Cloud Data Architect - Azure
CapTech Consulting, Atlanta, GA

ETL Developer
Ethos Group Corporate, Irving, TX

jobs by Indeed

Share this page

Featured Products

Redis logo

Start now with Redis Cloud
Secure, highly available Redis as a serverless, hosted, fully managed cloud service.
Sign up here.

Couchbase logo

Power, flexibility & scale.
All open source.
Get started now.

Neo4j logo

New to the world of graph databases? Become an expert today with your copy of the Graph Databases for Beginners ebook.

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Present your product here