PASSMN Monthly Meeting - 2022-12

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

Agenda:
📅 Tuesday, December 20, 2022 📅
🕜 3:30-4:00 Kickoff / Announcements
🕜 4:00-5:00 Data analysis in Power BI (Rajendra Ongole)
🕜 5:00-5:10 Break
🕜 5:10-6:10 SQL Assessment - Microsoft's Best Practices Checker (Taiob Ali)
🕜 6:10-6:15 Closing

Sessions

🕜 4:00 pm
⭐️ DATA ANALYSIS IN POWER BI
• Introduction
• Import data & create data model
• Define relationships
• Create new measure using sum function
• Format measures
• Edit & delete measures
• Create new measure using count function
• Create new measure using distinct function
• Add comments to measures
• Create new measure with operators
• Quick Measure tool
• Create calculated column
• Measure vs. calculated column
• Measure that references another measure
• Iterator functions
• Time & date functions
• Find function
• If function
• Calculate function
🙂 Rajendra Ongole

🕜 5:10 pm
⭐️ SQL Assessment - Microsoft's Best Practices Checker
Do you want to get the current 244 suggested best practices from the SQL Server Team and evaluate your environments? These best practices are available for all instances, from your Data Center to the cloud.

In this demo session (Yes, no slides), I will show you both the “what” and “how” to use the SQL assessment API. How to customize your checks and create your own rules that fit your environments? You will learn to identify a setting change after your initial review. The demo will use SQL assessment API, PowerShell cmdlets, and the new ‘SQL Assessment’ extension in Azure Data Studio to export assessment results in a SQL table and create an HTML report. I will show you how to configure "SQL best practices assessment configuration" in the Azure portal for SQL Server running on Azure VM.

At the end of this session, you will be equipped with the toolset to set up and run your assessment, create customized rules, and determine your compliance score against suggested best practices.
🙂 Taiob Ali

Speakers

🙂 RAJENDRA ONGOLE
⚡️ Bosch, BI-Specialist
I am Rajendra, BI Specialist and Power BI Trainer.I’m sharing my knowledge on different Microsoft technologies like Power Platform – Power BI,Power Apps, Power Automate and Power Virtual Agents.With 11 Years of Experience in Software Development in different domains (Telecom, Manufacturing, Industrial Automation, Project Management office.
🔗 https://sessionize.com/rajendra-ongole

🙂 TAIOB ALI
⚡️ Microsoft MVP - Data Platform
Taiob Ali, Microsoft Data Platform MVP, is an accomplished technical leader with a proven record of success. During his last 16 years, he has worked with the Microsoft Data Platform and MongoDB, both on-premises and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare.

Taiob is currently working at “GMO LLC” as Database Solutions Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual chapters, Data Saturdays, and Azure conferences. He is a board member of New England SQL Server User Group, founder of 'Database Professionals Virtual Meetup Group', and organizer of Boston SQL Saturday.
🔗 https://sessionize.com/sqlworldwide/