Next Meetup

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.

Microsoft Technology Center

3601 76th St W; Suite 600 · Edina, MN

    Past Meetups (13)

    What we're about

    The Minnesota chapter of the Professional Association for SQL Server (PASS). PASSMN is a forum to exchange knowledge and ideas to better understand, develop, implement and support existing and future SQL Server technologies. Our technical sessions provide a professional, fun and educational environment for all levels of expertise.

    • Connect - register with PASSMN and attend meetings with local data professionals, like yourself.

    • Share - attend monthly PASSMN meetings and annual SQLSaturday events to share your knowledge with others.

    • Learn - we typically meet the third Tuesday of every month at the Microsoft Technology Center in Edina.

    The Minnesota SQL Server User Group is organized to bring professionals of all career levels that work with Microsoft's SQL Server, together to learn and network with others. There is no charge to attend and you are encouraged to bring your co-workers. Through our sponsors, we provide food and refreshments. We typically meet on the third Tuesday of every month at the Microsoft Technology Center in Edina (3601 76th Street West, Suite 600, Edina, MN 55435).

    Members (213)

    Photos (81)