Advanced SQL Server

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.

The March Ohio North Database Training user group meeting will be held on **March 3rd, 2026 at 5:00PM**. This will be a **HYBRID** event and we will be joined in person by **Sam Nasr**. You're welcome to come meet in-person at our meeting location, the offices of Improving at **[6000 Freedom Square Dr,](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** **[Unit 110,](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** **[Independence, OH 44131](https://www.google.com/maps/place/Improving/@41.4004167,-81.6614462,17z/data=!3m2!4b1!5s0x8830e5b8255c5919:0xd8297060eb68fe04!4m6!3m5!1s0x8830dc7a0fe35dc9:0xbfc4710ecadfc5c!8m2!3d41.4004127!4d-81.6588713!16s%2Fg%2F1hm3hkqp3?entry=ttu&g_ep=EgoyMDI1MDQzMC4xIKXMDSoASAFQAw%3D%3D)** [Teams Link ](https://teams.microsoft.com/l/meetup-join/19%3ameeting_YTg3MTY3NzItODI3OS00MTRjLTgzYTItYTBlMjY5NTQ5MzU4%40thread.v2/0?context=%7b%22Tid%22%3a%22b966f302-6b93-4686-9041-c084635642c5%22%2c%22Oid%22%3a%2278c760cb-657f-46aa-bd2f-7066d9403bdb%22%7d)if anyone needs it after RSVP-ing for in person. If you would like to subscribe to our email list outside of Meetup, we have changed platforms recently and you will need to register [here in Kit ](https://ohio-north-data-training.kit.com/b8f036f615)instead to receive emails. Agenda: **5:00 PM EST**: Online and in-person meeting begins with a social hour. This is an unstructured hour where you can join us to catch up and meet other group members before the session starts. There will be food brought in for in-person attendees. **6:00 PM EST**: Updates and announcements, followed by our feature presentation. See below for presentation details. **7:30 PM EST**: Optionally after the main presentations, the in-person crowd may go out for snacks and drinks at a local establishment. We hope to see you there! Session Abstract ### **Data Cleansing using Data Bricks** Machine Learning is highly dependent on adequate data. Not only does quantity matter, but more importantly quality. In this session we’ll cover how to build a custom automated process using Data Bricks. This will provide methods for cleaning data in a data lake using functions in Azure. \*Please note, that we will be using Microsoft Teams for the online portion of this meeting. You may want to join a few minutes early to ensure you do not have any issues. If you are attending in person, there are large TVs at the office, and you do not need to bring a laptop or use Teams.

**Hello Columbus!** **The community is buzzing and growing well.** **We are thrilled to bring our third BrowserStack QA Meetup on March 12th!** We are creating a space for deeper insights, meaningful connections, and a vibe you won't want to miss. **What to expect:** * **Connect:** Network with Columbus' top engineering and QA minds. * **Learn:** Real-world tactics and trends you can use immediately. * **Enjoy:** Food, drinks, and great community spirit. **Agenda** * **[Sam Gomez](https://www.linkedin.com/in/samueljgomez/)** is presenting "AI is more than LLMs: Choosing the right AI for your needs." **RSVP Essential:** Space is limited, and we want to ensure a great experience for everyone. **RSVP now to secure your spot!** 📍 **Venue:** Leading EDJE, 6515 Longshore Loop, Suite 300, Dublin, OH 43017 📍 **Free Parking:** 6725 Longshore Street, Dublin, OH 43017 📅 **Date & Time:** March 12, 6:00 PM **Stay Connected!** Want to continue the conversation beyond the meetup? Join our **BrowserStack Discord Server** to get updates, connect with fellow QA professionals, and be part of an ongoing discussion. **Don’t miss out—click below to join!** 🔗 [\[](https://discord.gg/6SdCyWTNyW)**[Join the BrowserStack Discord Server](https://discord.gg/6SdCyWTNyW)**[\]](https://discord.gg/6SdCyWTNyW) **A Few Notes:** ✅ This is an **in-person event** ✅ **RSVP does not guarantee a seat** – A confirmation email will be sent one day before the event. **TALK ABSTRACT:** AI is all the hype these days; however, despite (or maybe because of) the excitement around it, a high percentage of AI projects fail. Projects that are over budget, delayed, or that fail to scale past the POC phase are very common. In many of these scenarios, choosing the right approach can be as critical as the solution itself. Should you build a tailored machine learning model, leverage the power of large language models (LLMs), or integrate with AI copilots? Each option has unique strengths, trade-offs, and resource requirements, and the key to success lies in aligning your choice with your business goals and technical constraints. In this talk, we will go beyond the basic concepts and definitions to provide a practical guide that allows attendees to navigate these decisions through real-world case studies. We will examine scenarios in which different AI paradigms were chosen, discuss the factors that influenced those decisions, and outline the process for evaluating needs, constraints, and outcomes. From assessing data availability and team expertise to balancing cost and scalability, you'll gain insights into the critical considerations that guide the selection process. By the end of this session, you’ll have a clear process for determining whether machine learning, LLMs, or copilots are best suited to your AI challenges and understand the resources and strategies needed to bring your chosen solution to life. This talk is ideal for decision-makers, technical leads, and innovators seeking to demystify AI implementation and maximize the impact of their investments.

We will show a variety of methods for building agents that run in Microsoft Foundry. This covers the different types of agents: Prompt, Multi, and Hosted, as well as the development lifecycle using evals and traces.

# **Band and caller TBA** Beginner lesson at 1:30, regular dancing begins at 2:00 pm NOTE THAT WE ARE TEMPORARILY DANCING IN THE AFTERNOON INSTEAD OF EVENING. Dance with us in the afternoon then you can still go out in the evening! **Sponsor: All Soles Contra and Square Dancing, First Unitarian Universalist Church, 93 W. Weisheimer Rd., Columbus OH 43214** WHAT IS CONTRA DANCING? Picture the Grand Ball scenes like you’ve seen in period films such as “Pride and Prejudice”, where the dancers are lined up in long lines, across from each other. That’s English Country Dancing, the predecessor of contra dancing. Now, add moves like “swing your partner” and “do-si-do,” like you’ve seen in square dancing. Set it to fabulous, high energy, live music with fiddles, guitars, percussion and more, alá “Riverdance.” Finally, set the whole scene down in the middle of Woodstock, with a hip, groovy atmosphere, a bit of tie-dye, and hints of counter-culture attitude. THAT’s Contra Dancing! Wear cool and comfortable clothes (you will get warm) and clean shoes that won't mark up our nice wood floor. Be sure to come for the beginner's lesson from 1:30 - 2:00, followed by dancing 2:00 - 430. All dances are taught; we will help you learn! Beginners always welcome, no need to bring a partner. Cost is $10.00 adults, $5.00 ages 12-26. Under 12 free. Free parking in church lot. Please bring your own refillable water bottle.

Join other experienced and aspiring agile coaches and professionals to: * develop and practice your coaching skills in a peer-to-peer environment * share current successes and challenges in your work environment and get support from each other * learn from each other, build better relationships and experiment with new ideas

Meeting @ Improving's office in Downtown Columbus, near Cosi. Parking is paid, food & drink are free! This time we're hanging out after the long winter break. We are going to look at a group-member's project used to help learn the fundamentals of Go, and if time allows, we can take a look at how we like to build Go projects using AI.