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 1Track 2 - Room: Room 2Track 3 - Room: Room 3Track 4 - Room: Room 4Track 5 - Room: Room 5
8:30 AMKeynote Keynote

Keynote

Level: Non-Technical
Keynote Keynote

Keynote

Level: Non-Technical
Keynote Keynote

Keynote

Level: Non-Technical
Keynote Keynote

Keynote

Level: Non-Technical
Keynote Keynote

Keynote

Level: Non-Technical
8:50 AMAJ Mendo

DBA Survival Guide: Daily Checklist and Server Monitoring

Level: Beginner

download
Leonard Lobel

Native File Streaming with SQL Server 2012

Level: Intermediate
Bill Fellows

Type More, Click Less: Programmatically build SSIS packages

Level: Advanced

download
Jason Kassay

Getting Started with Execution Plans

Level: Beginner

download
 
9:55 AMBen Miller

SMO Internals for High Performance PowerShell

Level: Intermediate
Rob Mandeville

Virtualizing our Environment

Level: Intermediate
Brent Greenwood

Faster & Leaner: Optimize DW Solution Delivery with Power Pivot and AS Tabular

Level: Intermediate
Trent Mera

SQL Server performance management

Level: Beginner
 
11:00 AMGlenn Berry

Dr. DMV's Troubleshooting Toolkit

Level: Intermediate
Michael Fal

Managing Log File Obesity

Level: Intermediate
Jason Horner

Advanced Spatial Analysis: Beyond Bubble Charts

Level: Advanced
Russ Thomas

XPath - XQuery; I guess if I HAVE to

Level: Beginner

download
 
1:00 PMJason Strate

Managing SQL Server Performance with Extended Events

Level: Intermediate
Seth Washeck

Back the Truck Up

Level: Intermediate
Doug Lane

SQL Server Murder Mystery Hour: Dead Reports Don't Talk

Level: Beginner
Rick Lowe

I Don't Know Which Queries Are Slow, Just Make All of Them Faster

Level: Intermediate
 
2:05 PMJohn Morehouse

SQL Server Databaseology 201: A Study of Database Internals

Level: Intermediate

download
Steve Jones

The Encryption Primer

Level: Beginner
Meagan Longoria

The Accidental Report Designer: Data Visualization Best Practices in SSRS

Level: Intermediate

download
Rob Schafer

Tabular Data Modeling and Visualizations

Level: Intermediate
 
3:20 PMCarlos Bossy

SQL Server Replication in Practice

Level: Beginner
tjay belt

Documentation – you know you love it

Level: Beginner

download
Michael Sexton

SSIS Logging Reconsidered

Level: Advanced
Steven Wake

Capture Change and Apply it With Change Data Capture & SSIS

Level: Intermediate

download
 
4:25 PMKeith Tate

The Curious Case of Isolation Levels

Level: Intermediate
Jeff Renz

Tabular Models

Level: Beginner
Reeves Smith

Master Data Services – 101

Level: Beginner
Thomas LaRock

Database Design: Size DOES Matter

