Pragmatic Works Nerd News

Tips for Migrating Data Warehouse Workloads to Azure

Written by Pragmatic Works | Jan 23, 2020

Do you want to learn how to migrate your workloads to Azure? In a recent webinar, Practice Manager and BI Architect, Bob Rubocki, discusses the best tips and tricks for migrating data warehouse workloads to Azure.

Bob will use a sample scenario of a basic technical architecture to frame the discussion of migrating data warehouses to Azure. This example will be referred to throughout the webinar in discussions of considerations when migrating. With this scenario and discussions, you’ll learn about migrating an existing data warehouse (whether that platform is SQL, Teradata, Netezza, Oracle, etc.) to a SQL Server version in the cloud.

In this one-hour webinar, Bob will cover the following topics that relate to migrating a data warehouse to Azure:

  • Azure SQL Server Targets – Both Platform as a Service (PaaS) offerings and the selection factors when deciding which is best for your scenario, as well as Infrastructure as a Service (IaaS)
  • Database Objects
  • Data Migration – One-time full load vs incremental load
  • ETL – Tool selection, Azure Data Factory and ETL development
  • Reports
  • Switch Over to End State

So, if you’re looking to migrate your workloads to Azure, this webinar full of tips and information is for you! You can watch the complete webinar below. To view the presenter’s slides, click here.

If you have more questions or need help migrating to Azure, our expert team is here to help you with any Azure tool, service or migration, from the planning stage to implementation. Is your DBA team overworked and unable to tackle their high-volume of weekly and monthly tasks? Our DBA Managed Services can help eliminate backlog burden - so your team can focus on mission critical tasks. Click below to learn more.