talk-data.com

We will be hosting our September Meetup.

Thanks to Amazon for sponsoring us. Please note that you have to show sign up with your real name and show a Photo ID to the building security before entering the building. This is a requirement from the building security. If you are not ok with that, please do not sign up. You can not bring a +1, everyone needs to sign up. Please only sign up if you plan to come, we will keep notes.

Speakers: Divyendu Singh: How LLMs Help Us Manage PostgreSQL at Scale Marko Coha: Postgres in the Cloud

Additional information for Meetup attendees are available here: https://andreas.scherbaum.la/post/2025-05-05_attending-organizing-or-speaking-at-a-meetup/

How LLMs Help Us Manage PostgreSQL at Scale: The Xata Agent is an open-source AI PostgreSQL expert. It monitors Postgres clusters by analyzing metrics and logs, checking pg_stat_statements for slow queries, running EXPLAIN and interpreting the output. We have been using the Agent internally on a large fleet of production PostgreSQL clusters, and we have gathered valuable insights, including: - Comparing different models and providers and their benefits. - Combining cloud hosting observability data with Postgres tools. - The cost implications of using LLMs for database monitoring. - Testing the agent’s effectiveness in detecting performance regressions.

Postgres in the Cloud: This presentation provides a comprehensive overview of hosting PostgreSQL in the cloud, examining both strategic benefits and potential trade-offs. Attendees will first gain an understanding of the key reasons organizations choose cloud-based PostgreSQL deployments, including scalability, operational efficiency, and cost optimization. We will explore how cloud platforms can simplify database administration, accelerate time-to-market, and support dynamic workloads, while also enabling global accessibility and high availability.

🚀 Let's be kubestrong! 🎉 This September, be part of the 𝐒𝐡𝐚𝐫𝐞 𝐭𝐡𝐞 𝐉𝐨𝐲 – 𝟏𝟎𝟎% OFF Campaign and hear from a very special guest Sammy Cheung, to share his inspiring journey on becoming #kubestrong! For those of you are not aware, Sammy is probably one of the most certified person in the universe.

For our friends in Europe 🌍 — we know the timing isn’t ideal to join live. But don’t worry! You’ll still be included in the lucky draw, and winners will be notified via Discord and email. Plus, the session will be available to watch online later at your convenience. 🎥✨

More info on 👉 LinkedIn event!

✅ Sign up to 𝐏𝐚𝐫𝐭𝐢𝐜𝐢𝐩𝐚𝐭𝐞 👉 http://free.ksug.ai

Latest promotions!

• Up to 50% off KodeKloud plans using code K8SUGKK
• 40% off Linux Foundation, CNCF Learning & Certifications
• 30% off Civo Navigate London 2025 using code KSUG30
• 20% off using code KSAI20 to KubeCon North America 2025
• FREE AWS, GCP, OCI, learning & certs

Awesome giveaways from our amazing sponsors!

• KodeKloud Pro 1-year Subscription $456
• Kubernetes exam voucher $445 donated by Yongkang He
• The Kubernetes Bible paper book $59.99 by Packt
• Civo Navigate London 2025 ticket £720
• Civo Navigate India 2025 ticket $140
• Amazon Q Developer $25 Credits
• 50% off Cloud exam vouchers donated by our friends

Whether you're an #awstronaut, #kubestronaut, or #goldenkubestronaut — you're invited to join our monthly upcoming sessions and grow with the most active Cloud Native & AI community. Please reach out to me if you're keen to join us as a speaker.

Join #Discord for latest update 👉 https://discord.com/invite/Rp9WzYyKua

🔖 𝐎𝐧𝐠𝐨𝐢𝐧𝐠 𝐃𝐢𝐬𝐜𝐨𝐮𝐧𝐭𝐬: ☸ 30% OFF #Kubernetes – code 30K8SUG ☸ 37% OFF #KodeKloud plans - code K8SUGKK

