The Curious Engineer

All blogs / Databases

Data Warehouse Support

learn.microsoft.com/en-us/archive/blogs/apsblog

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

DatabasesDistributed systems / cloudMicrosoft blogsMSDN archive

’15’16’17’18’19’20’21’22’23’24’25’26
Posts
22 from 4 Aug 2015 to 10 Aug 2018
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/apsblog/feed.xml

2018 8

  1. Login Problems with my Azure Active Directory Account to Azure SQL Data Warehouse
  2. How to create user-defined restore points on Azure SQL Data Warehouse
  3. Azure SQL DW Performance: CTAS/Partition Switching VS UPDATE/DELETE
  4. Azure SQL Data Warehouse SQL Operations Studio Extension Available
  5. APS AU7 Performance Enhancements
  6. SET IMPLICIT_TRANSACTIONS Behavior On Azure SQL Data Warehouse and APS
  7. Azure Resource Manager (ARM) and Azure SQL Data Warehouse
  8. Performance: Evaluate Data Skew

2017 3

  1. How To: Move your Azure Data Warehouse to a new region and/or subscription
  2. Performance: Investigate Inconsistent Query Execution Times
  3. APS Monitoring solutions

2016 7

  1. APS / PDW Best Practices: Linked Server: OpenQuery VS EXEC
  2. PDW Useful Queries: Check for existence of user temporary tables
  3. PDW Execution Plans: Why are you shuffling my data?!
  4. Creating an Active Directory Trust With APS
  5. Locking Behaviour with PDW Backups
  6. Loading performance – DWLoader, distribution keys and source files
  7. Deciphering APS / PDW Execution Plans

2015 4

  1. APS / PDW DMVs Explained
  2. APS/PDW Query Performance: Lock Status
  3. APS AU4 Feature Review: Introducing Round Robin Distribution
  4. APS AU4 Feature Review: 1.5x data return rate improvement