Migrating your On Premise database to Azure Synapse Dedicated SQL Pools

Migrating your On Premise database to Dedicated SQL Pools

Have you ever tried to migrate your On Premise DataWareHouse solution to an Azure Synapse Analytics SQL Pool? Dedicated SQL Pool in Azure Synapse is a MPP system and requires some 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 your On Prem system to Dedicated SQL Pools? 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.

Speaker

Erwin de Kreuk is a passionate Data Platform / Sql Server enthusiast. Working as a Lead Data and AI for InSpark, #1 Microsoft Partner of the Year in the Netherlands. Speaking on different National and International Events.

Erwin de Kreuk's Sessions

Building a Fortress of Your Fabric Environment: Best Practices for Data Engineers

Managing access to data sources in your data estate with Microsoft Purview

Azure Key Vault, Azure DevOps and Synapse Pipelines, how do these Services work perfectly together

Data Governance with Azure Purview

Established a metadata-driven approach with Azure Synapse Data Pipelines?

Migrating your On Premise database to Azure Synapse Dedicated SQL Pools

Azure Key Vault, Azure DevOps and Synapse Pipelines, how do these Services work perfectly together

Easily Scale your Dedicated SQL Pool dynamically in Azure Synapse

Data Governance with Azure Purview - Ask the Experts

Lake Database with Database Template and Mapping Data with Azure Synapse Analytics

Azure Key Vault, Azure Dev Ops and Data Factory