𝐖𝐡𝐲 𝐖𝐞 𝐃𝐨 𝐓𝐡𝐢𝐬: ✅ Learn 𝐅𝐀𝐒𝐓𝐄𝐑 ⚡ ✅ Certify 𝐒𝐌𝐀𝐑𝐓𝐄𝐑 💰 ✅ Grow 𝐒𝐓𝐑𝐎𝐍𝐆𝐄𝐑 💪 𝟏𝟎𝟎,𝟎𝟎𝟎+ follow KSUG.AI 🔥 linktr.ee/ksug.ai

By registering, you consent to the management of your personal information in accordance with KSUG.AI Meetup's Privacy Policy. Additionally, you agree that our sponsors may contact you.

KSUG.AI is an independent community and not affiliated with or endorsed by CNCF. Kubernetes, K8s, Kubestronaut are registered trademarks of The Linux Foundation.

** Important RSVP here (Due to room capacity and building security, you must pre-register at the link for admission.)

Description: Welcome to our in-person AI meetup in New York. Join us for deep dive tech talks on AI, GenAI, LLMs and ML, hands-on workshops, food/drink, networking with speakers and fellow developers.

Tech Talk: Unstructured Data and Vector Databases Speaker: Tim Spann (Zilliz) Abstract: In this session, I will discuss the unstructured data and the world of vector databases, we will see how they different from traditional databases. In which cases you need one and in which you probably don’t. I will also go over Similarity Search, where do you get vectors from and an example of a Vector Database Architecture. Wrapping up with an overview of Milvus.

Tech Talk: Tailoring Foundation Models for Generative AI Applications Speaker: Suman Debnath (AWS) Abstract: In this session, we will focus on fine-tuning, continuous pretraining, and retrieval-augmented generation (RAG) to customize foundation models using Amazon Bedrock. Attendees will explore and compare strategies such as prompt engineering, which reformulates tasks into natural language prompts, and fine-tuning, which involves updating the model's parameters based on new tasks and use cases. The session will also highlight the trade-offs between usability and resource requirements for each approach. Participants will gain insights into leveraging the full potential of large models and learn about future advancements aimed at enhancing their adaptability.

Speakers/Topics: Stay tuned as we are updating speakers and schedules. If you have a keen interest in speaking to our community, we invite you to submit topics for consideration: Submit Topics

Sponsors: We are actively seeking sponsors to support our community. Whether it is by offering venue spaces, providing food/drink, or cash sponsor. Sponsors will not only speak at the meetups, receive prominent recognition, but also gain exposure to our extensive membership base of 20,000+ AI developers in New York or 400K+ worldwide.

Community on Slack/Discord

• Event chat: chat and connect with speakers and attendees
• Sharing blogs, events, job openings, projects collaborations

Mark your calendars! The award-winning community, ReactJS Girls is back for its summer edition! Join us on 19 September for the ReactJS Girls #28 meetup! Don’t miss our amazing lineup of speakers.

*Please be aware that our meetup is a free ticketed event. To join us in person, PLEASE RESERVE YOUR SPOT ON EVENTBRITE.

This meetup is organised by YLD and sponsored by Amazon. All talks will be recorded and shared on the Tech Talks YLD YouTube channel.

Photography, filming and recording notice Please note that all our events are filmed, recorded and photographed. All recorded material can be used to promote any upcoming meetups or events. If you wish not to appear in any of the material please let the organisers know upon arrival to the meetup/event, otherwise, it is assumed that you are giving permission to possibly be featured in any imagery related to the event. Thank you to YLD for organising, and Amazon for sponsoring this event.

Who are YLD? YLD is one of London’s fastest-growing product design and software engineering consultancies. They are experts in a variety of technologies and product development services, including React.js, Node.js and Design Systems, and have helped companies such as Trainline, Dazn, The Economist, Doctorlink, and many more to build exciting products and platforms. YLD is committed to the Open Source community that aims to create a sustainable product culture and delivery capabilities in each piece of work. YLD is hiring - check out the job page Join the conversation:

• X (formerly "Twitter") @YLDio
• LinkedIn

Who are Amazon? Founded in 1994, Amazon is a global tech leader known for its comprehensive e-commerce platform, Amazon Web Services (AWS) cloud computing solutions, devices like Fire TV and tablet, and digital streaming services like Prime Video and Amazon Music. Leveraging your existing React skills, you can publish apps to Amazon devices and reach customers in over 236 countries across 200+ million devices. Learn more by joining the Amazon developer community at developer.amazon.com/apps.

