Jonathan Stewart

Jonathan Stewart

Jonathan Stewart aka SQLLocks, Principal Consultant

Columbus, Ohio, United States

Actions

Jonathan Stewart is a dynamic analytics consultant and visionary leader with over 25 years championing enterprise-scale data strategy and transformation. As Principal Consultant, Jonathan pioneers the launch of new practice areas, forges C-suite partnerships, and architects modern data warehouse and Power BI ecosystems for Fortune 500 organizations. His expertise empowers businesses to harness real-time insights, accelerate decision-making, and drive measurable revenue growth.

A recognized educator and community advocate, Jonathan is a frequent global speaker, technical trainer, and blogger at sqllocks.net, dedicated to democratizing analytics knowledge. He has presented on advanced analytics, cloud data platforms, and leadership in technology at conferences, user groups, and webcasts worldwide. Jonathan also serves as a board member for the Columbus SQL Server User Group and collaborates with local nonprofit and public sector leaders to expand technology access and career opportunities for underserved communities.

Jonathan’s technical focus spans the Microsoft Data Platform (Power BI, Azure, SQL Server), modern data warehouses including Databricks and Snowflake ecosystems, governance frameworks, data visualization, and analytics process automation. His leadership has been instrumental in launching innovative data practices, guiding cross-functional teams, and establishing standards for security and analytics excellence across industries including healthcare, manufacturing, government, and financial services.

In his free time, Jonathan advises regional planning boards and youth organizations, inspiring the next wave of technology leaders in central Ohio and beyond.

Badges

  • Most Active Speaker 2024

Area of Expertise

  • Information & Communications Technology

Topics

  • Microsoft Power BI
  • Data Visualization
  • Data Visualization Tools
  • Microsoft SQL Server
  • Azure SQL DB
  • Azure SQL Database
  • Azure Synapse Analytics (formerly Azure SQL DW)
  • Azure SQL Synapse
  • Leadership development
  • Technical Leadership
  • Leadership and Presentation Skills
  • IT Leadership
  • Databricks
  • Snowflake
  • Modern Data Warehouse
  • Data Strategy & Leadership
  • Fabric
  • Microsoft Fabric
  • Power BI / Fabric
  • Fabric Data Warehouse
  • Microsoft Fabric Analytics
  • Microsoft Fabric Data Engineering
  • MS Fabric

Relationship Goals: The SQL Server Graph Database

Relational databases have their strengths. Ironically data relationships are not one of them. Graph databases excel in this department using nodes and edges. They are optimized to find and view relationships using graph theory.

One of the best new features of SQL Server 2017 is the Graph Database! It brings us the best of both worlds in one easy platform! Come learn about the history of graph databases, how they work and why you should be using it!

Build the Semantic Model on Data That Doesn't Exist Yet

The report's gorgeous in dev. The visuals snap, the relationships behave, every measure totals up clean. Then it meets production volume and the slicers crawl. A relationship you trusted turns out to be many-to-many. Direct Lake quietly falls back to DirectQuery while nobody's watching. Your 5,000 polite dev rows were hiding all of it. So how do you catch that before go-live, when you can't even see production?

Because you can't just pull production down to test against. Compliance said no, and compliance is right. Masking feels like the escape hatch, but it can scramble the very cardinality and skew your model breaks on. So you end up testing against a problem you accidentally edited out. Mask the data and you mask the bug.

That's why I built Spindle.

It's an open-source, schema-aware synthetic engine, and it drops relationally correct tables straight into OneLake as Delta. You get production cardinality, real relationships, honest skew, and the dirty edge cases.

What you don't get is a single customer row or a shred of PII. 500,000 rows across 9 tables in under 3 minutes, Direct Lake ready. So you design the measures, load-test the relationships, and watch the model behave under real shape and scale, all before the first real record exists. When the production data finally lands, what surprise is left? You've already met its twin.

You'll leave with a profile-encode-generate workflow you can run against your own tenant this week, the demo's Spindle config and Fabric notebook in a public GitHub repo you can fork today, and a checklist for the model failures that tiny, clean dev data always hides.

AI at the Gates: The DBA’s Guide to Surviving in an LLM World

You don't need a PhD in data science to make generative AI useful in your database work. But you do need a plan, and that's what this session delivers. This full-day training is designed specifically for database administrators and developers who want to move beyond the hype and learn how to put generative AI to work in their daily roles.

We begin with a practical foundation in how generative AI works using terms data professionals already understand. Then, we lay out the case in favor of using generative AI solutions in your job. From there, we survey the current tooling landscape, from built-in Copilot features in SQL Server Management Studio and VS Code to standalone AI assistants, with an honest look at what works, what doesn’t, and what’s coming next.

The heart of the session dives into two tracks: administration and development. DBAs will learn about vector indexes, hybrid search patterns, and the operational considerations of managing AI-augmented workloads. Developers will explore pair programming with AI, prompt engineering, and leveraging MCP servers for contextual development assistance. We will conclude with a demonstration on building your own AI-powered tools, including standing up an MCP server and vibe coding your first solution. That way, you can leave with the skills and confidence to bring generative AI into your workflow on Monday morning.

A gentle introduction to to CI/CD in Power BI

Let's talk source control and Power BI!

We will discuss multiple ways to configure Power BI for continuous integration and delivery using DevOps, Deployment Pipelines, and other tips and tricks to ensure your successful deployment!

Difinity Conference - Melbourne - 2026 Sessionize Event Upcoming

December 2026 Auckland, New Zealand

Difinity Conference - Auckland - 2026 Sessionize Event Upcoming

December 2026 Auckland, New Zealand

PNW Day of Data 2026 Sessionize Event

November 2026 Vancouver, Washington, United States

Michigan Technology Conference 2026 Sessionize Event

October 2026 Rochester, Michigan, United States

Day of Data St. Louis Sessionize Event

October 2026 St. Louis, Missouri, United States

Boston Data and AI Saturday 2026 Sessionize Event

October 2026 Burlington, Massachusetts, United States

Day of Data SLC 2026 Sessionize Event

September 2026 Salt Lake City, Utah, United States

Difinity Conference - Toronto - 2026 Sessionize Event

September 2026 Toronto, Canada

Fabric NYC User Group User group Sessionize Event

August 2026 New York City, New York, United States

Power BI Days DC 2026 Sessionize Event

June 2026 Arlington, Virginia, United States

Scenic City Summit 2026 Sessionize Event

June 2026 Chattanooga, Tennessee, United States

Raleigh Day of Data 2026 Sessionize Event

May 2026 Durham, North Carolina, United States

Day of Data Jacksonville 2026 Sessionize Event

May 2026 Jacksonville, Florida, United States

SQLBits 2026 Sessionize Event

April 2026 Newport, United Kingdom

SQL Saturday Atlanta 2026 - AI & BI Sessionize Event

March 2026 Alpharetta, Georgia, United States

Data Saturday Chicago 2026 Sessionize Event

March 2026 Palatine, Illinois, United States

DataTune 2026 Sessionize Event

March 2026 Nashville, Tennessee, United States

Data Saturday Oslo 2025 Sessionize Event

August 2025 Oslo, Norway

Data Saturday Columbus 2025 Sessionize Event

August 2025 Westerville, Ohio, United States

SQL Saturday Baton Rouge 2025 Sessionize Event

July 2025 Baton Rouge, Louisiana, United States

SQL Saturday Austin 2025 Sessionize Event

May 2025 Austin, Texas, United States

Low Code/ No Code Power Platform Conference Sessionize Event

November 2024

SQLSaturday Pittsburgh Sessionize Event

October 2024 Homestead, Pennsylvania, United States

Data Saturday Columbus 2024 Sessionize Event

August 2024 Westerville, Ohio, United States

SQL Saturday Baton Rouge 2024 Sessionize Event

July 2024 Baton Rouge, Louisiana, United States

SQL Saturday RVA 2024 Sessionize Event

May 2024 Richmond, Virginia, United States

Data Saturday Phoenix 2024 Sessionize Event

March 2024 Phoenix, Arizona, United States

DataTune 2024 Sessionize Event

March 2024 Nashville, Tennessee, United States

SQL Saturday Atlanta 2024 - BI & Data Analytics Sessionize Event

February 2024 Alpharetta, Georgia, United States

SQL Saturday Costa Rica Sessionize Event

April 2023 San José, Costa Rica

Data Insight Summit Sessionize Event

September 2022 Chicago, Illinois, United States

SQLGrillen 2018 Sessionize Event

June 2018 Lingen, Germany

Jonathan Stewart

Jonathan Stewart aka SQLLocks, Principal Consultant

Columbus, Ohio, United States

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top