SQL Data Warehouse
- Truly elastic with decoupled compute and storage
- Provision in minutes, scale in seconds
- Built for intelligence
- Enterprise ready with 99.9% SLA
- Global availability with 23 regions worldwide
- Only pay for what you use
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.”
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.
“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.”
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.”
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.”
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.”
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.”
SQL Data Warehouse Blog
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…
Feb 16 2017
Microsoft ES shares 8 tips to using SQL Data Warehouse effectively
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…
Not sure how to begin?
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