The 7th edition of the Belgium dbt Meetup will take place in Vilvoorde on September 5th.

dbt Meetups are networking events open to all folks working with data! Talks predominantly focus on community members' experience with dbt, however, you'll catch presentations on broader topics such as analytics engineering, data stacks, data ops, modeling, testing, and team structures.

🏠Venue Host: DPG Media, Medialaan 1, 1800 Vilvoorde 🤝Organizers: Sam Debruyn & Cedric Raeymaeckers 🚆 Getting there: parking available at Streamz, Medialaan 38, 1800 Vilvoorde - meetup itself is at DPG Media (Medialaan 1)

To attend, please read the Required Participation Language for In-Person Events with dbt Labs: https://www.getdbt.com/legal/health-and-safety-policy

Our venue has capacity limits, so please only RSVP if you intend to come. Reach out - send a message in #local-belgium on Slack - if you need to cancel last minute or change your RSVP status on the Meetup to "Not Going."

📝Agenda:

• 18h00: welcome with food & drinks
• 18h45: start presentations
• 20h00: networking & drinks

🗣️Presentations:

1) The paradigm shift to analytics engineering In this session, we'll explore how dbt's inspiration by software engineering practices made the tool so powerful and brought a new paradigm to data work: analytics engineering.

by Pieter Steenssens, Data Engineer at Bmatix Passionate about all things data & analytics engineering

2) Our dbt journey @ Streamz We will discuss how dbt has changed the way we build analytical data products at Streamz, explaining the story from both engineering and analyst perspectives, and focusing on specific use cases.

by Cedric Raeymaeckers, Senior Lead at Datashift I'm a Data/Analytics Engineer with 10 years of experience in data consultancy. I derive energy from bridging use cases with technical solutions. Nowadays I am primarily active as an architect or lead.

and Line Van Hemel, Data Modelling Lead at Streamz Transforming raw data into user-friendly and high quality data models is my core strength. In my last two roles at Virgin Media O2 and Just Eat Takeaway.com, I was the lead of the Data Modelling team. We led the data migration from Netezza and Amazon Redshift onto GCP (Google Cloud Platform) by capturing user requirements and rethinking the data architecture and lineage. Avoiding work duplication across the analytics departments and ensuring consistent and timely delivered KPI’s were my key principles.

We are always looking for speakers!

To submit a session for one of the next meetups, please use our Sessionize page. Are you in doubt if you're ready to give a talk? Check out dbt Labs's guide on how to deliver a fantastic presentation!

🤝 For the best Meetup experience, make sure to join the #local-belgium channel in dbt Slack (https://slack.getdbt.com/)!

dbt is the standard in data transformation, used by over 30,000 organizations worldwide. Through the application of software engineering best practices like modularity, version control, testing, and documentation, dbt’s analytics engineering workflow helps teams work more efficiently to produce data the entire organization can trust.

Learn more: https://www.getdbt.com/

This is a place for an in-person meeting in Chilworth. Check out the other one for a virtual meetup on MS Teams.

!!!!! ATTENTION Since September, we've been having meetups at Spectrum IT's office - Gamma House, Enterprise Rd, Chilworth, Southampton SO16 7NS https://maps.app.goo.gl/66tL8HfgFnoiQEh66

Agenda

18:00: Welcome and Intros

Spectrum IT Ian Cruickshank - Industry round-up + QA

Marta Czelusniak - Power Automate features for Power BI

pizza/networking

Marta Czelusniak - Power Automate features for Power BI I’ll go through some examples how Power Automate features can be beneficial for end users, PBI developers as well as platform admins.

Marta Czelusniak I’m Marta, I’m a senior data viz analyst working for Specsavers. I’m passionate towards learning and suggesting in the area of business intelligence.

*** A massive thanks to our sponsor Spectrum IT. Without them, we could not host this event for free. Spectrum IT kindly provided funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. ***

This is a place for an in-person meeting in Chilworth. Check out the other one for a virtual meetup on MS Teams.

