Azure SQL Data Warehouse is a fast, flexible and secure platform for analytics. Starting today, Azure SQL Data Warehouse (SQL DW) customers can build near real-time analytics solutions with tighter integration with Azure Databricks. We have enabled improved integration that allows you to ingest live streaming data from Azure Databricks to SQL DW to easily build BI dashboards.
Today, we announce the broader regional availability of the industry-leading performance provided by Azure SQL Data Warehouse (Azure SQL DW). Azure SQL DW is a fast, flexible, and secure analytics platform offering you a SQL-based view across data. It is elastic, enabling you to provision a cloud data warehouse and scale to terabytes in minutes.
Compute Optimized Gen2 tier is now rolled out to three additional Azure regions— Australia Central, Australia Center 2, and France Central. These new locations bring the product worldwide availability count for Compute Optimized Gen2 tier to 22 regions.
We are excited to announce that SQL Data Warehouse (SQL DW) serves you intelligent performance insights within the Azure portal! SQL DW is a flexible, secure, and fully managed analytics platform for the enterprise optimized for running complex queries fast across petabytes of data.
We are thrilled to announce that SQL Data Warehouse (SQL DW) has released accelerated and flexible restore points for fast data recovery. SQL DW is a fully managed and secure analytics platform for the enterprise, optimized for running complex queries fast across petabytes of data.
A few months, ago we blogged on creating a customizable management experience with SQL Operations Studio (Ops Studio). Now we're announcing the preview release of the Azure SQL Data Warehouse extension.
Azure SQL Data Warehouse now supports column-level security (CLS), an additional capability for managing sensitive data in the cloud.
You can use CLS to manage user access to specific columns in your tables in a simpler manner, without having to redesign your data warehouse. CLS eliminates the need to maintain access restriction logic away from the data in another application or introduce views for filtering out sensitive columns for a subset of users.
Azure SQL Data Warehouse now supports User-Defined Restore Points.
This feature enables you to trigger snapshots through PowerShell to create restore points of your data warehouse before and after large modifications. This capability ensures that restore points are logically consistent, which provides additional data protection in case of any workload interruptions or user errors for quick recovery time.
Statistics provide necessary information for Azure SQL Data Warehouse to build optimal query plans. Historically, this has required analysis of queries and manual creation of statistics.
Azure SQL Data Warehouse now supports the automatic creation of column-level statistics. This feature enables the cost-based optimizer to build query plans that run faster and make efficient use of resources.