Document & Diagram Downloads:

Checklists:

    Checklist for Finalizing a Data Model in Power BI Desktop (V2 as of 12/27/2017)

Diagrams:

   Data Lake Zones (V2 as of 4/8/2018)

   Virtualized Queries in Azure (V1 as of 4/8/2018)

   Power BI End-to-End Features <--A new version is currently in progress-available soon


Presentation Info & Slides:

Tips for Getting Started with the Azure Data Platform

This session is packed with practical tips and lessons learned about using Azure as a database platform. You will learn the fundamentals about how Azure is structured to help you make architectural decisions. Ideas will be shared for planning resource groups, naming conventions, and the separation of Dev, Test, and Prod. We will discuss database platform options, data storage options, and why PowerShell and ARM are so important to deployment scenarios. Cost-saving techniques and cloud efficiencies will be discussed as well.

Level: Introductory

Slides: Tips for Getting Started with Azure  

Recording: Tips for Getting Started with Azure from PASS Summit 2017 (1hr 15 min) - recorded Oct 2017

Target Audience: Database developers and DBAs who are looking for a primer on the Azure platform

Presented At: 


Selecting a Data Warehousing Technology in Azure

There are numerous choices in the Azure platform to implement a data warehouse for supporting analytical, big data, and business intelligence workloads. In this session we will talk through reference architectures for common scenarios, beginning with relational choices for traditional data warehousing, progressing to non-relational and composite architectures to support modern data warehousing and analytical environments. We will bring clarity to when Azure SQL Data Warehouse really is the best choice, versus when another Azure service may be a more suitable solution. Practical suggestions to inform your decision-making process will be shared throughout the session.

Level: Intermediate (some exposure to Azure concepts is beneficial for attendees, but not required)

Slides: Selecting a Data Warehousing Technology in Azure  

Recording: Selecting a Data Warehousing Technology in Azure (56 minutes) - recorded Jan 2018

Target Audience: Technologists who are looking to understand data platform choices in Azure for DW workloads.

Presented At:


Architecting a Data Lake      (full day workshop)

This full-day session will focus on principles for designing and implementing a data lake. There will be a mix of concepts, lessons learned, and technical implementation details. This session is approximately 70% demonstrations: we will create a data lake, populate it, organize it, query it, and integrate it with a relational database via logical constructs. You will leave this session with an understanding of the benefits and challenges of a multi-platform analytics/DW/BI environment, as well as recommendations for how to get started.

Target audience: Technologists who are considering or beginning a data lake implementation. No data lake experience is required. Familiarity with a relational database such as SQL Server is helpful, as some of the scenarios discussed will focus on integrating a data lake with a relational data warehouse.

You will learn in this session:

  • Scenarios and use cases for expanding an analytics/DW/BI environment into a multi-platform environment which includes a data lake

  • Methods for planning & organizing a data lake which focuses on optimal data retrieval and data security

  • Determining when to use Azure Data Lake Analytics (U-SQL) vs. HDInsight vs. Azure Databricks vs. relational functionality for data processing

  • Deciding between Azure Blob Storage vs. Azure Data Lake Store vs. a relational platform for data storage

  • Use cases and syntax basics for U-SQL, PolyBase, and elastic queries

  • Benefits and challenges of schema-on-read vs. schema-on-write approaches for data integration and on-demand querying needs

Specific technologies discussed and/or demonstrated in this session include:

Azure Data Lake Store  |  Azure Data Lake Analytics  |  HDInsight  |  Azure Databricks  |  U-SQL |

Azure SQL Data Warehouse  |  PolyBase  |  Azure SQL Database  |  Elastic Queries  |  Azure Storage

If you have an Azure account and your own laptop, you will be able to follow along during the demonstrations if you'd like. Demo scripts will be provided with the workshop materials.

Presented At:


Azure Data Lake: What, Why, and How