!!!!! ATTENTION Since September, we've been having meetups at Spectrum IT's office - Gamma House, Enterprise Rd, Chilworth, Southampton SO16 7NS https://maps.app.goo.gl/66tL8HfgFnoiQEh66

Agenda

18:00: Welcome and Intros Tori Tompkins - Beginner's Guide to Large Language Models (LLMs)

pizza/networking Raffle

Tori Tompkins - Beginner's Guide to Large Language Models (LLMs) You've probably noticed a big change in the data world lately — everybody's buzzing about Generative AI and Large Language Models (LLMs). This session will explore everything you need to know about LLMs and Generative AI. Starting with the basics, we will cover how they actually work and how far they have come. Delving deeper, we'll discuss the capabilities and limitations of LLMs, providing insight into what they can and cannot achieve as well as address the ethical considerations and potential risks associated with their usage. We will end with use cases, a demo and what it takes to actually productise a LLM workflow.

Tori Tompkins Senior Data Science Consultant at Advancing Analytics Tori is a Senior Data Science Consultant at Advancing Analytics who has worked on a variety of machine learning and data science projects but mostly with Azure technologies, Databricks, MLFlow, Scikit-learn, PyTorch and NetworkX. She is a regular presenter of YouTube series Data Science Moments and founder of Girls Code Too UK.

*** A massive thanks to our sponsor Spectrum IT. Without them, we could not host this event for free. Spectrum IT kindly provided funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. ***

This is a place for an in-person meeting in Chilworth. Check out the other one for a virtual meetup on MS Teams.

!!!!! ATTENTION Since September, we've been having meetups at Spectrum IT's office - Gamma House, Enterprise Rd, Chilworth, Southampton SO16 7NS https://maps.app.goo.gl/66tL8HfgFnoiQEh66

Agenda

18:00: Welcome and Intros Mikey Bronowski - You get a copilot! Everyone gets a copilot!

pizza/networking

Raffle

Session details: 1. Mikey Bronowski - You get a copilot! Everyone gets a copilot! Discover the synergy between AI and everyday tools in this engaging session. With a focus on ChatGPT's innovations and the practical utility of Copilot across GitHub, Azure SQL, and Excel, we'll guide you through optimizing these advanced AI functionalities to elevate your work and simplify complex tasks.

*** A massive thanks to our sponsor Spectrum IT. Without them, we would not be able to host this event for free. Spectrum IT kindly provided funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. ***

This is a place for an in-person meeting in Chilworth. Check out the other one for a virtual meetup on MS Teams.

!!!!! ATTENTION Since September, we've been having meetups at Spectrum IT's office - Gamma House, Enterprise Rd, Chilworth, Southampton SO16 7NS https://maps.app.goo.gl/66tL8HfgFnoiQEh66

Agenda 18:00: Welcome and Intros

Mihaly Kavasi - Model Performance and Quality Analysis

pizza/networking break

Mihaly Kavasi - Increase your audience - Excel Integration in Power BI

Raffle + SQLBits 50 % discount code!!!

About: Mihaly Kavasi Mihaly discovered Power BI 8 years ago and has since become an expert on Power Platform. His deep understanding of business processes and decision drivers makes him a valuable adviser for customers looking to derive the most value from their assets. Mihaly helps customers define optimal governance structure and implement the right mix of governed self-service BI, as well as advises them on security and performance optimization and managing large scale deployments. He nurtures the next generation of analysts with an emphasis on user needs and UX. Certified Trainer since 2018, Fast Track Recognized Solution Architect for Power BI since 2021.

*** A massive thanks to our sponsor Spectrum IT. Without them, we would not be able to host this event for free. Spectrum IT kindly provided funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. ***

This is a place for an in-person meeting in Chilworth. Check out the other one for a virtual meetup on MS Teams.

!!!!! ATTENTION Since September, we've been having meetups at Spectrum IT's office - Gamma House, Enterprise Rd, Chilworth, Southampton SO16 7NS https://maps.app.goo.gl/66tL8HfgFnoiQEh66

Agenda 18:00: Welcome and Intros

Bart Vernaillen - The impact of character data types on query memory grants.

pizza/networking break

Ben Weiner - Automating Data Cleaning in Excel with Power Query

Raffle and finish

