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.

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#44  Overall
#26  Relational DBMS
Technical documentationdocs.microsoft.com/­azure/­sql-data-warehouse
License infoCommercial or Open Sourcecommercial
Cloud-based only 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

Cloud data warehouser Snowflake has just trousered another $450m
11 October 2018, The Register

Modern Data Warehouse Design Pattern – Part II
20 September 2018, Database Journal

Google takes BigQuery to new geographies, brings geospatial capabilities into beta
10 October 2018, ZDNet

Microsoft Ignite postmortem: The underlying hybrid convergence
27 September 2018, ZDNet

Cloud Data Migration Service Launched For IBM i
3 October 2018, IT Jungle

provided by Google News

Job opportunities

Information Data Architect
LaCrosse Footwear, Portland, OR

Solution Architect - Data & Analytics
Neudesic LLC, Seattle, WA

Data Analytics Consultant
Digital Management, LLC, Indianapolis, IN

Data Modeler
Blue Chip Talent, Detroit, MI

Cloud Data Architect - Azure
CapTech Consulting, Atlanta, GA

jobs by Indeed

Share this page

Featured Products

RavenDB logo

Runs on Windows, Linux, Raspberry Pi. Easy to Operate, Fast Performance.
APIs for JS, .NET, Python.
Take a Free Download

Couchbase logo

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

Neo4j logo

Get your step-by-step guide comparing RDBMS to graph databases, including data models, query languages, and deployment strategies.

Redis logo

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

Present your product here