April 2019 PASSMN Meeting
Details
Bring photo ID for Microsoft Check-in.
3:30-3:50 Registration, Networking, and Food
3:50-4:00 Kickoff / Announcements
4:00-4:30 Embracing the “Beginner’s Mind” for Effective Partnerships (Andrea Imhoff)
4:30-4:40 Break
4:40-6:00 Refactoring Monolith Stored Procedures (Riley Major)
6:00-6:10 Closing
--
Meeting Sponsor: PASSMN
Presentation topics and abstracts for this meeting:
--
#1: Embracing the “Beginner’s Mind” for Effective Partnerships
Andrea Imhoff will present a case study in basic SQL scripting to summarize a reporting model into a dataset for social policy research. By revisiting a simple SQL script, her talk will focus on sharing her learning curve in moving from creating an analytical process to explaining the impact of programming decisions to project owners. This talk includes facilitated audience participation to add community knowledge to the discussion. (Talk length: 5-7 minutes; Audience participation: 5-7 minutes.)
Bio:
With experience in the civil and nonprofit sectors, her experience highlights her skills in active listening, problem-solving, information systems and data analysis. Andrea takes pride in stirring up curiosity about data and information systems solutions in project owners to better understand pain points and readiness for change. She contributes to business intelligence initiatives to understand the customer through clarifying questions, scripting in T-SQL, devising reporting frameworks, and analyzing data. As a translator between business and IT, she helps leaders understand data limitations and leads active negotiations to come up with alternatives.
--
#2: Refactoring Monolith Stored Procedures
We get it. Move fast and break things. Just ship it! But what's left a giant stored procedure with cursors, temp tables, and mystery calculations. It's a big black box that nobody wants to touch. Let's fix that. We'll open the lid on an example monolith and do major surgery. What's left will perform better, be easier to understand, encourage code reuse, and be easier to test.
Bio:
Riley Major is an Enterprise Architect based in the Twin Cities, MN metro area who enjoys collaborating with business leaders to design technical solutions and working with technology professionals to build them. He's been programming and designing databases since he was a kid and doing so professionally for 20 years. He has a special place in his heart for T-SQL in SQL Server and loves to share that enthusiasm.
--
Important to know
There will be free wifi available and please bring a pen to fill out the survey / feedback forms.
We typically serve pizza and have pop and water available when you arrive.
--
Upcoming in May: Sneak Peek at SQL Server 2019 with Big Data Clusters and Power BI and SQL 2019 HDFS both from Superior Consulting
Looking for Summer (May through August) speakers and sponsors! If you just want to even do a 15 minute talk we are happy to have a Lighting Talk style meeting.