Session details: 1. Bart Vernaillen - The impact of character data types on query memory grants. How does a datatype impact your query performance?

Is there a relation between your data types and memory grants in SQL Server? We will clearly show you the impact we a few examples

2. Ben Weiner - Automating Data Cleaning in Excel with Power Query There are many ways to clean data in Excel using formulas and functions, but these can be manual and time consuming, especially if they need to be applied every time the data set is expanded.

Power Query is a tool in Excel which allows users to create a series of steps, such as removing duplicates, creating calculations and formatting text, that are remembered and automatically applied to a data set. In this presentation I will go through all the steps of cleaning a messy data set in Excel using Power Query, showing how to automate repetitive tasks so Excel users will be able to spend less time on data cleaning and more time on data analysis.

About: Bart Vernaillen I’m Bart Vernaillen, an experienced IT professional with over 20 years of experience.

My primary focus goes to automating SQL server administration tasks. In the past, I used VBScript to simplify database management tasks. However, when PowerShell emerged, I immediately transitioned to this new technology.

My extensive scripting experience enables me to create comprehensive automation solutions for various SQL tasks. From installation, configuration, and migrations to database creation, deletion, backup, restoration, and SQL monitoring. (and much more)

My motto: "If you do something, do it right immediately."

About: Ben Weiner A qualified CIMA Chartered Management Accountant and Microsoft Excel Expert Ben Weiner has been working in finance for over ten years. Initially working in accounting roles in the past few years he has moved in financial analysis using advanced Excel features to analyse financial data and build financial models, accounts and budgets and forecasts.

*** A massive thanks to our sponsor Spectrum IT. Without them, we would not be able to host this event for free. Spectrum IT kindly provided funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. ***

This is a place for an in-person meeting in Chilworth. Check out the other one for a virtual meetup on MS Teams.

!!!!! ATTENTION Since September, we've been having meetups at Spectrum IT's office - Gamma House, Enterprise Rd, Chilworth, Southampton SO16 7NS https://maps.app.goo.gl/66tL8HfgFnoiQEh66

Agenda 18:00: Welcome and Intros

Spectrum IT Aaron and Steve - Industry round-up + QA

pizza/networking break

Liz Hardy - Using your existing knowledge\, skills and experience to “make it” in the Tech World.

Raffle and finish

Session details: 1. Spectrum IT - Industry round-up + QA Spectrum IT to present what happens in the industry and the discussion with the attendees.

2. Liz Hardy - Using your existing knowledge\, skills and experience to “make it” in the Tech World.

Are you new to tech or have you started along the journey and are looking to make a success of working in this industry but aren’t sure how? Are you struggling to progress and want to know how to get further in your career?

Whether you are starting your first job, you already have years of experience in other areas or you are already part way into your journey, it’s only natural to think that it will be difficult to thrive in the Data World! However, don’t let this put you off. What if I told you that you might just find you have more relevant skills and experience to progress in tech than you first thought?

In this session, I will share my own experiences and how I have overcome many obstacles during my career so far where I have worked in a wide range of industries. Even if you are not new to tech but are keen to help others along their journey and learn from it, then this session is also for you.

We will talk about the skills and tools we have at our disposal that you can leverage to help kick-start your new tech career!

About Liz Hardy I work as a Data Platform Engineer at DataMasterminds. I have a passion for working with people, data, learning new things and sharing knowledge. I have worked with IT for the last 10 years working in a range of industries as a DBA and Team Lead and now specialise in SQL Server.

Find me at: www.linkedin.com/in/lizhardyuk

*** A massive thanks to our sponsor Spectrum IT. Without them, we would not be able to host this event for free. Spectrum IT kindly provided funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. ***

This is a place for an in-person meeting in Chilworth. Check out the other one for a virtual meetup on MS Teams.

!!!!! ATTENTION Since September, we've been having meetups at Spectrum IT's office - Gamma House, Enterprise Rd, Chilworth, Southampton SO16 7NS https://maps.app.goo.gl/66tL8HfgFnoiQEh66

Agenda 18:00: Welcome and Intros

Rob Litjens - Defender for SQL as part of your Defense in Depth strategy

