KSQL

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.

Bring your business cards and network in person with other business professionals! Gold Star Referral Clubs is one of the most established professional networking organizations in the country, with multiple groups in central Ohio. Join us!

Drake Lundstrom is presenting: Code Anywhere by Talking to your Phone Abstract: Have you heard the trend of people deploying code anywhere from checkout lines to doctors' offices? In this talk, you will learn how to talk to your phone and have an app on Azure to show your friend 5 minutes later. The basic DevOps tools you already know, plus a little bit of AI magic, are all you need! If you want to follow along, the demo will be in Azure with GitHub Actions and GitHub Copilot, and you can have it set up on your phone by the end of the session. Just come in with an Azure account and a GitHub repo. Join us for pizza, drinks, and networking @ Improving's office. Doors open at 5:45.

WQC has weekly Thursday night social nights at the Westerville Java Central. Come and grab a coffee and connect with the community: low stakes, chill environment, and tasty drinks. No registration is required; come as you are.

**New Dojo Location!** **Draft Day Columbus** 1130 Dublin Road Columbus, OH 43215 We're going to try a new dojo location for a few weeks and see how it works Dojos are informal Python group study sessions where everyone interested in Python gathers to learn about Python, help others with Python, or just hang out. Everyone is welcome from Python beginners to experts. Bringing a laptop is encouraged (we'll have extension cords and power strips). If there's something you want to learn leave a comment on this invite so we can plan ahead. We're looking for topic suggestions and people interested in presenting at our monthly meetings. To this end we've set up a survey form at [https://docs.google.com/forms/d/15eBKF1nQQ2XS5gzD4rvhVRHMBEj7lJtHuA9wXupS3Uc](https://docs.google.com/forms/d/15eBKF1nQQ2XS5gzD4rvhVRHMBEj7lJtHuA9wXupS3Uc)

A fun way to compare wines from two different countries at a time. House Wine is squaring off two countries' wines against each other each Thursday in March. March 12, March 19, March 26, and the Finals April 2nd. Meet and Greet format....show up after 7pm, pay your $15 at the cash register, get your wine glass, and enjoy. I will get a table reserved for the group. Remember, you may bring in your own food or takeout. Attendance is your agreement to the Group's Waiver of Liability terms. See our Group homepage for details. Parking is tough at House Wine; there is a municipal lot one-half block north of the shop and sometimes parking at the lot behind Jet Pizza, accessed by the lane between the east House Wine parking lot and the residence to the east.

**We are expanding our creative programming opportunities with Queer Quills, a quiet writing and sharing space. Queer Quills features some prompts, supplies and friendly faces to help get some inspiration or feedback for your writing. Hope to see you there!**

Columbus Code & Coffee is an inclusive, informal co-working session. People of all skill levels attend, and we love it that way. Many people (optionally) bring projects to work on, and many other people (optionally) socialize the entire time. It's entirely up to you! **What to Expect at the Intro Circle** \~\~\~\~\~\~\~\~\~\~\~\~\~ Near the beginning of the event (1:30 pm), we do a standup: * Organizer announcements, updates, and logistics Round 1 - (7 secs max): * Your name * What you're working on * What you can help others with Round 2: * Community events you wanna plug. If none, that's cool too. Round 3: * Job opportunities you're hiring for OR announce that you are looking for one. If none, that's cool. After the introduction circle, everything is self-organized! Feel free to work alone, pair up, attend one of our workshops/presentations, or mingle!

The Humanist Monthly Program is our longest running event and still a community favorite. In the old days it used to be called "Going to HCCO" and we still like to think of it as our flagship event. Food and drinks will be provided at the event. Feel free to show up a little bit early to hang out and talk. Our March speakers are Molly Gaines and Zack Parrish, co-organizers of the Secular Education Association: They will share their story of how a small group of Ohio parents grew into a national organization tracking released-time religious instruction and other church–state issues in public schools. The presentation will cover SEA’s early wins and hard lessons, what we’re seeing nationally right now, and how local advocates can play a meaningful role in protecting public education. Attendees will leave with a clearer understanding of the landscape — and practical ways to get involved. Going forward our meetings will be hybrid. You can meet us in-person or attend online Join Zoom Meeting [https://us02web.zoom.us/j/87836564953?pwd=4Mi57ElZkDIFlb1fnlNwOJ0NiOK4tP.1](https://us02web.zoom.us/j/87836564953?pwd=4Mi57ElZkDIFlb1fnlNwOJ0NiOK4tP.1) Meeting ID: 878 3656 4953 Passcode: 760812 One tap mobile +19292056099,,87836564953#,,,,\*760812# US (New York) +13017158592,,87836564953#,,,,\*760812# US (Washington DC) The formal presentation will start at noon

Early-bird coffee and conversation at [Crimson Cup Coffee Shop - Clintonville](https://www.crimsoncup.com/about/location/clintonville)!

Join us for a casual chat over coffee & tea at Porter’s Coffee House. Come out and meet some new people, enjoy your favorite drink, and make some new friends!

Join me at 3 for dining, at Cafe Istanbul, on Easton. Cafe Istanbul in Easton, Columbus, Ohio, is a Turkish and Mediterranean restaurant known for its authentic cuisine, including various kebabs (lamb, chicken, beef), falafel, and appetizers like Sigara Borek, served in a uniquely decorated setting reminiscent of old Istanbul. It offers a full bar, takeout, and reservations, with popular dishes like lamb shish kebab, doner kebab, and vegetarian options like moussaka. One thing this group doesn't seem to do a lot of is dine out. This is an opportunity for those that like to eat over a meal and connect to do so.

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

**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

Bring your business cards and network in person with other business professionals! Gold Star Referral Clubs is one of the most established professional networking organizations in the country, with multiple groups in central Ohio. Join us!

Builders, creators, architects, admins, consultants - come one, come all. This one's for you. We're bringing a little friendly competition to the Columbus ServiceNow community while highlighting the cool things people have built on the platform. Five presenters will take the stage to showcase something they've built, solved, designed, or imagined on the ServiceNow platform - and a panel of judges (plus YOU, our amazing audience) will score them live. So basically, America's Got Talent but make it ServiceNow's Got Talent. Bring a notepad if you'd like 'cause you'll definitely be learning something new. Each presenter gets 10 minutes max to wow the crowd with: • A demo • A real-world business solution • A bold idea • A UX transformation • Or a creative use of the platform Judging Criteria: 🏆 Business Value 🚀 Innovation ✨ User Experience This event is about celebrating ideas, sharing knowledge, and showing how ServiceNow can drive both business impact and meaningful user value. Come learn. Come support. Come get inspired. Refreshments and bites will be provided. And maybe next time… you’ll be on stage.