PASSMN Meeting 2023-11-21 (Virtual Meeting Only)

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

Agenda:
📅 Tuesday, November 21, 2023 📅
🕜 3:30-4:00 Kickoff / Announcements
🕜 4:00-4:20 Slowly Changing Dimensions (Deexith Reddy)
🕜 4:20-4:30 Break
🕜 4:30-5:30 I lost my job! Now what?!? A survival guide for the unemployed (Ray Kim)
🕜 5:30-5:45 Closing

Sessions

🕜 4:00 pm
⭐️ Slowly Changing Dimensions
🙂 Deexith Reddy

What are SCDs, and why are they important in data warehousing?
Types of SCDs: SCD 1, SCD 2, SCD 3, and SCD 6

Designing SCD : Effective Date, Expiration Date, and Active Flag
Step-by-step process for implementing SCD

Introduction to real-time streaming and its significance in modern data processing

Challenges of integrating SCD 2 with real-time streaming
Strategies for maintaining historical records in real-time streaming environments

Integrating SCD 2 with Batch Streaming:

Introduction to batch streaming and its role in data warehousing
Challenges of integrating SCD 2 with batch streaming
Strategies for maintaining historical records in batch streaming environments

Best Practices and Tips:

Key considerations for implementing SCD in various data processing scenarios

Techniques for optimizing performance and ensuring data integrity
Monitoring and troubleshooting SCD implementations

Conclusion: Recap of the session, highlighting the main takeaways, and opening the floor for questions and discussions.

🕜 4:30 pm
⭐️ I lost my job! Now what?!? A survival guide for the unemployed
🙂 Ray Kim
You’ve just been told by HR that you are no longer a part of their organization. You’ve been kicked to the curb. You are now living in the no-man’s land called unemployment.
Unemployment is a scary situation. You’re dealing with emotions and uncertainty. You don’t know if you’ll be out of work for days, weeks, or months.
Fortunately, unemployment is survivable. In this session, I’ll share my own experiences (and perhaps we’ll talk about some of yours) with unemployment, and how I managed to get through the tough times. We’ll discuss emotional impact, the job hunt, and things you can do to get yourself through this tough time. Hopefully, you’ll land on your feet once again before long!

Speakers

🙂 Deexith Reddy
⚡️ Slowly Changing Dimensions
Deexith is a Senior Data Engineer at Fidelity Investments and thought leader in the Automation of Data Engineering space utilizing innovative technology tools, resulting in achieving saving in time and huge cost savings for the companies. Working as a data engineer consultant. Have exposure to data analytics automation, how to leverage cloud services for data analytics and reducing error. Great proponent for democratizing data in the organization and pushing forward the agenda of enterprise analytics.

🙂 Ray Kim
⚡️ I lost my job! Now what?!? A survival guide for the unemployed
Technical writer -- my job is to make other people's jobs easier
Ray Kim is an advocate for documentation and technical communication. He is a co-founder of the Albany, NY SQL group (CASSUG), a member of the AlbanyUX user group, and a member of the Society for Technical Communication (STC). He has spoken at numerous SQLSaturdays and at PASS Summit. He has worked various positions in technology, including as a developer, webmaster, analyst, technical writer, and instructor. He holds an MS in technical communication from Rensselaer Polytechnic Institute and a BS in computer science from Syracuse University.
A musician in his spare time, Ray plays four different instruments (piano, clarinet, mallet percussion, saxophone). He also enjoys going to ball games and doing CrossFit, and is a two-time ​ fantasy football champion. He lives in Troy, NY with his wife, Lianne, and their two cats.
🔗http://sessionize.com/ray-kim