Your go to SQL-based data warehouse and big data solution that enables advanced analytics and delivers more freedom to scale and control budget. Pay for the storage you use and the compute you need, when you need it.
Unlike other cloud services which can require hours to scale up, SQL Data Warehouse truly delivers the promise of cloud elasticity ideally suited for batch-based data warehouse workloads. You can easily provision a data warehouse in 3-5 minutes and scale your compute in seconds to keep up with demand.
SQL Data Warehouse delivers a decoupled storage and compute model which allows you to easily scale compute in seconds without the need to over-provision or over-pay. Additionally, only SQL Data Warehouse offers the ability to pause compute which gives you even more freedom over managing your cloud costs. This allows you to bring all your data with no tradeoffs on which data to ingest—run compute only on the datasets that matter.
Only SQL Data Warehouse delivers Auditing and Threat Detection built into the service which uses machine learning to understand the patterns of your workload and serves as an alarm system to alert you of a potential breach before it’s too late. Additionally, SQL Data Warehouse is the only cloud data warehouse service that works seamlessly with Azure Active Directory which currently supports 1.3 billion daily authentications across 600 million user accounts. This support enables Single Sign-On (SSO) which further protects data by ensuring the right users have access to the right data—this is critical when end users are running analytics against the data warehouse.
Only Microsoft offers PolyBase technology which simplifies and enables distributed analytics—you simply run a single T-SQL query via familiar tools over multiple data sources, including Hadoop clusters. Built-into SQL Data Warehouse, PolyBase also offers blazing-fast data ingestion from within the same query tooling experience.
Transform your business with real-time analytics for all of your data, structured and unstructured, with existing tools you already know and love—including industry-leading Power BI with 5 million users worldwide and Microsoft Excel. Microsoft also works with a set of popular BI partners to ensure the tools your teams use work great with SQL Data Warehouse so you don’t miss an insight including, Looker Data Sciences, Tableau Software, and Qlik Technologies. Plus, seamless compatibility with SQL Server Integration Services, Azure Stream Analytics, Azure Machine Learning, Azure Data Factory, and Azure Storage ensures insights over all of your data as fast as it’s coming in.
Learn how building a cloud-based data warehouse can drive incredible value while driving greater results.
We never stop improving SQL Data Warehouse. Read our blog to stay up-to-date on our latest enhancements.