Denver SQL User Group – August 2018

Please join us for the August meeting.

August 16, 2018
5:30 – 8:30

Microsoft Office
7595 Technology Way Suite 400 
Denver, CO 80237

Meeting Agenda
5:30 – 6:00 Food / Socializing
6:00 – 6:15 User Group Business
6:15 – 6:30 Open panel/Questions & Answers
6:30 – 7:00 Warmup presentation
7:00 – 8:30 Main presentation

30 minute presentation:
ETL for Beginners
We’ve heard of ETL or Extract, Load and Transfer for a long time now. But now we are talking about ELT, but why. This introductory presentation will walk you through the basics of understanding what ETL and ELT are, why we care and options you have for implementing a proper solution.

Bio:
Marc Beacom, Managing Partner at Datalere, leverages over two decades of experience to better the data landscape for clients, along with nearly a decade of building and managing productive teams. Marc has led architecture and developed data integration strategies for dozens of Colorado based companies and organizations. Marc maintains an active presence in the Colorado community by volunteering and serving on nonprofit boards, speaking and running user groups. 

Main Presentation:
Real-World Data Movement and Orchestration Patterns using Azure Data Factory
In this session, we will start with an overview of Azure Data Factory V2 concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution.
Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.

Bio:
Jason Horner is a Data Engineer at JJH Consulting LLC. I’m currently based out of Littleton, Colorado
I have been working with SQL Server since version 6.5 and hold several Microsoft certifications including: MCM, MCSE. My most recent focus has been architecting large scale BI solutions. Previously, I helped architect, design, and build several high volume OLTP systems in a wide range of business domains.
I’m a confident evangelist for Agile methodologies like XP and Scrum, with a firm belief in people over process, and in the values of continuous improvement and teamwork to the organization.
I’m constantly looking for meaningful and challenging work where I can grow professionally, while at the same time contribute to the organization’s bottom line

Questions? Send an email to board@denversql.org.
Connect with us online:
Website: Denversql.org
Twitter: @denversql
Meetup
LinkedIn