April 19, 2022 PASSMN Meeting (Virtual Meeting Only)

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

Agenda:
3:30-4:00 Kickoff / Announcements
4:00-5:00 sp_CRUDGen – How to generate and use the Search Stored Procedure AKA (Kitchen Sink) (Kevin Martin)
5:00-5:10 Break
5:10-6:10 Power BI Scatterplot Deep Dive ( Sandeep Pawar)
6:10-6:15 Closing

Presentation topics, abstracts, speaker bio for this meeting:

Speaker #1: Kevin Martin
Title:
sp_CRUDGen – How to generate and use the Search Stored Procedure AKA (Kitchen Sink)
Abstract:
Tired of writing stored procedures where it feels like you are writing the same code over and over again? Need to develop an optional parameter or kitchen sink stored procedure because users want a “does everything report”? If so, attend my presentation to see what I built that will save you massive amounts of time! sp_CRUDGen is a free open-source SQL Server stored procedure that generates stored procedures for you based on your tables and metadata like foreign keys and data types. The generated stored procedure code utilizes the SQL Server community best practices.
You can use sp_CRUDGen to generate 11 different stored procedures from basic your Create, Read, Update, Delete, Upsert stored procedures to extremely advanced safe dynamic search stored procedures otherwise known as optional parameters, kitchen sink, Swiss army knife, catch-all queries. The generated ‘Search’ (kitchen sink, optional parameters) stored procedure is the most exciting. sp_CRUDGen generates this dynamic, safe, and performant TSQL stored procedure for you. This will be the main stored procedure covered in this presentation.
sp_CRUDGen will auto-generate and regenerate stored procedures for you. If you want to customize one of the generated stored procedures, you can remove \ comment section and the stored procedure will not be overwritten. This project is being used by software developers and DBAs at the consulting company I work for. It saves massive amounts of development time and conforms to best practices.
Bio:
Kevin Martin is the author of the open source projects sp_Develop and sp _CRUDGen, used by database developers and software developers. Find it on GitHub. Kevin works as a Senior Data Architect for the Custom Software Development and Database & Analytics services company named Emergent Software. Emergent is a Microsoft Triple-Gold Partner in Application Development, Cloud Platform, and Data Platform.
Contact Emergent if you need senior level database development or administration assistance, even if it is to cover you on your vacation so you can turn your mobile off. Tell them Kevin sent you.

Speaker #2: Sandeep Pawar
Title:
Power BI Scatterplot Deep Dive
Abstract:
Scatterplot is one of the most versatile visuals in Power BI, loaded with features and yet it is often underutilized and incorrectly used. In this session we take a deeper look at this visual, it's features, common mistakes, hidden tricks, and my recommendations. We will also look at how to build a custom visual to overcome some of the limitations.
Bio :
Sandeep Pawar is a data science professional. He currently works as Sr Data Visualization Engineer at Humana where he uses advanced analytics and machine learning to improve well-being of Humana's customers.