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 TimeTrack 1 - Room: Room 213Track 2 - Room: Room 212Track 3 - Room: Room 211Track 4 - Room: Room EBC
08:30 AMKathi Kellenberger

SQL Server 2012 T-SQL

Level: Intermediate

download
David Klee

Database Health and Performance

Level: Intermediate

download
Eric Zierdt

Table Partitions for Archiving and Performance

Level: Intermediate

download
Eric Ness

Data Mining Deep Dive: Clustering

Level: Advanced

download
10:00 AMAaron King

A Complete BI Solution in About an Hour!

Level: Beginner

download
Michael DeFehr

Deadlocks: What to do about the dreaded 1205

Level: Intermediate

download
Jes Borland

Index Options You're Not Using

Level: Intermediate

download
Terry Bunio

How to install and configure SSRS 2012/Sharepoint

Level: Beginner

download
12:15 PMJim Dorame

PowerShell and SQLPSX the Dynamic Duo for the DBA

Level: Intermediate

download
Mike Donnelly

Flipping Through the SSIS Catalag

Level: Intermediate

download
Kathi Kellenberger

T-SQL Analytic Functions

Level: Intermediate

download
Scott Shaw

The Future of the DBA

Level: Beginner

download
01:45 PMJason Horner

Dimension Modeling Design Patterns: Beyond Basics

Level: Intermediate
Paul Timmerman

An Optimistic Approach: Snapshot Isolation in SQL

Level: Intermediate

download
Steve Jones

The Encryption Primer

Level: Beginner

download
Ross McNeely

F# for Data Analysis

Level: Intermediate
03:15 PMJes Borland

The What, Why, and How of Filegroups

Level: Intermediate

download
Steve Hughes

Building BI Solutions with Excel 2013

Level: Beginner

download
Jason Strate

Discovering the Plan Cache

Level: Intermediate
Jeff Prom

Data Quality Services

Level: Beginner

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
A Complete BI Solution in About an Hour! Aaron KingBeginner
A Window into Your Data: Using SQL Window FunctionSteve HughesBeginner
Agile Data Warehouse - The final frontier Terry BunioIntermediate
An Optimistic Approach: Snapshot Isolation in SQL Paul TimmermanIntermediate
Backups and Recoverability in SQL ServerMichael DeFehrIntermediate
Branding Yourself for a Dream JobSteve JonesBeginner
Building BI Solutions with Excel 2013Steve HughesBeginner
Creating Cube Driven ReportsJeff PromIntermediate
Data Mining Deep Dive: ClusteringEric NessAdvanced
Data Models - Why SQL Scripts aren't enoughTerry BunioIntermediate
Data Quality ServicesJeff PromBeginner
Database Health and PerformanceDavid KleeIntermediate
Deadlocks: What to do about the dreaded 1205Michael DeFehrIntermediate
Dimension Modeling Design Patterns: Beyond BasicsJason HornerIntermediate
Dimensional Data Modeling PrimerTerry BunioBeginner
Dimensional Modeling for the DBAScott ShawIntermediate
Discovering the Plan CacheJason StrateIntermediate
Extended Events, Work Smarter Not HarderJason StrateIntermediate
F# for Data AnalysisRoss McNeelyIntermediate
Flipping Through the SSIS CatalagMike DonnellyIntermediate
GROUP BY, grouping sets, CUBE, and ROLLUP Joe CelkoIntermediate
Hadoop for the SQL Developer/DBABill PreachukBeginner
How to install and configure SSRS 2012/SharepointTerry BunioBeginner
Implement Agile BI with SQL2012 Powerpivot/BISMDerek DaiIntermediate
Index Options You're Not UsingJes BorlandIntermediate
Index-fu - getting the most out of your indexesMichael DeFehrIntermediate
Make Your Voice Heard!Jes BorlandBeginner
Master Data ServicesJeff PromBeginner
MDX Trek: First ContactMark VaillancourtIntermediate
Nested Sets model of Trees & HierarchiesJoe CelkoIntermediate
O, There's My Data, OData for Data GuysSteve HughesIntermediate
Overview of PowerPivotDavid EichnerBeginner
Overview of PowerPivotDavid EichnerBeginner
PowerShell and SQLPSX the Dynamic Duo for the DBAJim DorameIntermediate
Prototyping Dimensional Models With PowerPivotEric NessIntermediate
Prototyping Dimensional Models With PowerPivotEric NessIntermediate
Query Plans and Indexes in SQL ServerMichael DeFehrBeginner
SQL Server 2012 T-SQLKathi KellenbergerIntermediate
SQL Server Data and Backup CompressionJes BorlandIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSIS CDC Tasks in SQL 2012Mike DonnellyBeginner
Table Partitions for Archiving and PerformanceEric ZierdtIntermediate
The Encryption PrimerSteve JonesBeginner
The Future of the DBAScott ShawBeginner
The What, Why, and How of Filegroups Jes BorlandIntermediate
Top-Down Data Modeling for BIRoss McNeelyBeginner
T-SQL Analytic FunctionsKathi KellenbergerIntermediate
TSQL Bullet-Dodging and Spoon-bendingMichael DeFehrIntermediate
Understanding SQL Server Master Data ServiceDerek DaiIntermediate
Unstructured Data in SQL ServerSteve JonesBeginner
Virtualizing Business Critical SQL ServersDavid KleeIntermediate
Virtualizing our EnvironmentRob MandevilleBeginner
What Are You Waiting For?Jason StrateIntermediate
XQuery Basics for the DBAJason StrateIntermediate


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
Drill Through Reporting using SSRSAdvanced

SQLSaturday Home
PASS