DB-EnginesGraphDB bannerEnglish
Deutsch
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
Score6.22
Rank#48  Overall
#27  Relational DBMS
Websiteazure.microsoft.com/­services/­sql-data-warehouse
Technical documentationdocs.microsoft.com/­azure/­sql-data-warehouse
DeveloperMicrosoft
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
JDBC
ODBC
Supported programming languagesC#
Java
PHP
Server-side scripts infoStored proceduresTransact SQL
Triggersno
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...

3rd party products and services

We invite representatives of 3rd party vendors 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

Column-level security announced for Azure SQL Data Warehouse
20 June 2018, Neowin

Microsoft Weekly: Xbox rings, update strings, hardware things
24 June 2018, Neowin

Quest, Alteryx introduce new versions of core products
5 June 2018, ZDNet

The Cloud Isn't Just About Saving Money
1 June 2018, InformationWeek

Hortonworks Expands Relationships With Microsoft And Google, Supporting Multi-Cloud Opportunities For Partners
19 June 2018, CRN

provided by Google News

Job opportunities

Information Data Architect
LaCrosse Footwear, Portland, OR

Data Architect - Remote West coast
Insight Enterprises, Inc., Dallas, TX

Microsoft Data Analytics Developer
SWC Technology Partners, Oak Brook, IL

Data Solutions Architect - Maritz Motivation Solutions
Maritz Inc., Fenton, MO

Data Architect
Bloomin' Brands, Tampa, FL

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

Datastax logo

Datastax delivers Apache Cassandra as part of a database platform purpose built for IOT, Web and Mobile Apps. Download now.

Neo4j logo

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

Couchbase logo

SQL + JSON + NoSQL.
Power, flexibility & scale.
All open source.
Get started now.

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