Hardware

We're excited to bring the community together for an evening of learning and connection! Come support your fellow developers, learn something new, and meet others who are passionate about search, observability, and security. **Date and Time:** Thursday, March, 12th from 5:30-7:30 pm **Agenda:** * 5:30 pm: Doors open; say hi, grab a seat, and eat some food. * 6:00 pm: Building Agentic AI on ELK stack, by **Gleb Gadyatskiy**, Principal Engineer at PointClickCare * 6:30 pm: Q&A * 6:40 pm: "One Does Not Simply Query a Stream", by **Viktor Gamov** is a Principal Developer Advocate at Confluent * 7:10 pm: Q&A * 7:20-7:30 pm: Networking & refreshments **Talk Abstracts:** **"Building Agentic AI on ELK stack"** Story how I built AI Agent using pure ELK + LLM to automate incidents investigations 1. What is AI Agent, ELK and why I decided to build AI Agent using only ELK 2. Building simple AI Agent using pure Logstash pipelines 3. Building advance AI Agent using Ruby plugin 4. Connecting AI Agent to Elastic AI Assistant **Gleb Gadyatskiy** is a Principal Engineer at PointClickCare. He is a part of the Infrastructure Architecture team and describes his role as “the first line in attack and the last line in defense”. Gleb provides support for all teams to aggregate logs from various apps into Elasticsearch, use AI to get insights from logs and actively promotes Elastic stack in PointClickCare. Gleb enjoys outdoor traveling with his wife and two kids in a camper. **"One Does Not Simply Query a Stream"** Streaming data with Apache Kafka® has become the backbone of modern applications. While streams are ideal for continuous data flow, they lack built-in querying capabilities. Unlike databases with indexed lookups, Kafka’s append-only logs are designed for high-throughput processing—not for on-demand queries. This necessitates additional infrastructure to query streaming data effectively. Traditional approaches replicate stream data into external stores: relational databases like PostgreSQL for operational queries, object storage like S3 accessed via Flink, Spark, or Trino for analytics, and Elasticsearch for full-text search and log analytics. Each serves a purpose—but they also introduce silos, schema mismatches, freshness issues, and complex ETL pipelines that increase system fragility. In this session, we’ll explore solutions that aim to unify operational, analytical, and search workloads across real-time data. We'll demonstrate stream processing with Kafka Streams, Apache Flink®, and SQL engines; real-time analytics with Apache Pinot®; search capabilities with Elasticsearch; and modern lakehouse approaches using Apache Iceberg® with Tableflow to represent Kafka topics as queryable tables. While there's no one-size-fits-all solution, understanding the tools and trade-offs will help you design more robust and flexible architectures. **Viktor Gamov** is a Principal Developer Advocate at Confluent, founded by the original creators of Apache Kafka®. With a rich background in implementing and advocating for distributed systems and cloud-native architectures, Viktor excels in open-source technologies. He is passionate about assisting architects, developers, and operators in crafting systems that are not only low in latency and scalable but also highly available. As a Java Champion and an esteemed speaker, Viktor is known for his insightful presentations at top industry events like JavaOne, Devoxx, Kafka Summit, and QCon. His expertise spans distributed systems, real-time data streaming, JVM, and DevOps. Viktor has co-authored "Enterprise Web Development" from O'Reilly and "Apache Kafka® in Action" from Manning. Follow Viktor on X - @gamussa to stay updated with Viktor's latest thoughts on technology, his gym and food adventures, and insights into open-source and developer advocacy. **Location:** Improving Office 171 East Liberty St Unit 235 Toronto, Ontario M6K 3P6 **Directions (171 E Liberty St - Suite 235)** **By transit** Streetcars 504 and 509 both travel close to the office (less than 10 minute walk to the office from either), the lakeshore GO train is also a 5 minute walk from the office. **By car/parking** On street parking is available - there are a handful of paid parking spots directly in front of the entrance - with a large city parking lot across the street. **Entrance** The entrance to the office is beside the Bulk Barn entrance facing Hannah Street. There is an Improving logo on the door.