Level: Intermediate
 


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
2012 TSQL SweetsBill FellowsIntermediate
5 Ways to Improve Performance through IndexingJason StrateIntermediate
A Date with a Super-Model… and other Data Model Best Practices for Power Pivot and Analysis ServicesBrent GreenwoodIntermediate
Advanced Processor Selection for SQL Server 2012/2014Glenn BerryBeginner
Advanced Spatial Analysis: Beyond Bubble ChartsJason HornerAdvanced
Analyzing I/O Subsystem PerformanceGlenn BerryIntermediate
Back the Truck UpSeth WasheckIntermediate
Backups & Restores: You're Not In Kansas Anymore!John MorehouseBeginner
Battle of the Finch BotsJeff RenzBeginner
Be Friendly to SQL Server with TSQL Best PracticesBen MillerBeginner
Branding Yourself for a Dream JobSteve JonesBeginner
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Capture Change and Apply it With Change Data Capture & SSISSteven WakeIntermediate
Common T-SQL Patterns Affecting SQL Server PerformanceJason StrateIntermediate
Critical Incident Debrief; Verbal Judo for the DBARuss ThomasNon-Technical
Dashboards - Introducing Pyramid AnalyticsJeff RenzBeginner
Data Vault Data Warehouse ArchitectureJeff RenzIntermediate
Data Warehousing Guidelines for BI and BAM solutionsShehap El-NagarAdvanced
Database Design: Size DOES MatterThomas LaRockIntermediate
Database Development with SQL Server Data ToolsLeonard LobelIntermediate
Database Monitoring : Trying To Keep Sanetjay beltBeginner
Database Release Management: Tips to help organize ittjay beltIntermediate
DBA Survival Guide: Building a Trouble Shooting MethodologyAJ MendoBeginner
DBA Survival Guide: Daily Checklist and Server MonitoringAJ MendoBeginner
DBA Survival Guide: Trouble Shooting With Wait StatisticsAJ MendoBeginner
Dimensional Modeling Design Patterns: Beyond BasicsJason HornerIntermediate
Dimensional Modeling Fundamentals: Top 5 Scenarios Where A Dump Table Won't Cut ItBrent GreenwoodIntermediate
Documentation – you know you love ittjay beltBeginner
Don’t fall victim to Little Bobby Tables: Guide to Developing a Secure Database ApplicationGabriel VillaIntermediate
Don’t Miss Out on Excel Cube FunctionsMeagan LongoriaBeginner
Dr. DMV's Troubleshooting ToolkitGlenn BerryIntermediate
ETL as MDMMichael SextonIntermediate
Extended Events In Real LifeSeth WasheckIntermediate
Faster & Leaner: Optimize DW Solution Delivery with Power Pivot and AS TabularBrent GreenwoodIntermediate
Geospatial Data Types in SQL Server 2012Leonard LobelIntermediate
Get Into Evaluation Context with DAX, the Language of PowerPivotReeves SmithAdvanced
Getting Started with Execution PlansJason KassayBeginner
I Don't Know Which Queries Are Slow, Just Make All of Them FasterRick LoweIntermediate
Increase your SSIS productivity with BimlReeves SmithIntermediate
KeynoteKeynote KeynoteNon-Technical
Managing Log File ObesityMichael FalIntermediate
Managing SQL Server Performance with Extended EventsJason StrateIntermediate
Master Data Services – 101Reeves SmithBeginner
Master the Date Dimension Like a Time LordSteven WakeBeginner
Monitoring Databases in a Virtual EnvironmentThomas LaRockIntermediate
Native File Streaming with SQL Server 2012Leonard LobelIntermediate
Only You Can Prevent Database Fires!John MorehouseBeginner
Performance dreams wait for you at SQL Server 2014Shehap El-NagarIntermediate
Performance Management Models in Power Pivot & TabularBrent GreenwoodIntermediate
Programming T-SQL Enhancements in SQL Server 2012Leonard LobelIntermediate
Query Tuning 101: This vs. ThatJason KassayBeginner
Recognizing the Parallel Data Warehouse (PDW) WorkloadJason StrateIntermediate
SMO Internals for High Performance PowerShellBen MillerIntermediate
SQL Server Databaseology 201: A Study of Database InternalsJohn MorehouseIntermediate
SQL Server Murder Mystery Hour: Dead Reports Don't TalkDoug LaneBeginner
SQL Server performance managementTrent MeraBeginner
SQL Server Replication in PracticeCarlos BossyBeginner
SQL Server TDEBen MillerIntermediate
SSIS 2012: More Than Just a Pretty UISteven WakeBeginner
SSIS Logging ReconsideredMichael SextonAdvanced
Strategies for SQL Server Index AnalysisJason StrateIntermediate
Tabular Data Modeling and VisualizationsRob SchaferIntermediate
Tabular ModelsJeff RenzBeginner
The Accidental Report Designer: Data Visualization Best Practices in SSRSMeagan LongoriaIntermediate
The Curious Case of Isolation LevelsKeith TateIntermediate
The Encryption PrimerSteve JonesBeginner
The Hierarchy of Monitoring Needs: A MethodologyMichael FalIntermediate
T-SQL Performance Guidelines for better DB stress powersShehap El-NagarAdvanced
Type More, Click Less: Programmatically build SSIS packagesBill FellowsAdvanced
Understanding the SQL Server Transaction LogRandy KnightBeginner
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Useful Dynamic Management Views besides the Handful You Already UseRick LoweIntermediate
Virtualizing our EnvironmentRob MandevilleIntermediate
Windows Azure SQL Database – SQL Server in the CloudLeonard LobelIntermediate
XEventaphobia: It's time to conquer your fearRuss ThomasBeginner
XPath - XQuery; I guess if I HAVE toRuss ThomasBeginner
Your First Week as a SQL Server DBASteve JonesBeginner


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