22-25 April 2026

Jason Horner

Hi, my name is Jason I'm a Independent consultant and trainer focused on the Azure Data Platform. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I'm fluent in several languages including: SQL, C#, Python, and PowerShell. I'm a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being previously awarded the Most Valuable Professional (MVP) for the 6 years. I'd love to speak at your upcoming event or user group don't hesitate to email me or reach out on linkedIn or twitter. In my off hours I like to snowboard, karaoke, ride roller coasters and play arcade games

Jason Horner's Sessions

Dimensional Modeling from Zero to HeroSQLBits 2022

Dimensional modeling is arguably one of the most important fundamentals of business intelligence. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes.

Seven Synapse ChallengesSQLBits 2022

Are you ready to test your ability to master the seven synapse challenges? This exciting, informative and unique full day hands on workshop pairs attendees up in groups to solve a set of common scenarios.

A Head First dive into Azure Synapse Analytics Data Explorer PoolsSQLBits 2022

This session shows you how to unlock insights in your log and telemetry using Azure Synapse Analytics Data Explorer Pools.

Azure SQL Monitoring FundamentalsSQLBits 2022

Migrating you on-premises Database to Azure SQL DB was easy but now comes the hard part how do you setup monitoring and alerts?

Azure Synapse Analytics Picking the Right PoolSQLBits 2022

This session covers the main uses cases for each of the Azure Synapse Analytics Pools: Spark, Dedicated SQL, Serverless SQL and Data Explorer.

Azure Data Lake Design PatternsSQLBits 2020

Data lakes have been around for years yet there is still much hype and hyperbole surrounding their use. This session goes beyond corny puns and broken metaphors and instead provides real-world guidance.

Azure Data Factory Deep DiveSQLBits 2019

This immersive full day hands on session will arm you with all the skills you need to build and orchestrate pipelines using Azure Data Factory v2 that solve both traditional data integration problems, real-time, and complex event processing.

Data Lake Design PatternsSQLBits 2019

Data lakes have been around for several years and there is still much hype and hyperbole surrounding their use. This session covers the basic design patterns and architectural principles.

Dimensional Modeling: Beyond the BasicsSQLBits 2018

In this session, we will dive deeper into the art of dimensional modeling. We will identify the different types of fact tables and dimension tables and also review approaches to creating rich hierarchies that simplify complex reporting.

Dimensional Modeling: From Zero to HeroSQLBits 2017

In this session, we will first understand the basics of dimensional modeling. Then we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables.