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.
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