pizza/networking break

Paulina Jędrzejewska - Keep Calm and C# - Scripting in Tabular Editor

Faith Oseghale & Chukwujekwu Anah - Optimizing Data Analysis using DAX

21:00: Raffle and finish

*** A massive thanks to our sponsor Spectrum IT. Without them, we would not be able to host this event for free. Spectrum IT kindly provide funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. ***

This is a place for online attendees. Check out the other one for an in-person meeting in Chilworth. Link to the Teams meetup

https://teams.microsoft.com/l/meetup-join/19%3ameeting_YTE1MGE4YTQtNjY4NC00NDEwLThiMTctYTkzOGQ4MDM2ODc3%40thread.v2/0?context=%7b%22Tid%22%3a%22ecbebdab-1287-47b8-8709-694ffe8697d1%22%2c%22Oid%22%3a%22a901008d-8ba1-459d-b8fa-3eccacfccadf%22%7d

!!!!! ATTENTION Since September, we've been having meetups at Spectrum IT's office - Gamma House, Enterprise Rd, Chilworth, Southampton SO16 7NS https://maps.app.goo.gl/66tL8HfgFnoiQEh66

Agenda 18:00: Welcome and Intros

Rob Litjens - Defender for SQL as part of your Defense in Depth strategy

pizza/networking break

Paulina Jędrzejewska - Keep Calm and C# - Scripting in Tabular Editor

Faith Oseghale & Chukwujekwu Anah - Optimizing Data Analysis using DAX

21:00: Raffle and finish

*** A massive thanks to our sponsor Spectrum IT. Without them, we would not be able to host this event for free. Spectrum IT kindly provide funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. ***

This is a place for an in-person meeting in Chilworth. Check out the other one for a virtual meetup on MS Teams.

!!!!! ATTENTION Since September, we've been having meetups at Spectrum IT's office - Gamma House, Enterprise Rd, Chilworth, Southampton SO16 7NS https://maps.app.goo.gl/66tL8HfgFnoiQEh66

Agenda 18:00: Welcome and Intros

Ivanna Jurkiv Ditlevsen - How to optimize Azure Synapse pipelines using SQL database meta data tables

pizza/networking break

Jacek Nosal - Power BI Maps. Outside your country.

Frederick Anaafi - Deep Dive into DataViz Tool: Microsoft Power BI

21:00: Raffle and finish

1. Ivanna Jurkiv Ditlevsen - How to optimize Azure Synapse pipelines using SQL database meta data tables

1. Azure Synapse pipelines allow to easily ingest data from a wide range of sources, and to orchestrate pipelines.

I am accustomed to using Synapse pipelines exactly for these purposes. I am also used to working in multiple deployment environments (DEV, UAT and PROD).

One challenge that I stumbled upon with this kind of setup was the effort and time it would take to make updates to the list of tables to be ingested and datasets to be refreshed in PowerBI.

For instance, to ingest data from an additional table, I would need to update the relevant parameter in one of the Synapse pipelines in DEV environment. Then it would be submitted in a pull request, released to UAT, tested there. Only after a few weeks, would the new data start being ingested in PROD.

Doesn't this sound too complex for what it really is?

If you agree, then tag along and I will show you how to use a few meta data tables built in a SQL database to optimize Synapse pipelines.

In my talk, I will focus on 2 examples: 1. using meta data tables to optimize ingestion of data tables 2. using meta data tables to optimize automatic refresh of PowerBI datasets from Synapse pipelines

Note: the session includes a walk-through the solution and assumes familiarity with Azure Synapse pipelines or Azure Data Factory

2. Jacek Nosal - Power BI Maps. Outside your country. Have you ever heard about Power BI, then tried to create a report and the first results were satisfactory. We even managed to create a visualization presenting the data on a map.

However, would you be ready to develop an administrative map from outside your country? Language barrier, new letters... can anything else surprise you? Let me show...

3. Frederick Anaafi - Deep Dive into DataViz Tool: Microsoft Power BI This session offers a comprehensive overview of the Power BI tool and its extensive capabilities, covering key topics such as data visualization, data modeling, and data analysis within the Power BI Platform. The integration of practical scenarios and examples showcases the applied use of Power BI in various industries and business contexts.

