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 TimeB/I 1 - Presented by Slalom - Room: 220B/I 2 - Presented by Tek Systems - Room: Room-222B/I 3 - Room: Room-204DBA 1 - Presented by SIOS - Room: Room-106DBA 2 - Presented by Precise - Room: Room-107DBA 3 - Presented by Intellinet - Room: Room-113DBA 4 - Presented by Dell - Room: Room-216DBA 5 - Presented by Red Gate - Room: Room-213DBD 1 - Presented by Idera - Room: Room-212PowerShell - Room: Room-206Twelfth Track! - Room: Room-210Zero Level - Room: Room-205
09:00 AMPam Shaw

Tips & Tricks for dynamic SSRS Reports

Level: Beginner

download
Melissa Coates

So You Want To Be A Rockstar Report Developer?

Level: Intermediate
Yelena Pavlyuk

Report Builder: Reports made Easy.

Level: Beginner
Tim Radney

Know Backups and Know Recovery

Level: Intermediate

download
David Klee

Squeezing the Most Performance from your VMware-Based SQL Server

Level: Advanced

download
Jon Boulineau

T-SQL: Beyond the Basics

Level: Beginner

download
Stuart Ainsworth

Working with "Biggish Data"

Level: Beginner

download
Timothy McAliley

A Walk Around the SQL Server 2012 Audit Feature

Level: Intermediate

download
Dan Holmes

The Last Mile: Dynamically Created Objects

Level: Advanced

download
Mike Robbins

PowerShell Fundamentals for Beginners

Level: Beginner
Robert Cain

Off and Running with PowerPivot for Excel 2013

Level: Beginner
Mike Walsh

What I Wish I Knew Before Becoming a DBA

Level: Beginner
10:15 AMJason Thomas

GeoSpatial Analytics Using Microsoft BI

Level: Beginner

download
Paul Waters

Automating SSIS Development with Biml

Level: Beginner

download
Teo Lachev

Best Practices for Implementing an Enterprise BI Solution

Level: Advanced

download
Eddie Wuerch

Page Latches for Mere Mortals

Level: Advanced

download
Adam Machanic

5 Query Plan Culprits That Cause 95% of Headaches

Level: Advanced
Aaron Nelson

SQL Server Database Development with SSDT

Level: Intermediate

download
Joseph D'Antoni

Using Compression to Improve Database Performance

Level: Intermediate

download
Ben Miller

SQL Server TDE

Level: Intermediate

download
Chris Skorlinski

Enhanced Phone Interrogation

Level: Intermediate
Thomas Stringer

Managing Enterprise Environments with PowerShell

Level: Intermediate
Andy Leonard

Hacking the SSIS 2012 Catalog

Level: Beginner
Kevin Kline

Team Leadership Fundamentals

Level: Beginner

download
11:45 AMStacia Misner

Taking BI to the Next Level: Collaboration

Level: Intermediate

download
Bobby Dimmick

Jump-starting your career

Level: Beginner
 Dave Bermingham and Vin Prasad

High Performance SANLess Clustering

Level: Beginner

download
 Ed Wyatt

Insights to Better Team Management

Level: Non-Technical

download
 Louis Davidson

What counts for a DBA

Level: Non-Technical

download
    
01:00 PMThomas LeBlanc

Attributes & Hierarchies in Analysis Services 2012

Level: Intermediate

download
Andy Leonard

Using BIML as an SSIS Design Patterns Engine

Level: Advanced
Mark Tabladillo

Secrets of Enterprise Data Mining

Level: Intermediate

download
Denny Cherry

Storage for the DBA

Level: Advanced

download
Adam Machanic

5 Query Plan Culprits That Cause 95% of Headaches

Level: Advanced
Eric Peterson

High Availability with SQL Server 2012

Level: Intermediate

download
Steve Busby

SQL Server Parallel Data Warehouse 2012 Deep Dive

Level: Intermediate

download
Ryan Duclos

SQL Database (Windows Azure)

Level: Beginner

download
Tim Radney

You Inherited a Database, Now What?

Level: Beginner

download
Jim Christopher

Taming Complex Tasks with the Psake Module

