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 TimeBEG - Room: Room 2DBA\DEV - Room: Room 6DBA\DEV - Room: Room 7DBA\DEV - Room: Room 8DBA\DEV - Room: Room 9DBA\DEV - Room: Room 10POW - Room: Room 1SSAS\IS\RS - Room: Room 3SSAS\IS\RS - Room: Room 4SSAS\IS\RS - Room: Room 5
09:00 AMBrian Kelley

Being the Swiss Army Knife of DB Pros

Level: Beginner

download
Kevin Boles

Fundamentals of Physical Join Operations

Level: Beginner

download
Jeremy Carroll

It's Spring - Are You Still Compressed?

Level: Intermediate
Christina Leo

Working with Server Side Traces

Level: Intermediate

download
Aaron Nelson

Time Saving Tips & Tricks for SSMS 2012

Level: Intermediate
Phil Pledger

Using NULL the Right Way

Level: Advanced

download
Allen White

Manage SQL Server 2012 on Server Core w/PowerShell

Level: Advanced
Melissa Coates

“Managed Self-Service BI” and “Data As A Service”

Level: Intermediate

download
Teo Lachev

The Personal-Team-Organizational BI Conundrum

Level: Intermediate

download
Hope Foley

Super-size Your SSIS Breakfast Sandwich: Performan

Level: Intermediate
10:15 AMJennifer McCown

Beginning T-SQL

Level: Beginner
Grant Fritchey

Execution Plans a Deep Dive

Level: Advanced
Brian Kelley

Windows Operating System Internals for DB Pros

Level: Advanced

download
Karen Lopez

Database Design Contentious Issues

Level: Intermediate
Sven Aelterman

Introduction to FileTables

Level: Intermediate

download
Jen Underwood

Mobile Business Intelligence

Level: Intermediate
Jim Christopher

PowerShell Modules You Should Know About

Level: Beginner

download
Robert Cain

Configuring SQL Server 2012 Reporting Services

Level: Intermediate
Matt Masson

EIM - Bringing Together SSIS, DQS, and MDS (300)

Level: Intermediate
Rafael Salas

SSIS 2012: Project Deployment Model and Catalog

Level: Beginner
01:00 PMRobert Cain

The Decoder Ring for Data Warehousing / BI

Level: Beginner
Wesley Brown

Benchmarking, Baselines and Monitoring Storage

Level: Beginner
Denny Cherry

Index Internals

Level: Advanced

download
Jason Strate

Extended Events, Work Smarter Not Harder

Level: Advanced
Adam Machanic

Query Tuning Mastery: Manhandling Parallelism

Level: Advanced
Jennifer McCown

T-SQL Brush-up:The Best Things You Forgot You Knew

Level: Beginner
Ed Wilson

Windows PowerShell Best Practices

Level: Intermediate
Geoff Hiten

Moving Day - Successful SQL Migrations with ShareP

Level: Intermediate
Andy Leonard

Designing an SSIS Framework

Level: Advanced
Eric Melcher

Analytical Master Data Management with MDS 2012

Level: Intermediate
02:30 PMJulie Smith

SQL Server is the Least of My Problems!

Level: Beginner
William E. Pearson III

PowerPivot for Excel: For Those Unacquainted ...

Level: Beginner
Tim Radney

It is TEMPDB, Why Should You Care?

Level: Intermediate

download
Jim Wooley

Managing Database Changes with Visual Studio

Level: Intermediate
Glen Gordon

Managing data in a Windows Phone application

Level: Beginner
Wayne Sheffield

Table Vars & Temp Tables - What you NEED to Know!

Level: Intermediate

download
Jonathan Boulineau

Concurrency in PowerShell

Level: Advanced

download
Erika Bakse

Think Outside the Group! Take MDX to the next leve

Level: Intermediate
Pam Shaw

Taking the Scary out of Monster Reports

Level: Intermediate

download
Mark Tabladillo

Applied Enterprise Semantic Mining

Level: Intermediate

download
03:45 PMGrant Fritchey

Common Backup Problems and How to Deal With Them

Level: Beginner
Bob Langley

Introduction to SQL Server Column-Level Encryption

Level: Beginner

download
Denny Cherry

SQL Server Table Partitioning from the ground up

Level: Intermediate

download
Stuart Ainsworth

Working with "Biggish Data"

Level: Beginner

download
Rob Volk

Revenge: The SQL Part 2: The Sequel!

Level: Intermediate

download
Vicky Harp

Introduction to Common Table Expressions

Level: Intermediate

download
Hal Rottenberg

PowerScripting Live! (PowerShell podcast / BoF)

Level: Intermediate
Stacia Misner

Power View: A Peek Behind the Curtain

Level: Beginner

download
Jessica Moss

Report Parts: Increasing Productivity Since 2008R2

Level: Beginner

download
John Welch

Tuning Analysis Services Processing Performance

Level: Advanced


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
(Way Too Much) Fun with Reporting Services Stacia MisnerBeginner
“I See a Control Flow Tab. Now What?” (Level 100)Andy LeonardBeginner
“Managed Self-Service BI” and “Data As A Service”Melissa CoatesIntermediate
Advanced FILESTREAMSven AeltermanAdvanced
AlwaysOn - Finally, A usable 'mirror'!Jim MurphyBeginner
Analytical Master Data Management with MDS 2012Eric MelcherIntermediate
Applied Enterprise Semantic MiningMark TabladilloIntermediate
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIBeginner
Automate Policy-Based Management using PowerShellAllen WhiteAdvanced
Automating SQL Tools with PowerShellAaron NelsonBeginner
Be Your Own SQL SWAT TeamBen DeBowIntermediate
Become a PowerShell Pop StarRobert CainBeginner
Becoming DAX: An Introduction ...William E. Pearson IIIIntermediate
Beginning T-SQLJennifer McCownBeginner
Being the Swiss Army Knife of DB ProsBrian KelleyBeginner
Benchmarking, Baselines and Monitoring StorageWesley BrownBeginner
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Bridging the Chasm: BI Theory vs. PracticeWilliam E Pearson IIIBeginner
Build Your Own SQL Server Private CloudBen DeBowIntermediate
Building a System: Being a More Effective DB ProBrian KelleyBeginner
Building an Infrastructure for Secure SQL ServersBrian KelleyBeginner
Choose Your Own Adventure: Performance TuningJason StrateAdvanced
Code SinsJennifer McCownBeginner
Common Backup Problems and How to Deal With ThemGrant FritcheyBeginner
Compliance and Auditing in Sql ServerTom NormanIntermediate
Concurrency in PowerShellJonathan BoulineauAdvanced
Configuring SQL Server 2012 Reporting ServicesRobert CainIntermediate
Creating a Performance Baseline for SQL ServerRon JohnsonBeginner
Data Quality Services 2012Chris PriceIntermediate
Data Visualization in Reporting ServicesStacia MisnerBeginner
Database Design Contentious IssuesKaren LopezIntermediate
Declarative versus Procedual programmingJoe CelkoIntermediate
Design and Implement BI Like Edison! William E. Pearson IIIBeginner
Design Does Matter: The Performance Impact of DataAudrey HammondsIntermediate
Designing an SSIS Framework Andy LeonardAdvanced
Developing and Managing a BI Semantic Tabular ModePatrick LeBlancIntermediate
Discovering the Plan CacheJason StrateAdvanced
Disk IO Tuning for Microsoft SQL ServerKevin KlineIntermediate
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Dynamic MDX: Packing a Punch into One .rdlErika BakseIntermediate
Edge Case Testing for the Database ProfessionalVicky HarpBeginner
EIM - Bringing Together SSIS, DQS, and MDS (300)Matt MassonIntermediate
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Execution Plans a Deep DiveGrant FritcheyAdvanced
Extended Events, Work Smarter Not HarderJason StrateAdvanced
Fast Track to BISM Tabular and PowerViewAdam JorgensenIntermediate
From DBA to Data ArchitectStuart AinsworthBeginner
Fundamentals of Physical Join OperationsKevin BolesBeginner
Fundamentals of SAN, NAS and IP StorageWesley BrownIntermediate
Getting SQL Service Broker Up and RunningDenny CherryIntermediate
Getting Started with MDX: The (Very) BasicsWilliam E. Pearson IIIBeginner
Getting Started with PowershellJonathan BoulineauBeginner
Getting The Most From Your SQL Server Ben DeBowIntermediate
Getting to Know Index Operation StatsJason StrateAdvanced
Hadoop, MapReduce, NoSQL: What it means for DBAsJonathan BoulineauIntermediate
Handling Advanced Data Warehouse Scenarios in SSISJohn WelchIntermediate
High Availability for SSIS in SQL Server 2012Patrick LeBlancAdvanced
Holy Crap! Someone Put the Database in the CloudJason StrateBeginner
How to Lose Friends & Annoy People...With Unicode!Rob VolkLightning Talk
Index InternalsDenny CherryAdvanced
Intro to SSASNathan MourfieldBeginner
Introduction to Common Table ExpressionsVicky HarpIntermediate
Introduction to FILESTREAMSven AeltermanIntermediate
Introduction to FileTablesSven AeltermanIntermediate
Introduction to Master Data Services 2012Chris PriceIntermediate
Introduction to PowerShell RemotingJason HofferleIntermediate
Introduction to Query Execution InformationKevin BolesBeginner
Introduction to SQL Server Column-Level EncryptionBob LangleyBeginner
Introduction to SSIS with a Real-World ExampleRon JohnsonBeginner
It is TEMPDB, Why Should You Care?Tim RadneyIntermediate
It's Spring - Are You Still Compressed?Jeremy CarrollIntermediate
Know Backups and Know RecoveryTim RadneyIntermediate
Know Backups, Know RecoveryTim RadneyIntermediate
Lego Sets: Relational Building BlocksRob VolkBeginner
Manage SQL Server 2012 on Server Core w/PowerShellAllen WhiteAdvanced
Managing data in a Windows Phone applicationGlen GordonBeginner
Managing Database Changes with Visual StudioJim WooleyIntermediate
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Master Data Services in SQL Server 2012Arie JonesIntermediate
Minimally Invasive - Tools to Doctor Up Your CodeWayne SheffieldIntermediate
Mobile Business IntelligenceJen UnderwoodIntermediate
Model-Driven Database DesignKaren LopezBeginner
Monitoring Databases in a Virtual EnvironmentThomas LaRockIntermediate
Moving Data With SQL Azure Data SyncPatrick LeBlancIntermediate
Moving Day - Successful SQL Migrations with SharePGeoff HitenIntermediate
Nested Sets Model for trees in 2012Joe CelkoIntermediate
New Tricks for Old Tasks in the CloudJason StrateBeginner
Off and Running with PowerPivot for Excel 2010Robert CainBeginner
OLAP Security using SSAS Stored ProceduresRob SchoenbornAdvanced
Overcoming Barriers and Avoiding Mistakes with BIWilliam E Pearson IIIBeginner
PBM and You!Tom NormanBeginner
Power View: A Peek Behind the CurtainStacia MisnerBeginner
Powerful BI in SharePoint 2010Cory LoriotIntermediate
PowerPivot for Excel: For Those Unacquainted ...William E. Pearson IIIBeginner
PowerScripting Live! (PowerShell podcast / BoF)Hal RottenbergIntermediate
PowerShell Modules You Should Know AboutJim ChristopherBeginner
Production is all Virtualized, Is Yours?Tom NormanBeginner
Project Management for SQL Devs & DBAsNathan MourfieldBeginner
Prototyping with PowerPivot: Handling External SSAWilliam PearsonIntermediate
Query Tuning Mastery: Manhandling ParallelismAdam MachanicAdvanced
Reciprocal Symmetry: MDX in PowerPivotWilliam PearsonIntermediate
Regular Expressions in SSMS in 5 Minutes or LessRob VolkLightning Talk
Report Parts: Increasing Productivity Since 2008R2Jessica MossBeginner
Revenge: The SQL Part 2: The Sequel!Rob VolkIntermediate
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIIntermediate
Shiny New T-SQL for SQL Server 2012Audrey HammondsIntermediate
Social Marketing 2012 for Microsoft ProfessionalsMark TabladilloBeginner
Solid State Storage Deep DiveWesley BrownIntermediate
Speak with confidenceBuck WoodyBeginner
SQL 2012 DMV's & Extended EventsGareth SwanepoelIntermediate
SQL Azure Performance TuningBuck WoodyAdvanced
SQL InjectionKevin BolesIntermediate
SQL Server 2012: A Window To T-SQL EnhancementsJason StrateIntermediate
SQL Server Disaster Recovery SolutionsChad ChurchwellIntermediate
SQL Server Internals & ArchitectureKevin KlineIntermediate
SQL Server Internals: It's What's for Dinner!Christina LeoBeginner
SQL Server IO Deep DiveKevin BolesAdvanced
SQL Server is the Least of My Problems!Julie SmithBeginner
SQL Server is the Least of My Problems!Julie SmithBeginner
SQL Server Table Partitioning from the ground upDenny CherryIntermediate
SQL Server XML 201Stuart AinsworthIntermediate
SQL's Index and Column Statistics - indepthJoe MurphreeIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSAS & Self-Service BI: Can they live in harmony?Javier GuillenIntermediate
SSIS 2012: Project Deployment Model and CatalogRafael SalasBeginner
SSIS in SQL Server 2012: Developer EnhancementsMatt MassonIntermediate
SSIS Performance Design PatternsMatt MassonIntermediate
Sssssmokin': FileTable & Full-text Semantic SearchGareth SwanepoelIntermediate
Stupid PowerShell Tricks: MicroAutomate!Jim ChristopherBeginner
Super-size Your SSIS Breakfast Sandwich: PerformanHope FoleyIntermediate
Surviving Your Peak Database LoadBen DeBowIntermediate
Table Indexing for the .NET DeveloperDenny CherryIntermediate
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
Taking the Scary out of Monster ReportsPam ShawIntermediate
Tame Your Unruly Data...With Constraints!Rob VolkBeginner
Team Management FundamentalsKevin KlineIntermediate
Test Driven Development (TDD) in the databaseAlex TocituIntermediate
Testing your data applications with EF 4Jim WooleyIntermediate
The Critical Path, SSIS, and YouNathan MourfieldIntermediate
The Decoder Ring for Data Warehousing / BIRobert CainBeginner
The Dirty Business of AuditingBrian KelleyBeginner
The Fangorn Forest - ColumnStore IndexesGareth SwanepoelIntermediate
The Personal-Team-Organizational BI ConundrumTeo LachevIntermediate
The PowerShell Data & Schema Compare ToolkitAlex TocituAdvanced
The TSQL Road Less Traveled: APPLYKevin BolesIntermediate
The TSQL Road Less Traveled: MERGEKevin BolesIntermediate
The TSQL/.NET Data & Schema Compare ToolkitAlex TocituAdvanced
The window clause in aggregate functions Joe CelkoIntermediate
Think Outside the Group! Take MDX to the next leveErika BakseIntermediate
Time Saving Tips & Tricks for SSMS 2012Aaron NelsonIntermediate
Top 10 Admin Mistakes on SQL ServerKevin KlineIntermediate
Top 10 Tips for Being a Better SSRS DeveloperMelissa CoatesBeginner
Top Tips for Writing Better T-SQL QueriesGrant FritcheyIntermediate
Triple Threat! SSIS + DQS + MDS 2012 Arie JonesIntermediate
T-SQL Brush-up:The Best Things You Forgot You KnewJennifer McCownBeginner
Tuning Analysis Services Processing PerformanceJohn WelchAdvanced
Understanding and Preventing SQL Injection Kevin KlineIntermediate
Unit Testing SSIS PackagesJohn WelchIntermediate
Upgrading and Overhauling Your SSIS Packages for 2Jessica MossBeginner
Upgrading SSIS Packages to SQL Server 2012Sven AeltermanIntermediate
Using NULL the Right WayPhil PledgerAdvanced
Utilizing Data Quality Services in SQL Server 2012Arie JonesIntermediate
What Are You Waiting For? Jason StrateIntermediate
What's Buried in the Plan Cache?Christina LeoIntermediate
What's New for Developers in SQL Server 2012Sven AeltermanIntermediate
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate
Windows Operating System Internals for DB ProsBrian KelleyAdvanced
Windows PowerShell Best PracticesEd WilsonIntermediate
Working with "Biggish Data"Stuart AinsworthBeginner
Working with Server Side TracesChristina LeoIntermediate
XQuery Basics for the DBAJason StrateIntermediate
You Inherited a Database, Now What?Tim RadneyBeginner


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