Jason Horner

Information & Communications Technology

Business & Management

Azure Azure Analysis Services Azure Data Factory Azure Data Catalog Azure Data Lake Azure Synapse Analytics power bi PowerShell Dimensional modeling GeoSpatial Data Azure DevOps Azure SQL Managed Instance Microsoft SQL Server SQL

Denver, Colorado, United States

Jason Horner

Global Thought Leader and International Man of Leisure

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


Book a meeting https://calendly.com/jjhconsulting

Current sessions

Azure SQL Monitoring Fundamentals

Migrating you on-premises Database to Azure SQL DB was easy but now comes the hard part how do you setup monitoring and alerts? While there are many 3rd party options what comes standard with Azure, how can you be sure your azure SQL Database isn't under or over allocated, so that your costs are optimize d. How can you project what future costs maybe. What tools from your on-premises sql server toolkit will still work and what new capabilities exists. Join this session to ensure you are getting the most out of your Azure SQL database monitoring.


Real World Production Data Pipelines with Apache Spark

You’ve decided to build your first Apache Spark solution, or perhaps you have already built out a proof of concept. Maybe you already have a significant background using Spark on-premises and are looking to migrate to the cloud. How can you ensure that the solution you deliver will be easy to extensible, easy to maintain, and efficient and secure? In this session, we will look at many of the best practices for designing robust production data pipelines in the cloud using spark. Regardless of whether you are using Azure Synapse Analytics or Azure Databricks this session will help understand the use cases and best practices for working with Apache Spark. Along the way, we'll cover operational areas like DevOps, alerting and monitoring, performance tuning, and managing costs.


Join The Spark Side: Spark Sql

Want to get started with data transformation but feel left out because you don't know Python or Scala? This session is for you! We will learn how to author notebooks to perform basic transformation, cleansing, and data enrichment using the familiar SQL Language you already know from the relational world. Specific topics include: windowing functions and CTE's, interreacting with Delta lake tables and Basic DML and DDL Operations. Along the way we will cover the basics of notebooks, Hive Metastore integration, and using Spark SQL in the new SQL Analytics Preview.


Every day I'm shuffling: Improving query performance in Azure Synapse Analytics

They said the query performance would make you lose your mind. Instead, your query performance has suffered since moving to Azure Synapse Dedicated Pools. In this demo heavy session, we will cover the basics of effective MPP table design, including table distribution choices such as round-robin, hash, and replicated. We will also learn to how to interpret DSQL query plans and how to understand some common causes of underperforming queries in a MPP Environment including data movement, data skew and over partitioning.
Attend this session and make sure you and your Synapse Dedicated Pool queries have a good time.


Event Driven ETL With Synapse Pipelines

In this session, we will look at how to use synapse pipeline to orchestrate event driven data pipelines in Azure Synapse. Along the way we will cover basic flow control, metadata driven pipelines, and techniques for securely storing secrets in azure key vault.


The 7 Habits of Highly Effective Data Warehouses

Many Data Warehouses fail to live up to the business user's expectations. Data Warehouses can suffer from a variety of problems including distrust in the data, Taking too long to implement

slow performance, and lack of discoverability. In this session, we explore the seven habits that will help ensure that your data warehouse is used and loved by end-users.


Real-World Data Movement and Orchestration Patterns using Azure Data Factory

In this session, we will start with an overview of Azure Data Factory concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution.
Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.


Real-World Azure Data Lake Design and Implementation patterns for success

A poorly designed data lake can be hinder adoption and cause limitless frustration to end users. Come join Jason and as he unlocks the secrets to a well-designed data lake.


ARM Yourself: A beginners guide to using ARM Templates

The cloud provides agility but if you are manually creating resources via the portal or even if you are using PowerShell you may not be taking advantage of the best way to deploy resources to Azure. ARM Templates take a declarative approach that is critical for implementing repeatable and automated deploys. Leveraging ARM templates can move you from a DevOps Dreamer to a DevOps Doer.


Azure Analytics Platform Quickstart

Are you struggling to get your analytics and data projects started on Azure? Overwhelmed by where to start or which services to choose? This hands-on session is for you. We will start with a brief overview of the Azure platform, followed by a complete guide through getting an environment set up. Along the way
, we'll answer your questions, talk about specific pitfalls and decisions, and ensure you are able to continue to build on your newly acquired knowledge.


Dimensional Modeling Design Patterns: Beyond Basics

This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.notepad++


Jason On JSON

JSON is all around us in the systems we use every day. Many systems use it for configuration, data interchange and logging. SQL server 2016 introduced native support for JSON, but when should we use this new capability? and how can we ensure optimal performance? Join Microsoft Master of SQL Server Jason Horner as we look at the basics of JSON and how to query, transform, and store it. Whether you are working with a data warehouse or transactional processing system working with sql server on premises or in the cloud. This session will get you up to speed.