Level: Beginner
Carlos Rodrigues

Data Warehouse physical design - better practices

Level: Intermediate

download
Geoff Hiten

Smart Rats Leave First

Level: Beginner
02:30 PMSven Aelterman

Managing the SQL Server 2012 SSIS catalog (SSISDB)

Level: Advanced

download
Leo Furlong

Expanding Self-Service BI with Excel 2013

Level: Beginner

download
William E Pearson III

Bridging the Chasm: BI Theory vs. Practice

Level: Beginner
Kevin Boles

TSQL Road Less Traveled: APPLY

Level: Advanced

download
Ed Watson

Backup Strategies are for Losers!

Level: Beginner

download
Tamera Clark

45 min to build your first SSRS report

Level: Beginner

download
Richie Rump

New T-SQL features in SQL Server 2012

Level: Intermediate

download
Blank Blank

This session left intentionally blank

Level: Non-Technical
Javier Guillen

DAX Formulas: Evaluation Context

Level: Advanced
Ben Miller

SMO Internals for High Performance PowerShell

Level: Advanced

download
Jason Thomas

Advanced Charting Techniques in SSRS

Level: Intermediate
Audrey Hammonds

Database Design for Beginners

Level: Beginner

download
03:45 PMJulie Smith

Matching with Data Quality Services

Level: Beginner

download
Mark Tabladillo

Applied Enterprise Semantic Mining

Level: Intermediate

download
Stacia Misner

Troubleshooting MDX Query Performance

Level: Advanced

download
Jennifer McCown

When a Strange Server Calls

Level: Beginner
Kevin Boles

TSQL Road Less Traveled: MERGE

Level: Intermediate

download
Louis Davidson

Database Design Fundamentals

Level: Intermediate

download
Denny Cherry

Using SQL Server 2012s Always On

Level: Intermediate

download
Blank Blank

This session left intentionally blank

Level: Non-Technical
Wes Brown

Storage Tuning Deep Dive

Level: Advanced
Jonathan Walz

PowerScripting Live! (PowerShell podcast / BoF)

Level: Beginner
Thomas LeBlanc

Using SSIS 2012 for ETL in a Data Warehouse

Level: Advanced

download
Robert Cain

The Decoder Ring for Data Warehousing / BI

