jasonhorner

<!-- This script supplied by Bill Anton http://byobi.com/blog/2013/06/extended-events-for-analysis-services/ -->
<Create
	xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2"
	xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2"
	xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100"
	xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200"
	xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300">
	<ObjectDefinition>

jasonhorner

<Delete xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Object>
    <TraceID>MyTrace</TraceID>
  </Object>
</Delete>

jasonhorner

<#

useful oneliners

#>

jasonhorner

-- Useful TSQL Scripts

jasonhorner

Azure Data Lake Design Patterns Resources

This page has the resources for my Azure Data Lake Design Patterns talk.

Abstract

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.

jasonhorner

Azure Data Factory Design Patterns Resources

This page has the resources for my Azure Data Factory Design Patterns talk.

Abstract

jasonhorner

Sessionize

Be sure to checkout my sessions on sessionize https://sessionize.com/jason-horner

Recorded Sessions

Below is a list of sessions I have given that have been recorded:

jasonhorner

Dimensional Modeling Resources

This page has the resources for my Dimensional Modeling talk.

Abstract

jasonhorner

jasonhorner

Set-ExecutionPolicy Bypass -Scope Process -Force; iex ((New-Object System.Net.WebClient).DownloadString('https://chocolatey.org/install.ps1'))

choco install chocolatey -y

choco install git.install -y
choco install git-credential-manager-for-windows -y
choco install github -y
choco install gh -y
#@choco install git-fork -y