SQL Data Warehouse
- Truly elastic with decoupled compute and storage
- Set up 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 an SQL-based, fully managed, petabyte-scale cloud data warehouse. It’s highly elastic, and it enables you to set up in minutes and scale capacity in seconds. Scale compute and storage independently, which allows you to burst compute for complex analytical workloads or scale down your warehouse for archival scenarios; pay based on what you’re using instead of being locked into predefined cluster configurations; and get more cost-efficiency compared to traditional data warehouse solutions.
Provision fast and scale even faster
Get true cloud elasticity, provision a data warehouse in under five minutes and scale compute in a few seconds, meaning you don’t have to over-provision. Simply scale up when you need to, 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, then scale down, thus optimising on costs without compromising performance.”
Only pay for what you use
Pay for what you use instead of being locked into the predefined cluster configurations of traditional data warehouse solutions. Because compute and storage are separated, you can bring in all of your data, with no trade-offs in terms of which data to ingest, and run compute only on the data sets that matter. Also, SQL Data Warehouse gives you the unique option to pause compute, which means 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 straightforward 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 and is 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 for reliability with a market-leading SLA that gives you 99.9% uptime in regions available to the public. Broad compliance certifications and a data centre network that has the most coverage worldwide allow you to 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.”
Get insights from big data and advanced analytics
Built into SQL Data Warehouse, PolyBase simplifies and enables distributed analytics and allows you to run a single Transact-SQL query over multiple data sources, including Azure Data Lake Store. PolyBase also gives you 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 allows you to run analytics across your data and transform your business.
“With Azure SQL Data Warehouse, we use PolyBase to ingest data from Azure 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 ensure that 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 innovations of SQL Server 2016, SQL Data Warehouse gives you 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
03 Jun 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…
16 Feb 2017
Microsoft ES shares 8 tips to using SQL Data Warehouse effectively
31 Jan 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 of your 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.