Back the Truck Up: Data Loading Design Patterns for Azure Synapse Analytics

Azure Synapse Analytics recently released to much fanfare but just what makes this right platform for your data loading and processing? Is the whole greater than the sum of its parts? This session will cover a brief overview into the basic components and synapse architectural concepts. We then look at code-free ETL orchestration and how to work with the embedded spark engine directly. Along the way, we also cover some of the best practices around table design and data cleansing, enrichment and loading.


A Head First Dive Into Azure Synapse Sql Serverless Pools

Do you need to build a logical data warehouse, explore data, or perform large scale transformations on CSV JSON or Parquet stored in Azure Storage as part of your ETL / ELT process? This session is for you.

Serverless SQL pools are a new On-demand query service over the data in your data lake. It enables you to access your data through the existing tools and the robust T-SQL language you are using today. Since it is a scalable and elastic serverless, pay as you go service, it scales to meet your needs at a low cost. 

Learn how to leverage the power of serverless pools to help solve your toughest data exploration and transformation challenges.


Intro to Azure Data Factory

In this session, we will start with an overview of Azure Data Factory concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution.
Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.


Azure Synapse Analytics Deep Dive

Azure Synapse Analytics was released to much fanfare but just what makes this right platform for your enterprise data warehouse? Is the whole greater than the sum of its parts? This full day deep dive session will cover a brief overview into the basic components and synapse architectural concepts we then look at code-free ETL orchestration and how to work with the embedded spark engine directly. Along the way, we will also cover some of the key operational features such as workload management, advanced security, and networking. Finally we look at analytic capabilities possible with Power BI and Azure Machine Learning integrations that will enable you to have a true end to end modern data warehouse
Whether you are a Data Engineer, Data Scientist, or Database administrator This session is everything you to be able to build a modern data warehouse based on Azure Synapse Analytics.


Building Incremental Data Pipelines Using Azure Data Factory

One of the most common and challenging problems in Data Engineering is how to efficiently and accurately detect changed data. In the cloud, relying on a full load pattern can be both time consuming and costly. In this session we will look at some common design patterns for detecting and loading new and updated data using Azure Data Factory. Along the way we will also explore some common techniques to make pipelines more dynamic and add additional auditing and logging.


Past and future events

SQL & Azure SQL Conference Fall 2021

7 Dec - 9 Dec 2021
Las Vegas, Nevada, United States

Azure Analytics Platform Quickstart @ Southlands PASS

Are you struggling to get your analytics and data projects started on Azure? Overwhelmed by where to start or which services to choose? This hands-on session is for you. We will start with a brief overview of the Azure platform, followed by a complete guide through getting an environment set up. Along the way
, we'll answer your questions, talk about specific pitfalls and decisions, and ensure you are able to continue to build on your newly acquired knowledge.
19 Aug 2021

Into to ADF @ BostonBI

In this session, we will start with an overview of Azure Data Factory V2 concepts, then show you how you can use metadata to quickly build scalable server less pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution.

Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
14 Jul 2021
Boston, Massachusetts, United States

Intro to ADF @ Arizona Data Platform Users Group

In this session, we will start with an overview of Azure Data Factory concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution.
Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
9 Jun 2021

The 7 Habits of Highly Effective Data Warehouses @ Sacramento SQL Server User Group

The 7 Habits of Highly Effective Data Warehouses - Jason Horner

Many data warehouses fail to live up to the business user's expectations. Data warehouses can suffer from a variety of problems including distrust in the data, taking too long to implement, slow performance, and lack of discoverability. In this session, we explore the seven habits that will help ensure that your data warehouse is used and loved by end-users.
4 Jun - 6 Jun 2021

Azure Analytics Quickstart @ PASS MN

Are you struggling to get your analytics and data projects started on Azure? Overwhelmed by where to start or which services to choose? This hands-on session is for you. We will start with a brief overview of the Azure platform, followed by a complete guide through getting an environment set up. Along the way, we'll answer your questions, talk about specific pitfalls and decisions, and ensure you are able to continue to build on your newly acquired knowledge.
16 Feb 2021
Minneapolis, Minnesota, United States

SQLBITS 2020 - Azure Data Lake Design Patterns

presented talk on Azure Data Lake
12 Nov - 14 Nov 2020

Colorado Springs SQL User Group

presented Jason on JSON
11 Nov 2020

SLC SQL Server Users Group - Azure Data Factory Overview

presenting an overview of Azure Data Factory
15 Oct 2020

SLC SQL Server Users Group - Azure Analytics Quickstart

presented Azure Analytics quickstart session
17 Sep 2020