Share via


Data Warehouse Support

Posts coming from the team that supports the on premise (APS & PDW) and Azure Data Warehouse offerings

From time to time, we on the Azure SQL Data Warehouse (ADW) support team get cases where a customer...

Date: 08/10/2018

Microsoft announced user-defined restore point on Azure SQL Data Warehouse. This feature enables you...

Date: 06/29/2018

DML operations can be resource intensive and harmful to CCI indexes in Azure SQL Data Warehouse. The...

Date: 06/18/2018

In may the engineering team for Azure SQL Data Warehouse announced integration with SQL Operations...

Date: 06/07/2018

Appliance Update 7 (AU7) for Microsoft's Analytic Platform System (APS) brings with it a couple of...

Date: 05/30/2018

Working with transactions in Azure SQL Data Warehouse (ADW) and the Analytics Platform System (APS,...

Date: 02/20/2018

Having worked with many customers doing ARM deployments, I've found it is not always clear how to...

Date: 02/14/2018

This topic applies to both Azure SQL Data Warehouse and Analytic Platform System Data skew occurs...

Date: 01/19/2018

This post applies to Azure SQL Data Warehouse The functionality currently does not exist to move...

Date: 12/14/2017

This post applies to both APS and Azure SQL DW There is a reasonable expectation that if a query is...

Date: 06/22/2017

APS features an out of the box monitoring portal which allows users to review APS components health...

Date: 05/17/2017

Many users utilize Linked Server functionality in order to issue queries to PDW using SSMS.  This is...

Date: 07/06/2016

User temporary tables in PDW/APS are treated slightly different than temporary tables in SQL...

Date: 06/22/2016

One of the objectives when architecting a database on a PDW system is to do so with the goal of...

Date: 06/21/2016

It is my assumption that almost all companies with an APS will want to connect it to their Active...

Date: 03/29/2016

You may notice your daily ETL jobs or queries running slower than usual or in a queued state when a...

Date: 02/16/2016

There are several ways to load data in PDW: SSIS, DWLoader client, and with the latest release BCP...

Date: 01/20/2016

PDW introduces an additional level of execution plans. These are commonly referred to as 'explain...

Date: 01/12/2016

In this post we are going to discuss different types of DMV's in PDW and where the data comes from....

Date: 10/21/2015

A common scenario customers report is queries which ran quickly yesterday, are taking longer today....

Date: 09/30/2015

This is our second post covering the new features and improvements included in the SQL APS PDW AU4...

Date: 08/07/2015

The Microsoft engineering team has officially signed off on the latest APS update, Appliance Update...

Date: 08/04/2015