SET IMPLICIT_TRANSACTIONS Behavior On Azure SQL Data Warehouse and APS

Working with transactions in Azure SQL Data Warehouse (ADW) and the Analytics Platform System (APS, aka PDW) is a bit different than one would expect. Though most of us tend to operate under the default behavior with IMPLICIT_TRANSACTIONS OFF, developers that interact with ADW/APS using other languages may find transaction handling using their language constructs…


Azure Resource Manager (ARM) and Azure SQL Data Warehouse

Having worked with many customers doing ARM deployments, I’ve found it is not always clear how to create a good template when deploying an Azure SQL Data Warehouse. Here is an example implementation created for testing: { “$schema”: “https://schema.management.azure.com/schemas/2015-01-01/deploymentTemplate.json#”, “contentVersion”: “1.0.0.0”, “parameters”: { “serverName”: { “type”: “string”, “minLength”: 1 }, “serverAdminLogin”: { “type”: “string”, “minLength”:…