Get started with an automatic data migration from SQL Server
Provision a data warehouse in just 3 to 5 minutes, and scale your compute in seconds to keep up with demand. Unlike other cloud services that can require hours to scale up, SQL Data Warehouse truly delivers on the promise of cloud elasticity, making it ideal for batch-based data warehouse workloads.
Because SQL Data Warehouse has a decoupled storage and compute model, it allows you to easily scale compute in seconds without over-provisioning or over-paying. Plus, SQL Data Warehouse offers the unique option to pause compute, giving you even more freedom to better manage your cloud costs. Now bring all your data with no tradeoffs on which data to ingest—run compute only on the datasets that matter.
Only SQL Data Warehouse includes built-in auditing and threat detection, which use machine learning to understand the patterns of your workload and serve as an alarm system to alert you of a potential breach—before it’s too late. SQL Data Warehouse also works seamlessly with Azure Active Directory, the proven technology that currently supports 1.3 billion daily authentications across 600 million user accounts. This support enables single sign-on (SSO) to further protect data by ensuring the right users have access to the right data, which is critical when end users are running analytics against the data warehouse.
Built-into SQL Data Warehouse, Microsoft PolyBase technology simplifies and enables distributed analytics and allows you to run a single T-SQL query using familiar tools over multiple data sources, including Azure Storage blobs. 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 and Microsoft Excel. Plus, tools from popular BI partners including Looker Data Sciences, Tableau Software, and Qlik Technologies work great with SQL Data Warehouse. And seamless compatibility with SQL Server Integration Services, Azure Analysis Services, Azure Stream Analytics, Azure Machine Learning, Azure Data Factory, and Azure Storage ensures insight across all of your data, as fast as it’s coming in.
BI provider optimizes data processing with Azure SQL Data Warehouse
“What we’ve ended up with is the ability to not only look at our data in real time, but also know that it’s going into what is essentially a large data bucket in Azure SQL Data Warehouse. As a result, we can keep all of our first- and third-party data in the same place for additional processing.”
Senior Vice President of Engineering
This maverick moved from Amazon to Azure and boosted customer revenue-per-click by 38 percent.
“Given the success of the project and the effectiveness of Azure, we will look to migrate to a full cloud offering in a few years’ time. Our experience in setting up Azure to meet our disaster recovery requirements have given us a lot of confidence in the Microsoft solution for our business.”
Mike Reilly, P:Cubed, CIO
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.