NOVA SQL Meetup - July 2019 - Azure Data Engineering and SQL Server Migration

Please join us for our July 15th, 2019 meeting. We will hear from Ajay Gollapalli - Cloud Solution Architect, Microsoft on the topic of SQL Server migration and Azure Data Services choices and then we will hear from Cameron Snapp and his presentation on Azure Data Engineering.

Date: Monday, July 15, 2019, 9:00AM to 12:00PM

Location: Microsoft Offices, 3rd Floor, Room 3054, 12012 Sunset Hills Rd. Reston, VA (take elevator up to 3rd floor)

Networking, food, chapter announcements: 8:30AM - 9:00AM

Session #1, Ajay Gollapalli, SQL Server Migration: 9:00AM to 9:55AM

Title: SQL Server Migration

Abstract: As you might know, SQL Server 2008/2008R2 are approaching the end of extended support in July 2019. Ajay will cover the upgrade / migration options for you to consider.

BIO - Ajay Gollapalli - Cloud Solution Architect, Microsoft - https://www.linkedin.com/in/ajaygollapalli/

Session #2, Cameron Snapp, Azure Data Engineering, 10:00AM-12:00PM

Title: Azure Data Engineering

Abstract: As Microsoft releases new Azure features, migrating your ETL processes to the cloud is becoming easier all the time, but also more confusing. Understanding the use and connectivity of the different storage and services is more critical than ever. I'll start with an overview of Azure data components, detail how they can be integrated, and demo the lift and shift of existing SSIS packages to Azure. I'll also demo some dynamic ways to program Data Factory and the features of the brand new Data Factory Data Flow! Throughout, we'll discuss best practices for different Azure centric data migration strategies and explore the benefits of adopting an ELT approach.

Bio: Cameron Snapp is a MCSE and PMP certified IT Consultant with over 15 years of database architecture and development experience. He has worked on dozens of Microsoft SQL Server OLTP, Data Warehouse, and Business Intelligence projects. He holds a Computer Science degree from the University of Richmond and a Master’s degree in IT Management from the University of Virginia. Cameron specializes in IT Projects related to data strategy, modeling, integration and reporting.