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 TimeKeller 3-210 - Room: Keller 3-210Keller 3-115 - Room: Keller 3-115Keller 3-125 - Room: Keller 3-125Keller 3-180 - Room: Keller 3-180Rapson 43 - Room: Rapson 43Rapson 45 - Room: Rapson 45Rapson 54 - Room: Rapson 54Rapson 56 - Room: Rapson 56
07:30 AMSQLSaturday 238

Registrations

Level: Non-Technical
       
09:00 AMPeter Myers

Big Data Analytics with PowerPivot and Power View

Level: Intermediate

download
Paul Codding

Hadoop on Windows

Level: Intermediate

download
Ed Leighton-Dick

Service Broker: The Queue Continuum

Level: Intermediate

download
Jim Dorame

PowerShell and SQLPSX the Dynamic Duo for the DBA

Level: Intermediate

download
Merrill Aldrich

Shoveling Frogs into a Wheelbarrow

Level: Intermediate

download
Larry Toothman

Yesterday I Couldn’t Even Spell ‘DBA’.

Level: Beginner

download
Ross McNeely

Self-Service Roles and Responsibilities

Level: Beginner
Steve Hughes

Beyond Power Pivot - Building Tabular Model Solutions

Level: Intermediate
10:30 AMPeter Myers

Mastering the CUBE Functions in Excel 2013

Level: Beginner

download
Lara Rubbelke

Big Data in the Cloud with HDInsight

Level: Advanced

download
Eric Selje

Unit Testing Fundamentals

Level: Beginner

download
Paul Timmerman

Database Snapshots - Making Your Job Easier

Level: Beginner
Neil Hambly

SQL Server 2012 Memory Management

Level: Intermediate
Ben Thul

Back(up) to Basics

Level: Beginner

download
Steve Hughes

Power to the User: a look at Power BI

Level: Beginner
Mark Vaillancourt

MDX Trek: First Contact

Level: Intermediate

download
11:45 AMSQL Saturday

Women In Technology Panel

Level: Non-Technical
  SIOS Technology

High Performance SANLess Clustering

Level: Beginner
    
12:45 PMWilliam Weber

They Say We Shouldn't, But Let’s Do It Anyway – Ad

Level: Advanced

download
Mark Vaillancourt

DANGER: The Art and Science of Presenting

Level: Beginner

download
David Valentine

T-SQL: Simple Changes That Go a Long Way

Level: Beginner

download
Jason Strate

Managing SQL Server Performance with Extended Events

Level: Intermediate
Neil Hambly

Why are we Waiting..

Level: Advanced
Gill Rowley

You're THE DBA. Now What?

Level: Beginner

download
Greg Beaumont

Take Your Data Global with Microsoft BI Data Explorer, GeoFlow, and Power View Maps

Level: Beginner

download
Russ Loski

Introduction to BIML and BIMLScript

Level: Intermediate

download
02:15 PMEric Ness

Data Mining Deep Dive: Clustering

Level: Advanced

download
David Bermingham

Deploying Highly Available SQL Servers in the Amazon EC2 Cloud

Level: Intermediate
Tracy McKibben

Subqueries for Superheroes

Level: Beginner

download
Rick Krueger

Temporary Objects Without Permanent Consequences

Level: Beginner

download
Merrill Aldrich

Eureka! Visual deep dive into storage internals

Level: Intermediate

download
Eric Zierdt

Table Partitions for Archiving

Level: Intermediate

download
Anton Rozenson

Data cleansing life cycle with Data Quality Services in SQL 2012

Level: Beginner
Terry Bunio

Agile Data Warehouse - The final frontier

Level: Intermediate

download
03:45 PMRuss Loski

SSRS data driven subscription using SSIS

Level: Advanced

download
Jeff Prom

When Scripting Worlds Collide: PHP + SQL Server

Level: Beginner

download
Jim Horn

T-SQL: How to create a million sample people

Level: Intermediate

download
Kirby Richter

Implement a Dynamic Table Partitioning Solution

Level: Intermediate

download
Tim Plas

Data Migration Between SQL Servers

Level: Beginner

download
Mark Knutson

The care and feeding of your adolescent SQL Server.

Level: Beginner

download
Jason Horner

Dimension Modeling Design Patterns: Beyond Basics

Level: Intermediate
Ira Whiteside