Through interactive demonstrations, participants will gain hands-on experience in connecting to diverse data sources, including Excel spreadsheets, SQL databases, and cloud-based services. By leveraging these connections, attendees will learn how to transform raw data into visually appealing and insightful reports. Practical scenarios will be presented, such as trend analysis and opportunity identification, as well as visualizing customer behavior to optimize marketing strategies.

Moreover, participants will be guided through the Power BI user interface, exploring a wide range of features and functionalities available for report creation and customization. Practical examples will illustrate the design of interactive visualizations, the application of filters and slicers for data exploration, and the incorporation of calculated measures and hierarchies for advanced analysis.

By the end of the session, attendees will establish a solid foundation in Power BI and possess the skills necessary to create impactful reports and dashboards. This session is ideal for individuals seeking to leverage the power of Power BI for data analysis and visualization in practical, real-world scenarios.

*** A massive thanks to our sponsor Spectrum IT. Without them, we would not be able to host this event for free. Spectrum IT kindly provide funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. ***

We are happy to announce our September PostgreSQL Meetup!

AWS gracefully offered to host us on September 18th, starting 18:00.

We have two great talks this time!

Exploring index infrastructure: Implementation of an opclass for UUID v1 support in PostgreSQL

by Nick Babadzhanian.

We'll touch on a number of topics ranging from WAL amplification and performance impact of data distribution to extension development and of course opclasses and their role in the index infrastructure of PostgreSQL.

We will touch on the internals but keep it friendly for a wide audience.

and

Patroni 3.0: What's New and Future Plans

by Polina Bungina and Alexander Kukushkin.

Patroni is one of the most popular and advanced solutions for PostgreSQL high-availability. It is integrated with a variety of distributed configuration stores allowing Patroni to work with PostgreSQL cluster information in a consistent way ensuring that there is only one leader at a time. Unlike the majority of existing solutions for automatic failover, Patroni requires a minimal effort to configure the HA cluster and supports auto-discovery of new nodes.

This talk will consist of a short introduction to the ideas behind Patroni, overview of the major features that we have released lately, cover some interesting failure scenarios which were fixed, and share some plans for the future development. Of course, the talk will not be complete without showing a live demo of some brand-new features.

Location: Amazon c/o Rocket Tower (BER16)

Charlottenstraße 4

10969 Berlin

Please note that you need to provide a registration and a photo ID for entering the building. Check-in will need approx. 30 minutes, please plan accordingly.

Food and soft drinks will be provided, alcohol is not permitted during the event.

Amazon is running a 1-day training event on 19th September. If you would like to participate, please contact your AWS SA/TAM/AM for more details.

Welcome to Southampton Data Platform and Cloud Group.

This is the meetup for the IN-PERSON event.

!!!! LOCATION CHANGE - DIFFERENT BUILDING !!!!! This month the meetup will be hosted at the Spectrum IT office:

Gamma House, Enterprise Road Southampton Science Park, Chilworth, SO16 7NS https://goo.gl/maps/BD9xqqBWPMgsrPze9

Registration will be open on Monday, two days before the event.

Agenda

18:00: Welcome and Intros

18:00: Jess Pomfret - Managing replication with dbatools

pizza/networking break

19:15: Mikey Bronowski - tba

20:00: Raffle and finish

Session details:

1. Jess Pomfret - Managing replication with dbatools

Folks - the wait is over! - REPLICATION commands are in dbatools.

One of the most highly requested dbatools features is for commands to manage replication and now they're here.

In this session, we'll run through the available commands and work through demos including:

- Enabling publication and distribution for our instance

- Creating publications

- Adding articles to publications

- Adding subscriptions

- Confirm it's all working

- Tearing it all back down again!

If you have been managing replication through the GUI and dreaming of a better way - come and join me for this action-packed session.

2. Mikey Bronowski - tba

***

A massive thanks to our sponsor Spectrum IT. Without them, we would not be able to host this event for free. Spectrum IT kindly provide funding for the room, pizza and a £20 Amazon Voucher for in-person attendees. Jess Pomfret provides the book about dbatools as a raffle prize.

***