November 2018 PASSMN Meeting

This month we have two speakers lined up to present, so the agenda has been adjusted accordingly.

• What we'll do

Meeting Agenda:

3:30-3:50 : Registration, Networking, and Food
3:50-4:00 : Kickoff / Announcements
4:00-4:50 : Difficult Queries (Rick Bielawski)
4:50-5:00 : Break
5:00-5:50 : SSIS to ADF V2 (Joshuha Owen)
5:50-6:00 : Closing

Meeting Sponsor: PASSMN - https://www.mnssug.org/

Presentation topics and abstracts for this meeting:

#1: Difficult Queries

Take your T-SQL skills to the next level. Regardless of your current level there will be something here you'll be glad you didn't miss. Basics like avoiding cursors in iterative tasks and multi-database executions are the tip of the iceberg. If queries are basic arithmetic then this is basic algebra. First we see how coding style affects maintainability then dive into several types of encapsulation, parameterization and tricks with values, cross apply, pivot and more.

Speaker:

Rick has 35 years experience as a systems, applications and database architect having designed major systems for such institutions as NASDAQ, Bank of America, Blue Cross Blue Shield, Ecolab and Emperex. He holds multiple certifications including MCITP and MCSE in Business Intelligence and Data Platform. Rick currently designs database systems for custom software applications and likes speaking at local user groups and SQL Saturday events.

#2: SSIS to ADF V2

Azure Data Factory V2 recently went GA and has a lot of great new SSIS-like features but is it good enough to replace SSIS? In this session we will go over some of the new control flow, branching, and scheduling features in Azure Data Factory and see how to make a fully cloud capable data orchestration engine. As a bonus we'll also show how you can run SSIS packages directly in Azure!

Speaker:

Josh is a Principal Consultant with Pragmatic Works by day and tech geek at all times. He enjoys working with data technologies as well as dabbling in other areas such as web and VR programming. Josh is the Director of Membership / Treasurer on the PASSMN executive board.

• Important to know

There will be free wifi available with an event code and please bring a pen to fill out the survey / feedback forms.

Have a photo id available for registration desk to get printed badge. We typically serve pizza and have pop and water available when you arrive.