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.
Area of Expertise
Topics
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
Difinity Conference - Auckland - 2026 Sessionize Event Upcoming
PNW Day of Data 2026 Sessionize Event
Michigan Technology Conference 2026 Sessionize Event
Day of Data St. Louis Sessionize Event
Boston Data and AI Saturday 2026 Sessionize Event
Day of Data SLC 2026 Sessionize Event
Difinity Conference - Toronto - 2026 Sessionize Event
Fabric NYC User Group User group Sessionize Event
Power BI Days DC 2026 Sessionize Event
Scenic City Summit 2026 Sessionize Event
Raleigh Day of Data 2026 Sessionize Event
Day of Data Jacksonville 2026 Sessionize Event
SQLBits 2026 Sessionize Event
SQL Saturday Atlanta 2026 - AI & BI Sessionize Event
Data Saturday Chicago 2026 Sessionize Event
DataTune 2026 Sessionize Event
Data Saturday Oslo 2025 Sessionize Event
Data Saturday Columbus 2025 Sessionize Event
SQL Saturday Baton Rouge 2025 Sessionize Event
SQL Saturday Austin 2025 Sessionize Event
Low Code/ No Code Power Platform Conference Sessionize Event
SQLSaturday Pittsburgh Sessionize Event
Data Saturday Columbus 2024 Sessionize Event
SQL Saturday Baton Rouge 2024 Sessionize Event
SQL Saturday RVA 2024 Sessionize Event
Data Saturday Phoenix 2024 Sessionize Event
DataTune 2024 Sessionize Event
SQL Saturday Atlanta 2024 - BI & Data Analytics Sessionize Event
SQL Saturday Costa Rica Sessionize Event
Data Insight Summit Sessionize Event
SQLGrillen 2018 Sessionize Event
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