Schedule

Here is our schedule for the upcoming event. We've done our best to provide a good mix of topics and skill levels, we hope you'll find something of interest throughout the day. Our thanks to the speakers listed below for volunteering their time, we couldn't do it without them. If there are schedule changes we will make them here as they happen. We encourage you to check back a few days before the event just in case we have had to move one of your favorite sessions.

Note: Some speakers alternately upload their sessions to their own blog sites, which you can locate their site when you click on their session below.

Start TimeAPP DEV - Room: IRN 123APP DEV / DBA - Room: IRN 125Azure Big Data Prof Dev - Room: IRN 131BIA - Room: IRN 126BIA / BID - Room: IRN 219BID - Room: IRN 128DBA - Room: IRN 120DBA/BIA - Room: SC140-144BIA / DBA - Room: IRN 129
08:30 AMRobert Miller

Secret life of windowing functions

Level: Intermediate

download
Vern Rabe

The Significance of Choosing and Using Data Types

Level: Intermediate

download
Stacia Misner

A Big Data Primer

Level: Beginner

download
Carlos Bossy

Enterprise Tabular Models

Level: Beginner
Brad Baker

Data Quality Services and SSIS

Level: Intermediate

download
Paul Turley

Visualization Choices: What, When, and How?

Level: Beginner

download
Mark Halstead

PowerShell for the SQL Server DBA

Level: Beginner
Ryan McCauley

Introduction to SQL executions plans

Level: Intermediate

download
 
09:45 AMJoseph Vertido

Global Address Data: Storage and Verification

Level: Intermediate
Colin Smith

Intermediate Powershell for the DBA

Level: Intermediate
Shannon Lowder

OnPremise to Azure

Level: Intermediate
Jeff Renz

Data Vault Data Warehouse Architecture

Level: Intermediate
Russ Burns

PowerPivot and Power View for the Business Analyst

Level: Beginner

download
Nate Locklin

Spatial Data in SQL Server Reporting Services

Level: Beginner

download
Chris Shaw

Interview Tips

Level: Beginner

download
Andrew Duclos

SQL Server Data Tools Tips and Tricks

Level: Intermediate
William E Pearson III

Getting Started with MDX: The (Very) Basics

Level: Beginner
11:00 AMJosh Sivey

Unit Testing your SQL Server database using tSQLt

Level: Intermediate

download
Randy Knight

But it worked great in Dev! Perfomance for Devs

Level: Beginner

download
Kat Meadows

How to manage a Team of Technical Professionals

Level: Non-Technical
Kevin Boles

Indexing Deep Dive

Level: Advanced

download
Reeves Smith

Master Data Services – 101

Level: Beginner

download
Paul Turley

Use a custom assembly to extend reports & queries

Level: Advanced

download
Dave Pettengill

Virtualizing Business Critical SQL Servers

Level: Advanced

download
Matt Smith

Designing SSAS for performance and scalability.

Level: Intermediate

download
Kathy Gibbs

Extend your Knowledge with Extended Events

Level: Intermediate

download
1:30 PMJoseph Vertido

Matching and Survivorship

Level: Intermediate
Kevin Boles

File IO Stalls and Wait Stats - Tune Like Guru!

Level: Advanced

download
Dave Pettengill

A Heart ot Heart with the Business User

Level: Beginner

download
William E Pearson III

Possible Musics: SSAS Multidimensional vs Tabular

Level: Intermediate
Stacia Misner

Taking BI to the Next Level: Collaboration

Level: Intermediate

download
Orion Gebremedhin

MDX For Reporting

Level: Advanced
Chris Shaw

"What is the Best Disaster Recovery Solution?"

Level: Intermediate

download
Martin Schoombee

The 10 Commandments of ETL

Level: Beginner

download
Vern Rabe

Columnstore Indexes in SQL Server 2012

Level: Advanced

download
2:45 PMRobert Miller

You got an OVER clause in my SQL.

Level: Intermediate

download
Brian Flynn

Pivoting Performance Data & Pinpointing Problems

Level: Advanced

download
Scott Klein

Cloud Database Scalability with SQL Federation

Level: Intermediate
Carlos Bossy

Predictive Modeling with SQL Server Data Mining

Level: Intermediate
Russ Burns

Why SSRS/SharePoint Integration Is Worth The Pain

Level: Beginner

download
Phil Robinson

Report Delivery - From Report Manager to the Cloud

Level: Intermediate
Kathy Gibbs

Best Practices for Monitoring Databases on VMware

Level: Intermediate

download
Jeff Renz

Tabular Models

Level: Beginner
Randy Knight

Understanding Transaction Isolation Levels

Level: Intermediate

download
4:00 PMColin Smith

Delphix Agile Data Management

Level: Beginner
 Scott Klein

Kung Fu Migration to Windows Azure SQL Database

Level: Intermediate
Orion Gebremedhin

SSAS 2012 Dynamic Security in Tabular Models

Level: Intermediate
 Josh Sivey

SSRS – Implementing a Rendering Extension

Level: Advanced

download
Kat Meadows

Case studies of Disaster Recovery

Level: Intermediate
Kevin Boles

Common TSQL Mistakes

Level: Intermediate

download
Reeves Smith

Get Into Evaluation Context with DAX, the Language of PowerPivot

Level: Advanced

download


Submitted Sessions

Here is the list of sessions submitted so far. Our goal is to feature as many different speakers and topics as possible, but space limitations prevent us from accepting every session. This list is also a great way for those thinking about speaking to see what might be on the agenda and enter a session that doesn't collide with an existing one.

