Azure SQL DW: Moving to a different region with restore from backup option

Reviewers: Dimitri Furman, John Hoang, Mike Weiner, Denzil Ribeiro, Joe Yong Background: Azure SQL Data Warehouse service (SQL DW) uses a snapshot backup to back up your data at a regular (8 hour) interval. DBAs can use this backup to restore a SQL DW database into a new database in the same region, or to… Read more

Migrating data to Azure SQL Data Warehouse in practice

Authors:¬†Rangarajan Srirangam, Mandar Inamdar Contributors and Reviewers:¬†John Hoang, Sanjay Mishra, Alexei Khalyako, Sourabh Agarwal, Osamu Hirayama, Shiyang Qiu Overview: Migrate data to Azure SQL Data Warehouse Azure SQL Data Warehouse is an enterprise-class, distributed database, capable of processing massive volumes of relational and non-relational data. It can deploy, grow, shrink, and pause in seconds. As… Read more

PolyBase Setup Errors and Possible Solutions

Blog Authors: Murshed Zaman and Sumin Mohanan Reviewer(s): Barbara Kess Prologue PolyBase is a new feature in SQL Server 2016. It was popularized by APS (Microsoft Analytics Platform System) and Azure SQL DW. PolyBase allows access to relational and non-relational data from SQL Server using familiar T-SQL language. It allows you to run queries on… Read more

Assigning surrogate key to dimension tables in SQL DW and APS

Reviewed by: James Rowland-Jones, John Hoang, Denzil Ribeiro, Sankar Subramanian This article explains how to assign monotonically increasing surrogate/synthetic keys to dimension tables in SQL DW (or APS) using T-SQL. We are going to highlight two possible methods of doing this: Assign Surrogate keys to the dimension tables where the dimensions are generated in a… Read more

Choosing hash distributed table vs. round-robin distributed table in Azure SQL DW Service

This topic explains the various Azure SQL Data Warehouse distributed table types, and offers guidance for choosing the type of distributed table to use and when. There are two types of distributed tables in Azure SQL DW at the writing of this article, hash distributed table and round-robin distributed table. Designing databases to use these… Read more