Advanced SQL Server

The Fellowship of the Star Schema: Transforming OLTP Data for Power BI One does not simply build reports on OLTP data. Join us on an epic journey from the depths of raw, normalized tables to the shining halls of a well-modeled star schema fit for Power BI greatness. We will demystify the differences between OLTP and OLAP, walk through star schema vs snowflake (and why Power BI has a clear favorite), and show you the compression differences between normalized and columnar storage that will make you never look at an OLTP model the same way again. We will cover the different types of dimensions, when to use them, and how to handle Slowly Changing Dimensions without losing your mind. You will leave knowing exactly how to identify a bad model, how to convert OLTP data into a clean star schema, and how to forge relationships that rule them all. Whether you are a data wizard, a curious hobbit, or somewhere in between, your models will never be the same.

The April Ohio North Database Training user group meeting will be held on **April 7th, 2026 at 5:00PM**. This will be a **HYBRID** event and we will be joined online by **Kayla Boor**. 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/meet/22562814501129?p=w1cSxeUXFTVeIpZiMw)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 **Accidental friends: How a DBA and an SRE worked together to optimize the system.** This session is focused on how to communicate effectively between teams to improve alert fatigue, performance, and observability. \*\*NEW SPEAKER \*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.

**Presenter:** All of Us **Time:** Pizza at 6:00, Presentation Starts at 6:30pm Eastern **Location:** Theoris, 9000 Keystone Crossing, Suite 230, Indianapolis Let's have a fishbowl discussion about AI. Has it replaced you yet? Have you replaced it? Somewhere in between? How is AI impacting your career as a software engineer? Looking forward to seeing you there! ### What is a Fishbowl Discussion? [A ](https://www.bing.com/ck/a?!&&p=00b4b265baa395dc4ad7b262d4d6e3b7b7c31b2195941076e51d2eca252c2d02JmltdHM9MTc2MjgxOTIwMA&ptn=3&ver=2&hsh=4&fclid=0e60c23d-2dbf-642d-0fd7-d4512c2b6597&psq=fishbowl+discussion&u=a1aHR0cHM6Ly9lbi53aWtpcGVkaWEub3JnL3dpa2kvRmlzaGJvd2xfKGNvbnZlcnNhdGlvbik&ntb=1)**[fishbowl discussion](https://www.bing.com/ck/a?!&&p=00b4b265baa395dc4ad7b262d4d6e3b7b7c31b2195941076e51d2eca252c2d02JmltdHM9MTc2MjgxOTIwMA&ptn=3&ver=2&hsh=4&fclid=0e60c23d-2dbf-642d-0fd7-d4512c2b6597&psq=fishbowl+discussion&u=a1aHR0cHM6Ly9lbi53aWtpcGVkaWEub3JnL3dpa2kvRmlzaGJvd2xfKGNvbnZlcnNhdGlvbik&ntb=1)**[ is a structured format for dialogue that typically involves two groups: an inner circle (the "fishbowl") and an outer circle. The inner circle consists of a small number of participants who actively discuss a topic, while those in the outer circle listen and observe. This format encourages participation from all members, as individuals from the outer circle can join the inner circle by taking an empty seat when they wish to contribute.](https://www.bing.com/ck/a?!&&p=00b4b265baa395dc4ad7b262d4d6e3b7b7c31b2195941076e51d2eca252c2d02JmltdHM9MTc2MjgxOTIwMA&ptn=3&ver=2&hsh=4&fclid=0e60c23d-2dbf-642d-0fd7-d4512c2b6597&psq=fishbowl+discussion&u=a1aHR0cHM6Ly9lbi53aWtpcGVkaWEub3JnL3dpa2kvRmlzaGJvd2xfKGNvbnZlcnNhdGlvbik&ntb=1)

The global Azure community is coming together again, and Columbus is officially on the map. View the session lineup and speakers at [Global Azure Columbus 2026](https://coazure.github.io/cbus-global-azure-2026/) On **Saturday, April 18, 2026**, the Azure Columbus Meetup, DevOps Meetup, and Code and Coffee Meetup are hosting our local edition of Global Azure 2026. This is a free, community-driven event packed with learning, networking, and all things Microsoft Azure. Whether you’re building modern cloud-native apps, experimenting with AI agents, deploying containers, automating infrastructure, or just beginning your Azure journey, this event is for you! **What to Expect** * Engaging technical sessions * Real-world Azure architecture & cloud-native patterns * AI, agents, automation, and modern DevOps * Food and drinks (because learning burns calories) * Time to connect with fellow engineers, architects, and cloud enthusiasts **Who Should Attend?** * Software engineers (any language, any stack) * Cloud architects * DevOps engineers * Data professionals * AI explorers * Platform builders * Anyone who loves solving hard problems with great tools If you build, deploy, automate, scale, monitor, or optimize in Azure, you’ll feel right at home. **Why Global Azure?** Global Azure is a worldwide community event where Azure user groups host learning sessions on the same day across the globe. It’s grassroots. It’s technical. It’s practical. And it’s powered by people who genuinely love sharing what they’ve learned. And yes, it’s free to attend!

Pay attention! We’re delaying a week for those of you who may be on Spring break and/or celebrating the holiday. Ok, no pancakes, but waffles-a-plenty. Join the local UX and Digital Design community for a casual monthly breakfast. Look for us upstairs!

http://photos2.meetupstatic.com/photos/event/2/a/9/6/600_348310902.jpeg Instructor - Crow, HPS Class fee is $30 at the door or approved exchange RSVP with Advance pay of $25 (discounted) by PayPal on the web or by contacting Enchanted Elements (614) 437-2642. Reservations made directly to Enchanted Elements will be added to the class list manually not online. Private Instruction ~ Closed to the Public ~ Initiated Members Only Please come prepared for ritual. Blessings ~ Crow