Level: Beginner


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
"Versions of the truth" in the era of PowerPivotJavier GuillenIntermediate
45 min to build your first SSRS reportTamera ClarkBeginner
5 Query Plan Culprits That Cause 95% of HeadachesAdam MachanicAdvanced
A Big Data PrimerStacia MisnerBeginner
A Walk Around the SQL Server 2012 Audit FeatureTimothy McAlileyIntermediate
Advanced Charting Techniques in SSRSJason ThomasIntermediate
Applied Enterprise Semantic MiningMark TabladilloIntermediate
Attributes & Hierarchies in Analysis Services 2012Thomas LeBlancIntermediate
Automating SSIS Development with BimlPaul WatersBeginner
Backup Strategies are for Losers!Ed WatsonBeginner
Be Friendly to SQL Server with TSQL Best PracticesBen MillerBeginner
Best Practices for Implementing an Enterprise BI SolutionTeo LachevAdvanced
Bridging the Chasm: BI Theory vs. PracticeWilliam E Pearson IIIBeginner
Building Dashboards with the MS BI StackTeo LachevIntermediate
Case studies of Disaster RecoveryKat MeadowsIntermediate
Change Data Capture and the Real Time DWLuis FigueroaAdvanced
Characteristics of a Great Relational DatabaseLouis DavidsonBeginner
Concurrency in PowerShellJon BoulineauAdvanced
Configuring and Managing FILESTREAM and FileTableSven AeltermanIntermediate
Configuring SQL Server 2012 Reporting ServicesRobert CainIntermediate
Dashboard Do's and Don'tsStacia MisnerBeginner
Data Mining Innovation with SQL Server 2012Mark TabladilloAdvanced
Data Quality Services Approach to Cleansing Charles GaddyIntermediate
Data Warehouse physical design - better practicesCarlos RodriguesIntermediate
Database Design for BeginnersAudrey HammondsBeginner
Database Design FundamentalsLouis DavidsonIntermediate
Database Design Matters!Audrey HammondsIntermediate
Database Health and PerformanceDavid KleeIntermediate
Data-Driven reports for everyoneJose L. RiveraBeginner
DAX Formulas: Evaluation ContextJavier GuillenAdvanced
Designing for Common Problems in SQL Server Louis DavidsonIntermediate
Dimensional Model - Back to basics with extra tipsCarlos RodriguesIntermediate
Dimensional Modeling 101Thomas LeBlancIntermediate
Disk IO Tuning on Microsoft SQL ServerKevin KlineBeginner
Dive into the Query Optimizer-Undocumented InsightBenjamin NevarezAdvanced
Enhanced Phone InterrogationChris SkorlinskiIntermediate
Entity Framework for Data ProfessionalsRichie RumpBeginner
Expanding Self-Service BI with Excel 2013Leo FurlongBeginner
Exposing the Metadata of your SQL ServerLouis DavidsonAdvanced
Extend Your Knowledge with Extended Events - Part 2Janis GriffinAdvanced
Extend Your Knowledge with Extended Events!Janis GriffinBeginner
GeoSpatial Analytics Using Microsoft BIJason ThomasBeginner
Get Hired in 10 minutesChris SkorlinskiBeginner
Getting started with Master Data Services 2012Luis FigueroaIntermediate
Getting Started with MDX: The (Very) BasicsWilliam E Pearson IIIBeginner
Getting Started with Powershell for DBAsJon BoulineauBeginner
Global Address Data: Storage and VerificationCharles GaddyIntermediate
Hacking the SSIS 2012 CatalogAndy LeonardBeginner
High Availability with SQL Server 2012Eric PetersonIntermediate
High Performance SANLess ClusteringDave Bermingham and Vin PrasadBeginner
How to manage a Team of Technical ProfessionalsKat MeadowsNon-Technical
How to Write a DML TriggerLouis DavidsonIntermediate
Insights to Better Team Management Ed WyattNon-Technical
Introducing the SSAS 2012 BISM (Tabular) ModelRobert CainBeginner
It's All About the Performance, Right?David KleeIntermediate
I've Got A SQL Database, Now What?Denny CherryBeginner
Join Us! Getting Started as a Technical SpeakerEddie WuerchBeginner
Jump-starting your careerBobby DimmickBeginner
Lateral Thinking using SSRSJason ThomasAdvanced
Looney Tuner? No, there IS a method to my madnessJanis GriffinIntermediate
Make SQL Server Pop with PowerShellRobert CainIntermediate
Managing a Technical Team: Lessons LearnedStuart AinsworthBeginner
Managing Enterprise Environments with PowerShellThomas StringerIntermediate
Managing the SQL Server 2012 SSIS catalog (SSISDB)Sven AeltermanAdvanced
Managing Windows Server 2012 with PowerShellMike RobbinsIntermediate
Many–to -Many: Multiple Calendars in a Single CubeWilliam E Pearson IIIAdvanced
Matching and Survivorship (Intermediate)Charles GaddyIntermediate
Matching with Data Quality ServicesJulie SmithBeginner
New T-SQL features in SQL Server 2012Richie RumpIntermediate
NoSql Eye for the Relational GuyBobby DimmickIntermediate
Off and Running with PowerPivot for Excel 2013Robert CainBeginner
Page Latches for Mere MortalsEddie WuerchAdvanced
Partitioning for Perf & Management of Large TablesEddie WuerchIntermediate
Possible Musics: SSAS Multidimensional vs TabularWilliam E Pearson IIIAdvanced
Power View: A Peek Behind the CurtainStacia MisnerBeginner
PowerScripting Live! (PowerShell podcast / BoF)Jonathan WalzBeginner
PowerShell for Data ProfessionalsAaron NelsonIntermediate
Powershell for the beginnerKen McFerronBeginner
PowerShell Fundamentals for BeginnersMike RobbinsBeginner
Principles of BISM Tabular ModelingJavier GuillenAdvanced
Prototype with PowerPivot: SSAS External GroupingWilliam E Pearson IIIIntermediate
Report Builder: Reports made Easy.Yelena PavlyukBeginner
Scaling Out SQL Server Reporting ServicesSven AeltermanAdvanced
Secrets of Enterprise Data MiningMark TabladilloIntermediate
Semantic Model in Analysis Services 2012Thomas LeBlancIntermediate
SharePoint Disaster Recovery with SQL ServerBen AdamsIntermediate
Smart Rats Leave FirstGeoff HitenBeginner
SMO Internals for High Performance PowerShellBen MillerAdvanced
So You Want To Be A Rockstar Report Developer?Melissa CoatesIntermediate
Social Marketing 2013 for Microsoft ProfessionalsMark TabladilloBeginner
SQL 2012 -- All About HA and DRJoseph D'AntoniIntermediate
SQL Database (Windows Azure)Ryan DuclosBeginner
SQL Reporting (Windows Azure)Ryan DuclosBeginner
SQL Server 2012 AlwaysOn DemystifiedDavid BerminghamBeginner
SQL Server 2012 AlwaysOn Step-by-StepDavid BerminghamBeginner
SQL Server 2012 Column Store IndexKevin BolesAdvanced
SQL Server Database Development with SSDT Aaron NelsonIntermediate
SQL Server Maintenance PlansKat MeadowsBeginner
SQL Server Parallel Data Warehouse 2012 Deep DiveSteve BusbyIntermediate
SQL Server TDEBen MillerIntermediate
SQL Server XML 201Stuart AinsworthBeginner
Squeezing the Most Performance from your VMware-Based SQL ServerDavid KleeAdvanced
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
Storage for the DBADenny CherryAdvanced
Storage Tuning Deep DiveWes BrownAdvanced
Table Indexing for the .NET DeveloperDenny CherryIntermediate
Taking BI to the Next Level: CollaborationStacia MisnerIntermediate
Taking the Scary out of Monster ReportsPam ShawBeginner
Taming Complex Tasks with the Psake ModuleJim ChristopherBeginner
Team Leadership FundamentalsKevin KlineBeginner
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
The Agile DBA: Managing your To-Do ListStuart AinsworthBeginner
The Decoder Ring for Data Warehousing / BIRobert CainBeginner
The Last Mile: Dynamically Created ObjectsDan HolmesAdvanced
The Transaction Log – A Fast & Deep DiveJeremy CarrollAdvanced
This session left intentionally blankBlank BlankNon-Technical
Tips & Tricks for dynamic SSRS ReportsPam ShawBeginner
Top 10 Admininistrator Mistakes on SQL ServerKevin KlineBeginner
Top Query Optimizer Topics for Better PerformanceBenjamin NevarezIntermediate
Troubleshooting AlwaysOn Availability GroupsThomas StringerIntermediate
Troubleshooting MDX Query PerformanceStacia MisnerAdvanced
TSQL Road Less Traveled: APPLYKevin BolesAdvanced
TSQL Road Less Traveled: MERGEKevin BolesIntermediate
T-SQL: Beyond the BasicsJon BoulineauBeginner
Understanding Parameter SniffingBenjamin NevarezIntermediate
Using BIML as an SSIS Design Patterns Engine Andy LeonardAdvanced
Using Compression to Improve Database PerformanceJoseph D'AntoniIntermediate
Using SQL Server 2012s Always OnDenny CherryIntermediate
Using SSIS 2012 for ETL in a Data WarehouseThomas LeBlancAdvanced
Virtualizing Business Critical SQL ServersDavid KleeIntermediate
What counts for a DBALouis DavidsonNon-Technical
What I Wish I Knew Before Becoming a DBAMike WalshBeginner
What SharePoint DBAs need to Know about SQLBen AdamsIntermediate
What's New in PowerShell v3Robert CainBeginner
When a Strange Server CallsJennifer McCownBeginner
Windowing Functions: THE Reason to Upgrade to 2012Kevin BolesAdvanced
Windows PowerShell best practices for the busy DBAEd WilsonIntermediate
Working with "Biggish Data"Stuart AinsworthBeginner


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