2802, 2019

Query Store for Azure SQL Data Warehouse is generally available now

By |February 28th, 2019|IT Management, Microsoft Azure|0 Comments

 

Since the recent preview, Query Store raised great interest among users as an effective solution to provide insight on query performance. Microsoft announced the general availability of Query Store for Azure SQL Data Warehouse worldwide.

When monitoring a data warehouse, Query Store captures query history, separates the data by time slots and provides an overview of the database usage patterns.
Advantages of using […]

2811, 2018

Azure SQL Data Warehouse improves the data querying performance

By |November 28th, 2018|Azure How To, IT Management, Microsoft Azure|0 Comments

 

Azure SQL Data Warehouse showed to be a fast and flexible analytics platform. Enhancements in the distributed query execution layer as per the recent experience result in the significant query performance improvements for Azure SQL Data Warehouse (SQL DW).

I/O bandwidth to storage and repartitioning speed (shuffle speed) determine the analytics workload performance. In this article, we are […]