Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Date: 03/18/2016
Introducing Azure SQL Data Warehouse
On June 24, 2015, Microsoft launched the Azure SQL Data Warehouseservice - a new enterprise-class...
Date: 08/13/2015