Arizona SQL Server Users Group

Next Meeting: Wed, Jan 09 2019

Azure Data Factory Version 2

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Arizona-SQL-Server-User-Group/events/kvzxdmyzcbmb/

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[masked], 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

When

iCal
UTC : Thu, Jan 10 2019 00:30 - 02:30
Event Time : Wed, Jan 09 2019 17:30 - 19:30 (UTC-07:00) Arizona
Your Local Time: Thu, Jan 10 2019 00:30 - 02:30

Where

1720 West Rio Salado Pkwy
Tempe, Arizona

Direction: None

Featured Presentation

Azure Data Factory Version 2

Speaker: Joseph Barth, Senior Consultant II Neudesic

Summary: 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.

About Joseph: An eight year Microsoft SQL Server Specialist in SQL Server 2005-2016, Azure SQL DB, he has held many development positions, including SQL query tuner, SSIS and SSRS . Joseph's early focus as an SQL tuning professional, fixing long running queries by techniques; join order,use of temporary object, also implementing Index optimization, maintenance and design to fix slowness. Joseph has focused on ETL solutions using SSIS for the last 4 years, data warehousing and cloud architecture using Azure. Currently working on a Modern Data Warehouse project involving Azure Data Lake and Azure SQL DW using external tables. MCSE Data Management and Analytics 2016 MCSA: SQL Server 2012 Co-found CASSUG Albany NY 2 yrs AZSSUG Chapter Leader 3 yrs

Attachments

Meeting Archive

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids