SQL Data Warehouse

Learn about Azure SQL Data Warehouse

Azure SQL Data Warehouse is a SQL-based fully managed, petabyte-scale cloud data warehouse. It is highly elastic, enabling you to provision in minutes and scale capacity in seconds. You can scale compute and storage independently, allowing you to burst compute for complex analytical workloads or scale down your warehouse for archival scenarios, and pay based on what you’re using instead of being locked in to predefined cluster configurations – helping you to derive even more cost efficiency versus traditional data warehouse solutions

Provision fast and scale even faster

Enjoy true cloud elasticity, provision a data warehouse in under five minutes and scale compute in a few seconds, eliminating the need for over-provisioning. Simply scale up whenever you need to, and then scale down to keep costs under control.

“We are using Azure SQL Data Warehouse’s elasticity and scaling capabilities to scale up our systems when we need to do analytics on all of the data we are collecting from thousands of devices, and then scale down, thus optimising on cost without compromising performance.”

Roger Shih, Senior Technical Product Manager, Toshiba America Business Solutions

Only pay for what you use

Pay for what you use instead of being locked in to the predefined cluster configurations of traditional data warehouse solutions. Because compute and storage are separated, you can bring in all your data – with no trade-offs on which data to ingest – and run compute-only on the datasets that matter. Plus, SQL Data Warehouse offers the unique option to pause compute, giving you even more freedom to better manage your cloud costs.

Integral Analytics
“We switched from AWS Redshift to Azure SQL Data Warehouse, migrating over 7 TB of uncompressed data over a week for the simple reasons of saving money and enabling a more straight-forward implementation for advanced analytics.”

Bill Sabo, Managing Director of Information Technology, Integral Analytics

Trust automatic threat detection

Manage, detect and mitigate security threats with automatic threat detection and Azure authentication features. Built-in auditing and threat detection use machine learning to understand the patterns of your workload and serve as an alarm system to alert you of a potential breach.

“Threat Detection is an incredible feature, super simple to use, empowering our small engineering team to protect our company data without the need to be security experts. Knowing that Microsoft is using its vast security expertise to protect my data gives me incredible peace of mind.”

Manrique Logan, Architect and Technical Lead, ASEBA

Plan mission critical

Plan for reliability with a market leading SLA, guaranteeing 99.9% uptime in GA regions. With broad compliance certifications and a data centre network that has the most coverage worldwide, lead your growth strategy with Microsoft as a partner.

“Our vision is to expand Adcorp …. throughout Africa, the Middle East and the Asia Pacific region, Azure is well positioned to support our aggressive growth strategy and we have confidence in the partnership that has been established with Microsoft.”

Peter Wilmot, General Manager of IT Infrastructure at Adcorp.

Gain insights from big data and advanced analytics

Built into SQL Data Warehouse, PolyBase simplifies and enables distributed analytics, allowing you to run a single T-SQL query over multiple data sources, including Azure Data Lake Store. PolyBase also offers rapid data ingestion from within the same query tooling experience. Plus, compatibility with other services such as Azure Machine Learning and products from Looker Data Sciences allow you to run analytics across your data and transform your business.

“With Azure SQL Data Warehouse, we use PolyBase to ingest data from HDInsight, then run thousands of analytical queries per day over tens of billions of records – about 20 TB of data. This enables us to monitor price history and market dynamics to adjust pricing and to ensure we’re offering our customers the best price.”

Christoph Leinemann, Senior Director Data Engineering, Jet.com

Build on the familiar SQL Server platform

Use the familiar SQL language and develop with ease in a rich programming environment. Powered by the new innovations of SQL Server 2016, SQL Data Warehouse enables capabilities such as the industry-leading SQL Server 2016 columnstore for faster analytics queries.

“It’s not Hive, it’s not uSQL, it’s not another language that you have to pick up, SQL is a language that all DBAs know like the back of their hand.”

Christopher Beach, Senior Vice President of Engineering, MediaBrix

SQL Data Warehouse Blog

 Pinned post

SQL Data Warehouse now supports seamless integration with Azure Data Lake Store

Jun 03 2017

Azure SQL Data Warehouse is a SQL-based fully managed, petabyte-scale cloud solution for data warehousing. SQL Data Warehouse is highly elastic, enabling you to provision in minutes and scale…

Microsoft Enterprise Services Tips to using SQL Data Warehouse effectively

Feb 16 2017

Microsoft ES shares 8 tips to using SQL Data Warehouse effectively

SQL Server 2016 innovations power Azure SQL Data Warehouse to deliver faster insights

Jan 31 2017

Azure SQL Data Warehouse (SQL DW) is a SQL-based petabyte-scale, massively parallel, cloud solution for data warehousing. It is fully managed and highly elastic, enabling you to provision and…

Getting started

Not sure how to begin?

Review a step-by-step guide to get started with SQL Data Warehouse, then learn common SQL Data Warehouse best practices.

Developer? Right this way.

Drive insights through a single SQL-based view across all data sources. Use Transact-SQL queries across relational and non-relational data. Dig deeper into authentication and connections, Dynamic SQL, stored procedures, user-defined schemas and views

Data Platform Studio

Get started with automatic data migration from SQL Server

Import data to SQL Data Warehouse

Related products and services

Power BI

Embed fully interactive, stunning data visualisations in your applications

Azure Analysis Services

Proven analytical engine in the cloud

Machine Learning

A powerful cloud-based predictive analytics tool to enable predictive maintenance

Try SQL Data Warehouse with a free Azure account