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

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 V2

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 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.


Data Lake Design Patterns

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 to make sure you are using the data lake and underlying technologies effectively. We will cover things like best practices for data ingestion and recommendations on file formats as well as designing effective zones and folder hierarchies to prevent the dreaded data swamp. We’ll also discuss how to consume and process data from a data lake. And we will cover the often overlooked areas of governance and security best practices. This session goes beyond corny puns and broken metaphors and provides real-world guidance from dozens of successful implementations in Azure.


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

Want to party at the lakehouse but can’t climb over the brick wall?  Do you need to explore data or perform large scale transformations on CSV JSON or Parquet stored in azure storage as part of your ETL / ELT process?Serverless SQL pools are a 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.


Past and future events

Arizona Data Platform Users Group: Intro to ADF

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

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

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

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