May 18, 2021 PASSMN Meeting (Virtual Meeting Only)

Important Note: This meeting is online only and will not be held at the Microsoft Technology Center

Join Zoom Meeting
https://us02web.zoom.us/j/88993846377?pwd=NG1CdHlYYXR4VVV6NkFseWZHOHppQT09

Meeting ID: 889 9384 6377
Passcode: 472294
One tap mobile
+13017158592,,88993846377#,,,,472294# US (Washington DC)
+13126266799,,88993846377#,,,,472294# US (Chicago)

Dial by your location
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 646 558 8656 US (New York)
+1 253 215 8782 US (Tacoma)
+1 346 248 7799 US (Houston)
+1 669 900 9128 US (San Jose)
Meeting ID: 889 9384 6377
Passcode: 472294
Find your local number: https://us02web.zoom.us/u/kbj9iT3T6A

3:30-4:00 Kickoff / Announcements /Emergent Software
4:00-5:00 sp_Develop - SQL Server Development Assessment and Best Practices (Kevin Martin)
5:00-5:10 Break
5:10-6:10 Auto Correction? Watch this with the Query Store in Action!
(Deepthi Goguri)
6:10-6:15 Closing

Meeting Sponsor: Emergent Software (https://www.emergentsoftware.net/)

Emergent Software is an award-winning software company that provides high-quality custom software development, data engineering, and cloud transformation services. Emergent Software helps clients navigate the digital transformation journey by leveraging cloud-native technologies to modernization their applications, data, and cloud infrastructure. This journey is different for each client.

Emergent Software is a triple-Gold Microsoft partner in the areas of Application Development, Data Platform, and Cloud Platform and their expert team’s dedication to building long-term relationships makes them the ideal partner for your next project. To learn more about Emergent Software and to start a conversation about a project, you can visit their website to learn more. For direct inquiries, please reach out to hello@emergentsoftware.net or call the team at 612-217-0747.

Presentation topics, abstracts, speaker bio for this meeting:

#1: Kevin Martin

Topic:
sp_Develop - SQL Server Development Assessment and Best Practices

Abstract:

Kevin will demo the open-source SQL Server Development Assessment project containing the sp_Develop stored procedure. It can be used by database developers, software developers and for performing database code (smell) assessments to adhere to best practices.

Documentation Website: https://emergentsoftware.github.io/SQL-Server-Development-Assessment
GitHub Repo: https://github.com/EmergentSoftware/SQL-Server-Development-Assessment
Slide Deck: https://speakerdeck.com/kevinmartinlink/sp-develop

Speaker:

Kevin is the ‘Director of Database Development & Administration’ at a consulting company named Emergent Software (https://www.emergentsoftware.net). He has 20+ years’ experience in information technology with a focus and love of databases.

**#2: Deepthi Goguri **

Topic:
Auto Correction? Watch this with the Query Store in Action!

Abstract:

Are you facing performance issues due to the parameter sensitive queries? Are many plans being generated for your queries and you cannot control choosing the plan best for your query? Come learn in this session how we can capture the different plans generated for those queries and decide which plan you can force for better performance using the Query Store feature introduced in SQL Server 2016 and has advanced its features introducing Wait stats per Query plan and Automatic Plan correction feature in SQL Server 2017 and Azure SQL database.

Speaker:

Deepthi is a SQL Server Database Administrator with 7 years of experience in Administering SQL Servers. She is a Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification on Data Management and Analytics. Deepthi blogs for DBANuggets.com

• Important to know

This meeting is online only and will not be held at the Microsoft Technology Center.