July 2019 PASSMN Meeting


3:30-3:50 Registration, Networking, and Food
3:50-4:00 Kickoff / Announcements
4:00-5:00 Playing with (M)agic: an introduction to writing M code in Power
5:00-5:10 Break
5:10-6:25 Optimizing SQL Server: What Developers Can Do and How DBAs Can Help
6:25-6:30 Closing


* Join us at Pinstripes right after the meeting and hang out with your peers for Bocce ball and appetizers! Just a couple blocks away at 3849 Gallagher Dr.

* SQLSaturday #913 is coming up quickly (October 12th @ St. Paul College)

* August 1st is deadline of call for speakers

* We are still looking for sponsors for our SQLSaturday. Please get in touch or send any leads to Chris Kramer @ [masked]


**#1:Playing with (M)agic: an introduction to writing M code in Power B**

Do you love Power Query? Are you ready to take your skills to the next level? Learning to write M code is easier than you think! Writing M code can reduce maintenance and create a more dynamic solution for you and your users.

In this session you will learn:

1. Where you can write M code in PowerQuery.
2. The different types of objects you can use as variables in your code.
3. Different ways you can leverage variables to create a dynamic solution.

Justin Mannhardt
Principal Consultant, PowerPivotPro

An experienced Data and Analytics leader, with 10 years of diverse experience. With a specialty in Power BI, Justin helps individuals and organizations get the most from their data.

As a Principal Consultant with PowerPivotPro, Justin knows what it takes to deliver a successful Power BI deployment from Data Management to ETL to Dashboards, and everything in between.

Justin is a Microsoft Certified Solutions Associate in BI Reporting

**#2: Optimizing SQL Server: What Developers Can Do and How DBAs Can Help**

A growing business hired me to add to their software-development team. A queue of worthwhile, interesting projects greeted my arrival. Alas, with flourishing order volume came an unforeseen, sudden result: an overwhelmed SQL Server instance. This urgent situation led me to shelve my project work and delve into optimizing our SQL Server implementation. Over about a year, I improved our database performance considerably. Our applications became faster and had fewer database-related errors. With far fewer urgent database issues, I could resume project work. Trial and error, plus some other resources, taught me practical ways to improve our database code and to troubleshoot SQL Server performance. I want to share some of these tips with you!

I will teach some rules of thumb for writing better-performing SQL Server queries quickly. I will also show how to troubleshoot performance with SQL Server execution plans. If you are unfamiliar with execution plans, don’t worry! We will go through how to use these diagrams to see how SQL Server runs your queries and how to fix problems. Execution plans show a lot of information, and I will share what is important and what you should ignore.

As I share these tips with my team, they write better queries. If you are a developer who knows a little or a lot about SQL Server, you will learn tips you can use tomorrow morning to improve your database code. If you are a DBA, you can use these tips to help developers write better queries and make your job easier. Even for teams using object-relational-mapping frameworks like Entity Framework or NHibernate, knowing how to find bad ORM-generated queries will help performance.

Andrew Brobston is a senior full-stack software developer at SJV & Associates, an Atlanta-area company specializing in background checks. Previously, he was a full-stack developer with Stack Overflow. His Microsoft SQL Server experience started with SQL Server 2000, and he has worked with every version since then. Though he is a software developer, not a database administrator, he may or may not have an actual DBA hat. Come to the talk to find out!