Azure SQL Data Warehouse
Fast, flexible, and secure analytics platform for the enterprise
SQL Data Warehouse and Non-Clustered Indexes
One performance optimization that is often over looked in SQL Data Warehouse (SQL DW) is the use of...
Author: Ellis Hiroki [MSFT] Date: 04/04/2018
How many queries and slots are running in my Azure SQL Data Warehouse?
Azure SQL Data Warehouse allows you to manage your workload using resource classes and concurrency...
Author: Matt Usher (MSFT) Date: 03/08/2018
Checking for queued queries in Azure SQL Data Warehouse
Azure SQL Data Warehouse manages query workload through a combination of concurrent query execution...
Author: Matt Usher (MSFT) Date: 03/07/2018
Getting the full explain plan for long queries
I was recently debugging a large stored procedure (2000+ lines of code) for a customer. I wanted to...
Author: Matt Usher (MSFT) Date: 02/12/2018
Creating a SQL Data Warehouse user with a specific resource class
In your data warehouse, you probably have multiple user groupings that perform different tasks: data...
Author: Matt Usher (MSFT) Date: 09/22/2017
Adding AD Users and Security Groups to Azure SQL Data Warehouse
Azure offers you the ability to federate your corporate Active Directory to the cloud through Azure...
Author: Matt Usher (MSFT) Date: 07/28/2017
Enabling TDE for Azure SQL Data Warehouse
Security is top of mind for everyone these days - securing your identity, securing your data. When...
Author: musher Date: 07/27/2016
Loading Data to SQL Data Warehouse with the .NET SqlBulkCopy class
The Azure SQL Data Warehouse service is built on SQL Server and extends the capabilities of SQL...
Author: Matt Usher (MSFT) Date: 07/26/2016
The effects of column level compression
The Azure SQL Data Warehouse service is built on SQL Server and extends the capabilities of SQL...
Author: Matt Usher (MSFT) Date: 05/05/2016
Exporting to a single file in SQL Data Warehouse
Azure SQL Data Warehouse includes PolyBase - a technology that accesses and combines both...
Author: Matt Usher (MSFT) Date: 05/05/2016
Scaling and scale monitoring SQL Data Warehouse via T-SQL
One of the key value propositions for the Azure SQL Data Warehouse service is the ability to re-size...
Author: musher Date: 04/13/2016
Connecting a Linked Server to Azure SQL Data Warehouse
With such a diversity of components to a data workloads, it is common for customers to use SQL...
Author: musher Date: 04/12/2016
How to determine the DWU setting for a SQL Data Warehouse
Azure SQL Data Warehouse service allows you to dynamically size the amount of compute resources...
Author: musher Date: 03/18/2016
Introducing Azure SQL Data Warehouse
On June 24, 2015, Microsoft launched the Azure SQL Data Warehouseservice - a new enterprise-class...
Author: musher Date: 08/13/2015