How To: Move your Azure Data Warehouse to a new region and/or subscription

This post applies to Azure SQL Data Warehouse The functionality currently does not exist to move your Azure SQL Data Warehouse instance to a subscription other than the one it was created under.  What you can do is move the server that contains the instance to another subscription or resource group.  Moving a server will…


Performance: Investigate Inconsistent Query Execution Times

This post applies to both APS and Azure SQL DW   There is a reasonable expectation that if a query is executed in a controlled environment multiple times it will have minimal variance in total execution time when no changes are made to the system, data or query.  When a variance is experienced it should…


APS Monitoring solutions

APS features an out of the box monitoring portal which allows users to review APS components health state as well as monitor resources consumption and workload executions. We’re talking about the Admin Console. You can check out more on how to Monitor the appliance using Admin Console from the official documentation page. Amongst the monitoring…