We will explore the capabilities of Azure Data Lake, and use cases for implementation. Options for integration of the data lake with SQL Server, Azure SQL DW, Azure SQL DB, and Azure Blob Storage will be discussed, as well as the role of U-SQL and PolyBase in a multi-platform system. You will leave this session with suggestions for getting started with Azure Data Lake Store and Azure Data Lake Analytics.

Level: Introductory

Slides: Azure Data Lake - What, Why, and How

Presented At:


Designing a Modern Data Warehouse + Data Lake

Join us for a discussion of strategies and architecture options for implementing a modern data warehousing environment.  We will explore advantages of augmenting an existing data warehouse investment with a data lake, and ideas for organizing the data lake for optimal data retrieval. We will also look at situations when federated queries are appropriate for employing data virtualization, and how federated queries work with SQL Server, Azure SQL DB, Azure SQL DW, Azure Data Lake, and/or Azure Blob Storage.

Level: This is an intermediate session suitable for attendees who are familiar with data warehousing fundamentals.

Slides: Designing a Modern DW + Data Lake <--Slides last updated March 2017

Presented At:


Fundamentals of Designing a Data Warehouse

In this session we will review sensible techniques for developing a data warehousing environment which is relevant, agile, and extensible. We will cover practical dimensional modeling fundamentals and design patterns, along with when to use techniques such as partitioning or clustered columnstore indexes in SQL Server. We'll also review tips for using a database project in SQL Server Data Tools (SSDT) effectively. The session will conclude with tips for planning the future growth of your data warehouse. 

Level: This is an introductory session best suited to attendees who are new to data warehousing concepts.

Slides: Fundamentals of Designing a DW <--Slides last updated February 2017

Presented At:

  • SQL Malibu User Group, San Fernando Valley, CA - Feb 15, 2017
  • Pearl Hacks, Chapel Hill, NC - Feb 11, 2017 (an informal workshop/whiteboarding version of this presentation)
  • SQL Saturday BI Edition, Atlanta, GA - Dec 10, 2016 (under previous title: Good Habits of a DW Developer)

    Presentation Archives:

    Note that older archives with outdated information and/or older technologies have been removed from this archive.

    The What, Why, and How of Collecting Telemetry Data

    To better understand SentryOne usage patterns and deliver maximum value to our customers, release 11.2 now anonymously collects telemetry data on an opt-in basis. In this session, we will show actual examples of telemetry data collected, as well as an overview of the technical implementation to send, ingest, store, and analyze this data. We will also share key observations so far from the data.

    Level: Introductory

    Target Audience: SentryOne customers

    Presented At:


    Building Blocks of Cortana Intelligence Suite in Azure

    Join us for a practical look at the components of Cortana Intelligence Suite for information management, data storage, analytics, and visualization. Purpose, capabilities, and use cases for each component of the suite will be discussed. If you are a technology professional who is involved with delivering business intelligence, analytics, data warehousing, or big data utilizing Azure services, this technical overview will help you gain familiarity with the components of Cortana Intelligence Suite and its potential for delivering value.

    Level:  A fast-moving introductory session

    Target Audience: Technology professionals seeking to gain a high level understanding of the capabilities of the Cortana Intelligence Suite

    Slides: Building Blocks of Cortana Intelligence Suite <--Slides last updated April 2017

    Presented At:


    Tales from Building a SQL Server Data Warehouse in Azure

    In this session, we share our experiences and lessons learned from a recent migration to Azure for a SQL Server data warehousing environment. We begin with sharing our reasoning for IaaS vs. PaaS, our carefully-selected naming conventions, and how we structured development, test, and production within subscriptions and resource groups. We cover the what, why, and how for decisions around storage, encryption, and backups. Finally, the session wraps up with a brief discussion of the use of Azure Resource Manager (ARM) templates and PowerShell, as well as techniques for monitoring the environment in Azure.

    Level:  A fast-moving introductory session

    Slides: Tales from Building a SQL Server DW in Azure <--Slides last updated August 2017

    Target Audience: Technology professionals responsible for creating and managing resources in Azure

    Presented At: