[NOTE: the former "Google Cloud Meetup Zürich" group has been migrated to an official GDG Cloud community]

Join us for the 6th GDG Cloud Zürich Meetup at Google Offices in Zürich! If you're interested in presenting/speaking, then please fill out this form: https://docs.google.com/forms/d/e/1FAIpQLSeUUqeMrb6KD1zanhJ8ve5ZB-v7Z-VRHkxWVjA0NUwLyWavLg/viewform

Location: Google Offices Zürich, Entry Europaallee 24, 9th floor

Schedule:

⏰ 17:30: Doors open

⏰ 18:00: Welcome - Graham Polley & Thomas Hug (organisers)

⏰ 18:05: Talk 1: Hidden gems of BigQuery - Artem Nikulchenko

⏰ 18:35: Talk 2: Beyond the Surface: Why You Need to Understand Database Structures for Optimal Performance - Armando Ferrara

⏰ 19:05: Apéro - sponsored by Google Cloud

*********

Title: Hidden gems of BigQuery

Speaker: Artem Nikulchenko - PhD, Chief Software Architect, Associate Professor, GDE, Google Cloud Campion Innovator, Certified Google Professional Cloud Architect

Description: BigQuery is amazing. It is one of my favorite tools within Google Cloud. Luckily, it looks like Google feels the same and, to the joy of BigQuery fans, keeps adding new features there.

No matter how long I have been working with BigQuery, there is always something new I discover once in a while.

In this talk, I want to highlight several amazing BQ features, including three ways to do change tracking in BigQuery, clustering, indexing, and transactions.

*********

Title: Beyond the Surface: Why You Need to Understand Database Structures for Optimal Performance

Speaker: Armando Ferrara - Cloud Software Engineer for dormakaba

Description: Are you tired of sluggish database performance and the limitations of sharding? Do you want to take your production database systems to the next level? Look no further! In this talk, I will explore some game-changing concepts that can improve your database's performance without having to resort to sharding.

I'll start by diving into the world of B-Trees and B+Trees. By understanding the algorithms behind these structures, you can unlock the full potential of your database and boost scalability.

But that's not all - we'll also explore the importance of selecting the right ID for your B-Tree based database engines. Did you know that using UUID could be killing your database's performance? I'll explain why and provide recommendations to help you optimize your system. I'll show you some common mistakes people make and how to avoid them.

So if you're ready to take your production database systems to the next level, join us as I explore these exciting topics on Google Cloud and unlock the full potential of your database!