Azure Data Factory Version 2

Title:

Azure Data Factory Version 2

Location:

DriveTime
1720 West Rio Salado Pkwy
Tempe, AZ 85281

Please enter the North-East side of the building into the auditorium area as the main entrance (center on the North side) will be closed.

Abstract:

Azure Data Factory version 2 is a game changer! First it can run SSIS in the cloud with a push of the button. Second, new user interface allows you to build your pipelines in seconds and version control your development. Third, monitoring just got easier - stop, cancel, restart your pipelines all in one area. Lastly, control flow gives you the ability to easily chain your dependencies, including using iteration and conditionals. We will walk through what is new and what is available with ADFv2. Understand the architecture of the Azure Data Factory linked services connecting from on-premise sources using self-hosted vs connecting to a VNET. Learn how to start up an Azure SSIS instance, and understand the VM scale sets deployed and the cost associated. Walk through examples in new Control, use of Iterations and Conditionals. Early adoption gives an outside look at architecture around connecting your data to the cloud and how important linked services, data sets and pipelines are.

Speaker:

Joe Barth

Speaker Bio:

An eight year Microsoft SQL Server Specialist in SQL Server 2005-2016, Azure SQL DB, Joseph has held many development positions, including SQL query tuner, SSIS and SSRS. He started career by focusing as an SQL tuning professional, fixing long running queries by techniques; join order, use of temporary object, and implementing Index optimization, maintenance and design to fix slowness. More recently, Joseph has focused on ETL solutions using SSIS for the last 4 years, data warehousing and cloud architecture using Azure. He is currently working more Azure focused projects including Modern Data Warehouse involving Azure Data Lake and Azure SQL DW using external tables.

Agenda:

• 5:30-6:00pm: Sign-in & network
• 6:00-6:15pm: Announcements & Intro
• 6:15-7:15pm: Presentation
• 7:15-7:30pm: Q&A, wrap-up, clean-up

Sponsor: AZSSUG