Erwin de Kreuk

Erwin de Kreuk is a passionate SQL Server enthusiast. He is working as an Analytics Architect at Axians. Eager in helping out customers in getting the most added value out of their Analytics Environment. 
Next to that, he is a practice leader for Microsoft BI (at Axians). Always investigating the latest (vs newest) possibilities/opportunities and sharing his enthusiasm among his colleagues. 


Migrating your On Premise database to Azure SQL Data Warehouse



Have you ever tried to migrate your On Premise DataWareHouse (DataVault) solution to a Azure SQL DataWareHouse? Azure SQL DW is a MPP system and requires a lot of changes to your current solution.
What are the best practices to Migrate your solution with as little impact to users as possible? Why should you migrate to a Azure SQL DW? I did, and would like to share my experience.

I will take you in this session through all the steps you have to take care off. The following points will be discussed Distribution keys, Replicated Tables, identity Colums, CTAS, scaling, pausing, monitoring and much more.