(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your Own

Level: Intermediate
05:00 PMSQLSaturday 238

Raffle

Level: Non-Technical
       


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
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your OwnIra WhitesideIntermediate
10 Ways To Abuse T-SQLTracy McKibbenBeginner
A Data Driven ETL Test FrameworkTerry BunioIntermediate
A SQL Server by Any Other NameTim PlasIntermediate
Agile BI with SQL Server 2012Mark SkilesBeginner
Agile Data Warehouse - The final frontier Terry BunioIntermediate
Agile Database DevelopmentAaron KingIntermediate
An Optimistic Approach: Snapshot Isolation in SQL Paul TimmermanIntermediate
Around the BI World with PowerMapJeff PromBeginner
Authentication with KerberosTim PlasIntermediate
Back(up) to BasicsBen ThulBeginner
Beyond Power Pivot - Building Tabular Model SolutionsSteve HughesIntermediate
Big Data Analytics with PowerPivot and Power ViewPeter MyersIntermediate
Big Data in the Cloud with HDInsightLara RubbelkeAdvanced
Break it up! Implement Table PartitioningKirby RichterIntermediate
Contained Databases, the what, why and WhereJim DorameBeginner
Creating a Metadata Mart w/ SSIS - Data GovernanceIra WhitesideIntermediate
Creating an SSIS FrameworkJames PhillipsIntermediate
Creating an SSIS template using BIMLRuss LoskiIntermediate
DANGER: The Art and Science of PresentingMark VaillancourtBeginner
Data cleansing life cycle with Data Quality Services in SQL 2012Anton RozensonBeginner
Data Migration Between SQL ServersTim PlasBeginner
Data Mining Deep Dive: ClusteringEric NessAdvanced
Data Models - Why SQL Scripts aren't enoughTerry BunioIntermediate
Database Snapshots - Making Your Job EasierPaul TimmermanBeginner
Delivering Self-Service BI with PowerDan EnglishIntermediate
Deploying Highly Available SQL Servers in the Amazon EC2 CloudDavid BerminghamIntermediate
Dimension Modeling Design Patterns: Beyond BasicsJason HornerIntermediate
Dimensional Data Modeling PrimerTerry BunioBeginner
Effective Index Partitioning, Compression StrategyNeil HamblyIntermediate
Eureka! Visual deep dive into storage internalsMerrill AldrichIntermediate
Flipping Through the SSIS CatalagMike DonnellyIntermediate
Hadoop on WindowsPaul CoddingIntermediate
High Performance SANLess ClusteringSIOS TechnologyBeginner
Implement a Dynamic Table Partitioning SolutionKirby RichterIntermediate
Introduction to BIML and BIMLScriptRuss LoskiIntermediate
Introduction to SQL Server 2012 MDS and DQSPeter MyersIntermediate
Introduction to SQL Server Data MiningPeter MyersIntermediate
Introduction to the XML sourceRuss LoskiIntermediate
Leverage your Enterprise Data by Integrating Open Data using PowerPivotMark SkilesBeginner
Managing SQL Server Performance with Extended EventsJason StrateIntermediate
Mastering the CUBE Functions in Excel 2013Peter MyersBeginner
MDS and DQS - Beyond the TLAs to Data QualityNeil HamblyBeginner
MDX Trek: First ContactMark VaillancourtIntermediate
Mission Critical Confidence – (SQL 2012 AlwaysOn) and Availability GroupsMark SkilesIntermediate
Power to the User: a look at Power BISteve HughesBeginner
PowerShell 101Merrill AldrichBeginner
PowerShell and SQLPSX the Dynamic Duo for the DBAJim DorameIntermediate
Protecting SQL Data for Availability and DRTim PlasIntermediate
Requirements Documents, Ellicitation, and AnalysisJim HornBeginner
Self-Service Roles and ResponsibilitiesRoss McNeelyBeginner
Service Broker: The Queue ContinuumEd Leighton-DickIntermediate
Shoveling Frogs into a WheelbarrowMerrill AldrichIntermediate
SQL Server 2012 AlwaysOn Step-by-StepDavid BerminghamIntermediate
SQL Server 2012 Memory ManagementNeil HamblyIntermediate
SSRS and SharePoint - There and Back againTerry BunioBeginner
SSRS data driven subscription using SSISRuss LoskiAdvanced
Subqueries for SuperheroesTracy McKibbenBeginner
Table Partitions for ArchivingEric ZierdtIntermediate
Tabular BI Semantic Model - What? When? Where? Why? How? William WeberIntermediate
Take Your Data Global with Microsoft BI Data Explorer, GeoFlow, and Power View MapsGreg BeaumontBeginner
Temporary Objects Without Permanent ConsequencesRick KruegerBeginner
The care and feeding of your adolescent SQL Server.Mark KnutsonBeginner
They Say We Shouldn't, But Let’s Do It Anyway – AdWilliam WeberAdvanced
T-SQL: How to create a million sample peopleJim HornIntermediate
T-SQL: Simple Changes That Go a Long WayDavid ValentineBeginner
Unit Testing Fundamentals Eric SeljeBeginner
Using PowerPivot to Drive Quality into ETL ProcessesSteve HughesIntermediate
Visualizing Your Data with Microsoft Power ViewDan EnglishBeginner
When Scripting Worlds Collide: PHP + SQL ServerJeff PromBeginner
Why are we Waiting..Neil HamblyAdvanced
Women In Technology PanelSQL SaturdayNon-Technical
Yesterday I Couldn’t Even Spell ‘DBA’.Larry ToothmanBeginner
You're THE DBA. Now What?Gill RowleyBeginner


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.

SQLSaturday Home
PASS