TitleSpeakerLevel
"What is the Best Disaster Recovery Solution?"Chris ShawIntermediate
14 New T-SQL FunctionsSam NasrIntermediate
A Big Data PrimerStacia MisnerBeginner
A Heart ot Heart with the Business UserDave PettengillBeginner
Advanced SQL Server Integration ServicesJeff RenzAdvanced
Beginning Powershell for the DBAColin SmithBeginner
Best Practices for Monitoring Databases on VMwareKathy GibbsIntermediate
Bridging the Chasm: BI Theory vs. PracticeWilliam E Pearson IIIBeginner
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Case studies of Disaster RecoveryKat MeadowsIntermediate
Cloud Database Scalability with SQL FederationScott KleinIntermediate
Columnstore Indexes in SQL Server 2012Vern RabeAdvanced
Common TSQL MistakesKevin BolesIntermediate
Data Quality Services and SSISBrad BakerIntermediate
Data Vault Data Warehouse ArchitectureJeff RenzIntermediate
Delphix Agile Data ManagementColin SmithBeginner
Designing SSAS for performance and scalability.Matt SmithIntermediate
Dive into the Query Optimizer-Undocumented InsightBenjamin NevarezAdvanced
Documenting Your Integrated Microsoft BI SolutionWilliam E Pearson IIIIntermediate
Enterprise Tabular ModelsCarlos BossyBeginner
Extend your Knowledge with Extended EventsKathy GibbsIntermediate
File IO Stalls and Wait Stats - Tune Like Guru!Kevin BolesAdvanced
Full-Text Search in SQL 2012 with Custom ProximitySam NasrIntermediate
Get Into Evaluation Context with DAX, the Language of PowerPivotReeves SmithAdvanced
Getting Started with MDX: The (Very) BasicsWilliam E Pearson IIIBeginner
Global Address Data: Storage and VerificationJoseph VertidoIntermediate
How to manage a Team of Technical ProfessionalsKat MeadowsNon-Technical
Indexing Deep DiveKevin BolesAdvanced
Indexing Deep Dive Kevin BolesAdvanced
Intermediate Powershell for the DBAColin SmithIntermediate
Interview TipsChris ShawBeginner
Introduction to Spatial DataRuss BurnsBeginner
Introduction to SQL executions plansRyan McCauleyIntermediate
Introduction to SSIS 2012Sam NasrIntermediate
Introduction to Tabular and PowerPivotReeves SmithBeginner
Kung Fu Migration to Windows Azure SQL DatabaseScott KleinIntermediate
Kung Fu Migration to Windows Azure SQL DatabaseScott KleinIntermediate
LT: But I Want BI NOWWWWPaul TurleyLightning Talk
Many–to -Many: Multiple Calendars in a Single CubeWilliam E Pearson IIIIntermediate
Master Data Services – 101Reeves SmithBeginner
Matching and SurvivorshipJoseph VertidoIntermediate
MDX For ReportingOrion GebremedhinAdvanced
OnPremise to AzureShannon LowderIntermediate
Pivoting Performance Data & Pinpointing ProblemsBrian FlynnAdvanced
Possible Musics: SSAS Multidimensional vs TabularWilliam E Pearson IIIIntermediate
PowerPivot and Power View for the Business AnalystRuss BurnsBeginner
PowerShell for the SQL Server DBAMark HalsteadBeginner
Predictive Modeling with SQL Server Data MiningCarlos BossyIntermediate
Quick and Dirty Website to Monitor DB PerformanceGabriel VillaBeginner
Report Delivery - From Report Manager to the CloudPhil RobinsonIntermediate
Scripting Timesavers and Productivity UtilitiesGabriel VillaBeginner
Secret life of windowing functionsRobert MillerIntermediate
Secret life of windowing functionsRobert MillerIntermediate
Spatial Data in SQL Server Reporting ServicesNate LocklinBeginner
SQL Server 2012 TSQL Enhancements and AdditionsKevin BolesIntermediate
SQL Server Data Tools Tips and TricksAndrew DuclosIntermediate
SQL Server Maintenance PlansKat MeadowsBeginner
SQL Server Performance tuning basicsMark HalsteadBeginner
SSAS 2012 Dynamic Security in Tabular Models Orion GebremedhinIntermediate
SSRS – Implementing a Rendering ExtensionJosh SiveyAdvanced
Tabular ModelsJeff RenzBeginner
Taking BI to the Next Level: CollaborationStacia MisnerIntermediate
The 10 Commandments of ETLMartin SchoombeeBeginner
The Significance of Choosing and Using Data TypesVern RabeIntermediate
Top Query Optimizer Topics for Better PerformanceBenjamin NevarezIntermediate
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Unit Testing your SQL Server database using tSQLtJosh SiveyIntermediate
Use a custom assembly to extend reports & queriesPaul TurleyAdvanced
Using FiletablesSam NasrIntermediate
Using Statistical Semantic SearchSam NasrAdvanced
Virtualizing Business Critical SQL ServersDave PettengillAdvanced
Visualization Choices: What, When, and How?Paul TurleyBeginner
Why SSRS/SharePoint Integration Is Worth The PainRuss BurnsBeginner
Windows Azure SQL Database - your cloud databaseScott KleinBeginner
You got an OVER clause in my SQL.Robert MillerIntermediate


Suggested Sessions

Thinking about participating as a speaker but no ideas for the topic? Often our attendees will have an idea for you! Or, submit a suggestion of your own.

Suggested Session TitleSkill Level
SQL Server Data Tools Tips and TricksIntermediate

SQLSaturday Home
PASS