SQL Server Data Tools preview for Azure SQL Data Warehouse is now downloadable with the latest preview release of Visual Studio 2019. SQL Server Data Tools enables a stable change management and deployment experience when developing your data analytics solution using SQL Data Warehouse.
Today, we are announcing Reserved Capacity for SQL Data Warehouse in an additional 18 regions. On April 9th, we announced the availability of Reserved Capacity pricing in Azure SQL Data Warehouse. Reserved Capacity enables customer to receive a discount over pay-as-you-go pricing when they make a pre-payment for SQL Data Warehouse capacity. These pre-payments allow customers to choose between a 1-year or 3-year option that provides up to 37% or 65% savings, respectively.
Today, we’re extending that support for auto statistics creation by adding the ability to automatically refresh and maintain statistics. As data warehouse tables get loaded and updated, the system can now automatically detect and update out-of-date statistics. With the auto-update statistics capability now available in preview, Azure SQL Data Warehouse delivers full statistics management capabilities while simplifying statistics maintenance processes.
We are also excited to announce today support for semi-structured data in Azure SQL Data Warehouse, available in preview. Now with one service, both structured and semi-structured data formats (like JSON) can now be analyzed directly from the data warehouse for faster insights.
We’re excited to share more ways to optimize your Azure costs. Today we are releasing the general availability of Azure SQL Data Warehouse reserved capacity and software plans for RedHat Enterprise Linux and SUSE.
Starting today, you can now use the Azure SQL Data Warehouse Reserved Capacity pricing to reserve compute power for existing and future clusters. This option provides you savings up to 65% cDWU capacity. Those that choose a 3-year Reserved Capacity with SQL Data Warehouse can save up to 65% on compute costs. With SQL Data Warehouse Reserved Capacity, you can reserve units starting at DW100C and add on to reserved units in increments of 100, up to DW30000c. Customers can also scale reserved units.
Data Discovery & Classification is now available in public preview for Azure SQL Data Warehouse. While it’s critical to protect the privacy of your customers and other sensitive data, it becomes unmanageable to discover, classify, and protect such sensitive data as your businesses and data assets are growing rapidly. The data discovery and classification feature that we’re introducing natively with Azure SQL Data Warehouse helps alleviate this pain-point.
Azure SQL Data Warehouse users can now classify requests with workload importance. Requests classified with higher importance get access to resources first and can finish sooner.
Classification and importance are available for preview in all regions of Azure SQL Data Warehouse with no additional charges. To get started, you can read the Classification and Importance overview documents. Check out the new CREATE WORKLOAD CLASSIFIER syntax as well.
We’re excited to share the general availability of Query Store worldwide for Azure SQL Data Warehouse.
Query Store automatically captures a history of queries, plans, and runtime statistics and retains them for your review when monitoring your data warehouse. Query Store separates data by time windows so you can see database usage patterns and understand when plan changes happen.