Important Register on the [event website](https://www.aicamp.ai/event/eventdetails/W2026031214) (Due to room capacity and building security, you must pre-register at the link for admission) **Description:** Welcome to the AI meetup in Toronto. Join us for deep dive tech talks on AI, GenAI, LLMs and Agent, hands-on experiences on code labs, workshops, and networking with speakers and fellow developers. **Speakers/Topics:** \- Eli Aleyner \(Docker\) 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](https://forms.gle/JkMt91CZRtoJBSFUA) **Sponsors:** We are actively seeking sponsors to support AI developers community. Whether it is by offering venue spaces, providing food, or cash sponsorship. Sponsors will not only speak at the meetups, receive prominent recognition, but also gain exposure to our extensive membership base of 10,000+ AI developers in Toronto or 500K+ worldwide.

**PLEASE READ:** This event will show as sold out on meetup since this event has a limit of 5 spaces and tend to book up. You can **SECURE** your seat through purchasing a ticket on https://lvlupgames.ca/products/learn-to-play-d-d-5th-edition-obojima in advance. **If you can add it to cart on the site that means the spot is still available!** **Description** This will be a **1 day event**. We will teach you character creation and core game mechanics on as well as run a short 45 minute - 1 hour campaign to play your new characters. These sessions are meant to be **introductory friendly for new adventurers to get their foot in the door of D&D.** We do offer a full 3-4 hour Obojima session separately for those who have already participated in the learn to play or players that already know the mechanics of D&D 5th edition if you are interested! **Please ensure you are available for your chosen date before you purchase your ticket.** Every **month** will be a **new** adventure from Obojima Tales from the Tall Grass book! With your ticket you'll receive: * Character sheet * Pencil * Set of 7 dice (D4, D6, D8, D10, D12, D20, D%) * Access to the Players Handbook **Game Master:** Nick (He/Him) Nick, has been a Dungeon Master for 10 years, experienced in many mainstream and indie RPG systems. Outside of RPGs, Nick has several years of theatre experience, being an actor in his youth and continuing his studies even now. He is upbeat and theatrical, standing and acting out dramatic action sequences and quiet emotional scenes. More than anything, Nick always tries his best to deliver an experience, something that will be a special memory for everyone. **What is 5th Edition and how does it differ from 5.5 Edition?** Dungeons and Dragons 5th Edition is an older version that was released in 2017 where 5.5 is the most current edition (released in 2024) with some changes to game mechanics. Most third party campaigns are made for 5th edition mechanics. So if you would like to play any D&D campaigns prior to 2024 (the majority of them) 5th edition would be your go-to! If you are interested in the 5.5 Edition we have a Dragon Delves learn-to-play series available as well. Due to the limited spaces available for this event, we will not be issuing refunds for this event **less than 48 hours before the event**. Be sure to purchase the ticket for the correct date.

This is a ticketed event. Please register at [this link](https://luma.com/hpn010ze). ​Future AI systems could have action-guiding and learning systems which may plausibly resemble those of current human or animal brains. What might it take to make these systems safe? In this presentation, David Atanasov will talk about the work from people who have thought about aligning these hypothetical future systems. ​**Event Schedule** 6:00 to 6:30 - Food and introductions 6:30 to 7:30 - Presentation and Q&A 7:30 to 9:00 - Open Discussions ​​​If you can't attend in person, join our live stream starting at 6:30 pm via [this link](https://www.youtube.com/@Trajectory-Labs/live).

**PLEASE READ:** This event will show as sold out on meetup since this event has a limit of 5 spaces and tend to book up. You can **SECURE** your seat through purchasing a ticket on https://lvlupgames.ca/products/learn-to-play-d-d-adventurers-league-dragon-delves-death-at-sunset in advance. **If you can add it to cart on the site that means the spot is still available!** **Description** Hello adventurers! Have you ever wanted to experience the world of Dungeons and Dragons but not know how to get started? In this event we will teach you character creation, core game mechanics, and go through a 60-90 minute one-shot scenario for you to test out your newly created character! These sessions are meant to be **introductory friendly for new adventurers to get their foot in the door of D&D.** With you ticket you'll receive: * Character sheet * Pencil * Set of 7 dice (D4, D6, D8, D10, D12, D20, D%) * Access to the Players Handbook **Game Master:** Nick (He/Him) Nick, has been a Dungeon Master for 10 years, experienced in many mainstream and indie RPG systems. Outside of RPGs, Nick has several years of theatre experience, being an actor in his youth and continuing his studies even now. He is upbeat and theatrical, standing and acting out dramatic action sequences and quiet emotional scenes. More than anything, Nick always tries his best to deliver an experience, something that will be a special memory for everyone.

Important Register on the [event website](https://www.aicamp.ai/event/eventdetails/W2026031214) (Due to room capacity and building security, you must pre-register at the link for admission) **Description:** Welcome to the AI meetup in Toronto. Join us for deep dive tech talks on AI, GenAI, LLMs and Agent, hands-on experiences on code labs, workshops, and networking with speakers and fellow developers. **Speakers/Topics:** \- Eli Aleyner \(Docker\) 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](https://forms.gle/JkMt91CZRtoJBSFUA) **Sponsors:** We are actively seeking sponsors to support AI developers community. Whether it is by offering venue spaces, providing food, or cash sponsorship. Sponsors will not only speak at the meetups, receive prominent recognition, but also gain exposure to our extensive membership base of 10,000+ AI developers in Toronto or 500K+ worldwide.

SPACE IS LIMITED! This is a much smaller class than our 7:30 pm event and we can only accept a limited number of students. Key areas of focus: Practicing oral communication (speaking languages), for conversations, presentations, interviews and job skills Schedule: 1. 6:30- 7:15 pm : 45 -minute language conversation class with certified award-winning language teacher John Dias. 2. Language exchange social (7:30-11 pm): includes Free access to the Toronto's BIGGEST Language Party and Social Party also in the Madison Pub led by teacher John Dias (same location) **Cost: just $ 5 while we have this promo.** **PROMO (Limited Time): $5 fee will give you access to both events (usual rate: $15 total)** Feel free to message us if you have any questions!

🚨👉 To RSVP for this event, head to our [Luma event page](https://luma.com/wzaj4vzy). RSVPs are intentionally closed on Meetup.👈🚨 https://luma.com/wzaj4vzy ​**$90 · TAX INCLUDED — LUMA RSVP + PAYMENT REQUIRED TO CONFIRM YOUR SPOT** To reserve your spot, please **e-transfer $90 to** 📧 **techtankto@gmail.com** ​Registration is **confirmed only once payment is received**. Please include your **full name + “Code Diversity Clay & Connection”** in the transfer note. ​Spots are limited and will be filled on a **first-paid, first-confirmed** basis. is. *** ​This winter, we’re doing something a little different. ​For International Women’s Day, join **CodeDiversity ×** [TigerBaby](https://www.instagram.com/tigerbabycc) for a cozy, hands-on **pottery + coffee social** designed for **women and non-binary folks in tech** who want to connect, slow down, and have some fun. ​Instead of our usual discussion-based meetup, this event is intentionally low-pressure and creative — a chance to step away from screens, work with your hands, and spend time in good company. ​We’ll spend the afternoon: * ​sharing coffee and conversation * ​getting our hands dirty with clay *(no experience needed)* * ​escaping winter isolation in a warm, welcoming space * ​making new connections — **without networking pressure** *** ​🧱 What’s Included ​Your **$90 (tax included)** covers: * ​A guided pottery workshop led by [TigerBaby](https://www.instagram.com/tigerbabycc) * ​All materials * ​Firing of your finished piece *** ​🕰 Schedule ​**11:00 – 11:30** Welcome + mingle — grab something to eat or drink ​**11:30 – 1:30** Pottery workshop ​**1:30 – 2:00** Clean-up + wrap-up ​📍 **Creeds Coffee Shop** *** ​[TigerBaby Coffee & Clay](https://www.instagram.com/tigerbabycc) is a Toronto-based creative brand rooted in slowing down, working with your hands, and finding joy in everyday rituals. Founded by siblings Sarah—a ceramics artist—and Thomas—a self-proclaimed specialty coffee nerd—TigerBaby brings together craft, care, and community. ​In this hands-on pottery class, you’ll create your own ceramic mug from start to finish using hand-building techniques. This workshop is beginner-friendly and designed to feel calm, welcoming, and unhurried. You’ll be guided through shaping, attaching a handle, and refining your form, with plenty of time to explore the process and make the mug your own. Quick reminders: * ​This event is intended for **women & non-binary folks** * ​No prior pottery experience required * ​Attendance is confirmed **only after e-transfer is received** * ​Please make sure your **RSVP name matches your e-transfer name** ​If you’re craving connection, creativity, and a softer way to mark International Women’s Day, we’d love to have you join us! **Important Notes for RSVPs** We’re introducing a few questions when you RSVP to help us manage space and ensure an inclusive environment: ​​**This is a space created to support people who are underrepresented in tech.** We ask **cisgender men** (men who were assigned male at birth and identify as male) to respect this and not attend. ​​**Photography & Video Disclaimer:** By attending this event, you acknowledge and agree that photographs and/or video recordings may be taken. These may be used for promotional purposes, including social media, websites, and other marketing materials. If you do not wish to be photographed or recorded, please inform the event organizer upon arrival. **Organized by TechTank** Let’s continue fostering diversity, inclusion, and innovation in tech—this month and beyond! **Join our vibrant community for the latest updates and continued discussions:** [https://linktr.ee/techtankto](https://linktr.ee/techtankto)

The Board Games event is a fun, sociable and charitable event We are a fun, friendly and kind group of people mostly in our 20s, 30s and 40s. Beginners are welcome! We are a very inclusive and social group and we teach people how to play games they have not played before :) We provide a variety of 40+ board games. The games usually take 5 or 10 minutes to learn and 30 to 60 minutes to play. **Time** * Board Games Start time: 630pm * Board Games end time: 10pm * Eat / Drink/ Socialise at a nearby pub afterwards **Location** 30 Leeds St, Toronto, ON M6G 3R8 (Ukrainian Catholic Church of the Holy Protection) The entrance to the board game room is at the back of the Church. There is a sign on the door that says BOARD GAMES GROUP. Please use the map provided on the event page also. **Fee** $10 Cash (no coins ) $11.55 by card or e-Transfer * e-Transfer before or at the event dvschiller@gmail.com for e-Transfer **Charity Donations** * This is a not-for-profit initiative. Revenue go towards covering costs of the event including venue, insurance marketing, refreshments and board games. Any surplus revenue is donated to charity **Food and drink** * Everyone will get cookies/candy for free * Cups will be provided for tap water * Bring your own food and drink. * Please do not bring CHIPS AND CRACKERS as they make a mess and are greasy * **ALCOHOL IS PROHIBITED AND WE HAVE A ZERO TOLERANCE POLICY ON THIS - there are no second chances** Photos will be taken at the event and posted publicly for marketing purposes. Please only attend if you are ok with this or tell me when you arrive that you do not want to be in any photos The event is officially hosted by Ace of Math Learning Program Ontario Inc.

On March 14th, 2026, [AgentCon](https://www.linkedin.com/search/results/all/?keywords=%23agentcon&origin=HASH_TAG_FROM_FEED) lands in Toronto, bringing together developers, engineers, and innovators shaping the future of AI agents. Expect deep‑dive talks, hands‑on learning, practical demos and plenty of networking with the AI community. This isn’t just another AI event, it’s where builders meet to talk real code. ✅ Ready to build the future? Register Now: [https://lnkd.in/dX5AVXRw](https://lnkd.in/dX5AVXRw)

IMPORTANT: You must also register at this link [Henry's Church - Crafting Impactful Portraits with Raph Nogal Tickets, Friday, Mar 13 from 1 pm to 3 pm | Eventbrite](https://www.eventbrite.ca/e/henrys-church-crafting-impactful-portraits-with-raph-nogal-tickets-1983618316783?aff=oddtdtcreator) Join professional photographer, Raph Nogal, at Henry’s Church St. for an inspiring and creative workshop sponsored by Sony and Profoto. This workshop is free to attend. This session dives into shaping light with intention — from concept to execution — using Sony camera system & lenses, and Profoto lighting tools to create bold, dimensional portraits. Raph will break down his approach to building mood, directing subjects, and crafting images that feel both cinematic and commercially polished. Perfect for photographers looking to elevate their lighting, refine their creative process, and produce work that stands out. **Follow Raph on instagram (@raphnogal) and make sure to subscribe to his YouTube channel (@RaphNogalPhotography)** **About Raph:** Raph Nogal is a Polish-Canadian professional photographer based in Toronto (est. 2009). Known for his bold use of colour, hard light, and sculpted shadow, Raph specializes in commercial, editorial, and lifestyle photography. His work is defined by a creative off-camera lighting approach that blends cinematic mood with commercial precision. Raph is a Profoto Ambassador, Sony Pro, and active educator and speaker, regularly sharing his expertise on lighting, creative direction, and visual storytelling. Before transitioning fully into commercial work, he built a strong foundation as a wedding photographer. A 24-time recipient of the WPPI Honours of Excellence Awards, Raph is also a Fearless Photographers Award winner, Shutterfest Print Competition Award winner, and a PPOC award recipient, with images selected for both National and Regional Loan Collections across Canada.

In a moment in which anti-migrant rhetoric, ethnonationalism, and authoritarian populisms are on the rise, it becomes increasingly important that political theorists do more than offer a moral indictment of racism and xenophobia. In this talk, I contend that Frantz Fanon’s sociogenic approach to the critique of ‘race’ and racialization makes a valuable contribution, even in postcolonial conjunctures that have moved beyond colonialism’s crude Manichean binaries. I read Fanon as a diagnostician of the social pathologies produced by colonialism and white supremacy, showing how he worked from the colonized subject’s experiences of inferiorization and the colonizer’s experiences of racial superiority and *self-mystification* to advance a negative critique of racial hierarchies. Sarah Bufkin https://www.birmingham.ac.uk/staff/profiles/gov/bufkin-sarah Assistant Professor in Political Theory Department of Political Science and International Studies University of Birmingham **About the Speaker:** My research sits at the intersection of antiracist political theory and Critical Theory, including that of the German Frankfurt School, French poststructuralism, and the British Birmingham School of Cultural Studies. I am currently working on a book project focused on Frantz Fanon's sociogenic method of antiracist critique. Drawing in part on my doctoral thesis, I argue that the failure to theorize 'race' has substantial consequences for continental political theory including but not limited to understanding the reproduction of racial injustice. I have also written on the politics of voice and visibility in the U.S. and Northern Ireland. More broadly, I am interested in feminist thought, social epistemology, and continental philosophies of self and Other. **\* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \* \*** This is a talk with audience Q&A presented by the University of Toronto's Centre for Ethics that is free to attend and open to the public. The talk will also be streamed online with live chat here [to be posted]. About the Centre for Ethics (http://ethics.utoronto.ca): The Centre for Ethics is an interdisciplinary centre aimed at advancing research and teaching in the field of ethics, broadly defined. The Centre seeks to bring together the theoretical and practical knowledge of diverse scholars, students, public servants and social leaders in order to increase understanding of the ethical dimensions of individual, social, and political life. In pursuit of its interdisciplinary mission, the Centre fosters lines of inquiry such as (1) foundations of ethics, which encompasses the history of ethics and core concepts in the philosophical study of ethics; (2) ethics in action, which relates theory to practice in key domains of social life, including bioethics, business ethics, and ethics in the public sphere; and (3) ethics in translation, which draws upon the rich multiculturalism of the City of Toronto and addresses the ethics of multicultural societies, ethical discourse across religious and cultural boundaries, and the ethics of international society. The Ethics of A.I. Lab at the Centre For Ethics recently appeared on a list of 10 organizations leading the way in ethical A.I.: https://ocean.sagepub.com/blog/10-organizations-leading-the-way-in-ethical-ai

Discover Kiro, AWS’s innovative development environment that adapts to your workflow. Whether you prefer specification-driven development or a more intuitive, vibe-based approach, Kiro empowers you to build applications your way. In this session, speakers will explore Kiro’s core functionality and its evolution through re:Invent 2025, along with demonstrations of prompts used to create APIs, hooks, and steering documents. In the latter part of the session, watch as we build a complete example from scratch, showcasing Kiro’s agentic AI workflow in action for spec-driven development and vibe coding. What You'll Learn - Core Kiro concepts and development philosophy Feature evolution: pre and post re:Invent 2025 Practical examples: API creation, hooks, and steering docs Live coding demonstration with real-time problem solving Who Should Attend - Developers, solutions architects, and technical leaders interested in modern AWS development tools and AI-assisted coding workflows. **Speakers Bio:** Matthew Jorat: Matthew Jorat is a Customer Solutions Manager at AWS with nearly three decades of expertise in AI, cloud transformation, migration, modernization, IT, technology, and business. His career spans infrastructure engineer, solutions architect, security auditor, customer success director, support and services director, and operations officer. He was an early adopter of AWS services as a customer, and his current role at AWS uniquely blends his technical and business skills as he partners with executive teams to translate strategic priorities into measurable business outcomes through cloud adoption, AI implementation, and operational excellence. Matt leads end-to-end AI initiatives for enterprise customers, identifying high-impact use cases and maintaining relentless focus on measurable ROI. He holds eight AWS certifications and serves as Adjunct Professor at Franklin University teaching cloud computing and AWS architecture. His expertise encompasses GenAI, agentic AI systems, migration, modernization, and optimization strategies that drive transformation at scale. [https://www.linkedin.com/in/mattjorat/](https://www.linkedin.com/in/mattjorat/) Girish Bhatia: Girish Bhatia is a seasoned technology delivery leader with deep expertise in cross-domain program management. He holds multiple AWS certifications, including AWS Certified Solutions Architect – Associate, AWS Certified Developer – Associate, and AWS Generative AI Practitioner, and is also an AWS Community Builder. Girish brings over two decades of experience in the information technology industry. Throughout his career, Girish has led major technology-driven business transformation from modernizing on-premises applications to driving large-scale cloud migrations. His work includes API-based integration platforms, data-center and mainframe modernization, and enterprise cloud adoption initiatives. Based in Columbus, Ohio, Girish works at a tech-forward fintech company. He is passionate about AWS serverless architectures, Generative AI and emerging cloud technologies. An avid learner and builder, he continues to explore and apply the latest innovations in AWS to help organizations accelerate their digital transformation. https://www.linkedin.com/in/girishbhatia/[https://www.linkedin.com/in/girishbhatia/](https://www.linkedin.com/in/girishbhatia/) **THANK YOU** *Franklin University* for hosting our meetup! To learn more about *Franklin University*, please visit their website: https://www.franklin.edu/ **DIRECTIONS** Franklin University Fisher Hall 300 E. Main St, Columbus, OH 43215 Map: https://maps.app.goo.gl/jxjBA2hUmS5qrvhq8 Parking is FREE! Please park in Lot C in front of Fisher Hall. See attached map. NOTE: Map the address only. When mapping with Google Maps it may use the Fisher Hall at OSU, which is NOT correct. **Want to sponsor the pizza and/or bar tab?** Please contact me if you would like to sponsor this meetup's pizza and/or bar tab: angelo@mandato.com

One of the most valuable parts of this community is the opportunity to think out loud with other product professionals. This session is built for exactly that. As we wrap up the quarter, it’s a great time to pause and reflect. What’s on track? What needs adjustment? Where could a small shift create bigger impact? Join fellow product professionals for a focused, interactive conversation designed to help you recalibrate for the next quarter. You’ll have the opportunity to share where you are, hear how others are thinking through similar challenges, and gain fresh perspective you can bring back to your team and organization. We’ll gather at 8:00AM, with discussion starting promptly at 8:15AM. 📍 First Watch - 7227 N High St Located in: The Shops at Worthington Ample parking is available. Food and beverages will be available for purchase. Start your morning with clarity and connection — we hope to see you there! ☀️

The Forge does have a full bar and kitchen. There is no cover charge but they do request all attendees to purchase a minimum of ~$20 per person. Soft drink refills are $1 each. Please support our hosts so we can continue to provide great events for the group! The Forge has a large library of games available for us to enjoy. Hosts and regulars will also provide numerous popular games but please bring any games you would like to teach and/or play. Doors open at 6, and we expect gaming to be rolling by around 630. Please promptly end your games and clear out the space at 10pm when the bar closes. We encourage socializing but do not permit disruptive behavior of any kind. Thank you for your continued commitment to providing a fun and welcoming space to veteran, newbie, and rookie gamers in the Columbus area. Parking can be challenging. There is a parking lot behind the neighboring Mexican restaurant that is free and easy to walk from but it's a bit hidden.

**Important time note:** Please plan on arriving between 5:30 and 6:00 as the elevators lock after 6 and you'll need to message us and we'll need to come get you. The building address is 4450 Bridge Park The entrance is 6620 Mooney St, Suite 400 **Abstract** TBD **YouTube Link** TBA

Window functions have nothing to do with the Windows operating system but provide a “window” to a result set when used in SQL queries. They are powerful, set-based methods to view data in unexpected ways. Window functions provide easy, set-based solutions to solve some common problems: * Using running totals * Performing operations in intervals * Identifying data gaps and islands * Performing aggregates without losing detail Many people are confused by window functions and do not know how to use them properly. This session will explore window functions, how they work, and how to use them. Demonstrations with several examples will solidify how window functions can simplify queries and make them more powerful.