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 TimeBI / SSAS 1 - Room: Room 5BI / SSAS 2 - Room: Room 6DBA 1 - Room: Room 1DBA 2 - Room: Room 2Developer - Room: Room 3Professional Development - Room: Room 4
07:30 AMSQLSaturday 173

Registrations

Level: Non-Technical
SQLSaturday 173

Registrations

Level: Non-Technical
SQLSaturday 173

Registrations

Level: Non-Technical
SQLSaturday 173

Registrations

Level: Non-Technical
SQLSaturday 173

Registrations

Level: Non-Technical
SQLSaturday 173

Registrations

Level: Non-Technical
08:30 AMSQLSAT DC

Opening Remarks

Level: Non-Technical
SQLSAT DC

Opening Remarks

Level: Non-Technical
SQLSAT DC

Opening Remarks

Level: Non-Technical
SQLSAT DC

Opening Remarks

Level: Non-Technical
SQLSAT DC

Opening Remarks

Level: Non-Technical
SQLSAT DC

Opening Remarks

Level: Non-Technical
9:00 AMSQLSAT DC

Panel discussion - Big Data

Level: Non-Technical
SQLSAT DC

Panel discussion - DW / BI

Level: Non-Technical
SQLSAT DC

Panel discussion - HA, DR & Replication

Level: Non-Technical
SQLSAT DC

Panel discussion - Performance

Level: Non-Technical
Mike Walsh

DBA Worst Practices, Disasters and Horror Stories

Level: Beginner
SQLSAT DC

Panel discussion - Professional Development

Level: Beginner
10:15 AMGeoff Johnson

Using Expressions to Avoid Three SSRS Annoyances

Level: Intermediate

download
Paul Rizza

Shortcuts to Building SSIS in .Net

Level: Intermediate
Steven Wright

Resource Governor for SQL Server

Level: Intermediate

download
David Klee

Virtualizing Business Critical SQL Servers

Level: Intermediate

download
Wayne Sheffield

Windowing Functions in SQL Server 2012

Level: Intermediate

download
Kevin Goode

Let's Talk Licensing

Level: Intermediate

download
11:30 AMKevin Goff

SQL Server 2012 Columnstore index

Level: Intermediate
Jason Thomas

Advanced Charting Techniques in SSRS

Level: Intermediate

download
Allen White

PowerShell 101 for the SQL Server DBA

Level: Beginner

download
Tim Radney

Know Backups and Know Recovery

Level: Intermediate

download
Kevin Boles

SQL Server 2012 TSQL Enhancements and Additions

Level: Intermediate

download
Ryan Brickey

DBA’s1st Date - Getting to know a new environment

Level: Beginner

download
12:30 PMSQLSaturday 173

Lunch Break

Level: Non-Technical
SQLSaturday 173

Lunch Break

Level: Non-Technical
SQLSaturday 173

Lunch Break

Level: Non-Technical
SQLSaturday 173

Lunch Break

Level: Non-Technical
SQLSaturday 173

Lunch Break

Level: Non-Technical
SQLSaturday 173

Lunch Break

Level: Non-Technical
01:30 PMWilliam E Pearson III

Getting Started with MDX: The (Very) Basics

Level: Beginner
derek dai

“ColumnStore” Indexes for Fast EDW Query

Level: Intermediate

download
Wayne Sheffield

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

Level: Intermediate

download
Joseph D'Antoni

SQL 2012 -- All About HA and DR

Level: Intermediate
Konstatin Melamud

PerfTuning: Intro To Execution Plan Analysis

Level: Beginner
Jason Hall

Recipe for a happy DBA

Level: Beginner

download
02:45 PMJason Horner

Isn't that Spatial! (BI Edition)

Level: Beginner
Stacia Misner

Taking BI to the Next Level: Collaboration

Level: Intermediate

download
Ira Whiteside

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

Level: Intermediate
Michael Corey

Virtualizing SQL 2012: Doing It Right

Level: Intermediate
Rob Volk

Revenge: The SQL!

Level: Intermediate

download
Brian Moran

The Art of Questions and success as an IT Pro

Level: Beginner

download
04:00 PMAndy Leonard

Loading Data Warehouse Partitions with SSIS 2012

Level: Intermediate
John Sterrett

Performance Tuning for Pirates

Level: Advanced
Carlton Ramsey

How PowerShell helps me as a DBA

Level: Beginner

download
Kevin Boles

Common TSQL Mistakes

Level: Intermediate

download
Rob Volk

Revenge: The SQL Part 2: The Sequel!

Level: Intermediate

download
Eddie Wuerch

Join Us! Getting Started as a Technical Speaker

Level: Beginner

download
05:15 PMSQLSaturday 173

Raffle/Closing Remarks

Level: Non-Technical
SQLSaturday 173

Raffle/Closing Remarks

Level: Non-Technical
SQLSaturday 173

Raffle/Closing Remarks

Level: Non-Technical
SQLSaturday 173

Raffle/Closing Remarks

Level: Non-Technical
SQLSaturday 173

Raffle/Closing Remarks

Level: Non-Technical
SQLSaturday 173

Raffle/Closing Remarks

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
Isn't that Spatial! (BI Edition)Jason HornerBeginner
PoSh Eye for the BI GuyJason HornerBeginner
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your OwnIra WhitesideIntermediate
(SQL,SSIS,MDS) Adv Fuzzy Matching Roll Your OwnIra WhitesideIntermediate
(Way Too Much) Fun with Reporting Services Stacia MisnerBeginner
“ColumnStore” Indexes for Fast EDW Queryderek daiIntermediate
5 Common SQL Server Performance IssuesJason HallIntermediate
Advanced Charting Techniques in SSRSJason ThomasIntermediate
Building a Foundation for Self-Service BIStacia MisnerIntermediate
Coffee BreakSQLSatruday 173Beginner
Common TSQL MistakesKevin BolesIntermediate
Communicate for Great Good!Matt VelicBeginner
Creating a Metadata Mart w/ SSIS - Data GovernanceIra WhitesideIntermediate
Data Files and Transaction Logs – Beyond the GUIs Sandra MuellerBeginner
Database And Websites And College, Oh My!Peg LeDellBeginner
Database Health and PerformanceDavid KleeIntermediate
DBA Worst Practices, Disasters and Horror StoriesMike WalshBeginner
DBA’s1st Date - Getting to know a new environmentRyan BrickeyBeginner
Design and Implement BI Like Edison! William E Pearson IIIBeginner
Designing an SSIS Framework Andy LeonardAdvanced
Designing Custom Maintenance Plans with TSQLJohn MinerIntermediate
Developing Date and Role-Playing DimensionsSandra MuellerIntermediate
Dimensional Modeling: Beyond the BasicsJason HornerBeginner
Disaster Lessons for TechnologistsMike WalshBeginner
Enterprise-Ready ETL Solutions using SSIS 2012Jon TupitzaBeginner
Fast Track to Spatial Reporting Using SSRS 2012Jason ThomasIntermediate
Full Text Indexing BasicsJohn MinerBeginner
Fundamentals of Join OperationsKevin BolesBeginner
Gather SQL Server Performance Data with PowerShellAllen WhiteIntermediate
Getting involved and Getting aheadTim RadneyBeginner
Getting Started with MDX: The (Very) BasicsWilliam E Pearson IIIBeginner
Getting Started with MDX: The (Very) BasicsWilliam E Pearson IIIBeginner
Hadoop on WindowsAzure in ActionWenming YeBeginner
How PowerShell helps me as a DBACarlton RamseyBeginner
How to audit and prevent unwanted user actions.John MinerIntermediate
Intro to Common Table ExpressionsGeoff JohnsonBeginner
It is TEMPDB, Why Should You Care?Tim RadneyIntermediate
Join Us! Getting Started as a Technical SpeakerEddie WuerchBeginner
Know Backups and Know RecoveryTim RadneyIntermediate
Let's Talk LicensingKevin GoodeIntermediate
Loading Data Warehouse Partitions with SSIS 2012Andy LeonardIntermediate
Lunch BreakSQLSaturday 173Non-Technical
Mapping Features in SSRS, PowerView and TableauJason ThomasBeginner
Minimally Invasive - Tools to Doctor Up Your CodeWayne SheffieldIntermediate
Mobile Business Intelligence for Everyone, Now!Jen StirrupIntermediate
Much Ado About Indexes - Tips, Tricks and TSQLRobert PearlBeginner
Opening RemarksSQLSAT DCNon-Technical
Overcoming Barriers and Avoiding Mistakes with BIWilliam E Pearson IIIBeginner
Overview of PowerPivotDavid EichnerBeginner
Panel discussion - Big DataSQLSAT DCNon-Technical
Panel discussion - DW / BISQLSAT DCNon-Technical
Panel discussion - HA, DR & ReplicationSQLSAT DCNon-Technical
Panel discussion - PerformanceSQLSAT DCNon-Technical
Panel Discussion - PowerShellSQLSAT DCNon-Technical
Panel discussion - Professional DevelopmentSQLSAT DCBeginner
Panel discussion - ReportsSQLSAT DCNon-Technical
Partitioning for Perf & Management of Large TablesEddie WuerchIntermediate
Performance Tuning for PiratesJohn SterrettAdvanced
Performance Tuning- Index OptimizationKonstatin MelamudIntermediate
PerfTuning: Intro To Execution Plan AnalysisKonstatin MelamudBeginner
Platinum Sponsor presentation - Grid Iron SystemsSQLSAT DCBeginner
Possible Musics: SSAS Multidimensional vs TabularWilliam E Pearson IIIIntermediate
Power View from the Data Visualisation PerspectiveJen StirrupIntermediate
Power View: A Peek Behind the CurtainStacia MisnerBeginner
PowerShell 101 for the SQL Server DBAAllen WhiteBeginner
Prototype with PowerPivot: External SSAS GroupsWilliam E Pearson IIIIntermediate
Raffle/Closing RemarksSQLSaturday 173Non-Technical
Recipe for a happy DBAJason HallBeginner
Reciprocal Symmetry: MDX in PowerPivotWilliam E Pearson IIIIntermediate
RegistrationsSQLSaturday 173Non-Technical
Reporting Services for Mere DBAsJason BrimhallIntermediate
Resource Governor for SQL ServerSteven WrightIntermediate
Revenge: The SQL Part 2: The Sequel!Rob VolkIntermediate
Revenge: The SQL!Rob VolkIntermediate
Roping the Elephant - Hadoop and BI Live!Adam JorgensenIntermediate
Running SQL Server 2012 as a Windows Azure VMTimothy McAlileyIntermediate
Self-Service BI - Is it for you?Sandra MuellerBeginner
Sets and Relations and Queries, Oh My!Allen WhiteBeginner
Shade Tree Mechanic's Guide to SSASSteven WrightBeginner
SharePoint COOP Using 2008R2 Log Shipping Ken HausmanAdvanced
SharePoint COOP Using 2008R2 Log Shipping Donald ScottAdvanced
SharePoint COOP Using SQL Server 2012 Always-OnKen HausmanIntermediate
SharePoint COOP Using SQL Server 2012 Always-OnDonald ScottIntermediate
Shortcuts to Building SSIS in .NetPaul RizzaIntermediate
Sizing up SQL AzureCarlos ChaconBeginner
SQL 2012 -- All About HA and DRJoseph D'AntoniIntermediate
SQL 2012 Extended EventsJason BrimhallAdvanced
SQL Azure - What is it and why do you need it?Scott KleinBeginner
SQL Azure Scalability with FederationsScott KleinIntermediate
SQL InjectionKevin BolesIntermediate
SQL Internals - IndexesKevin GoodeIntermediate
SQL Server 2012 Column Store IndexKevin BolesIntermediate
SQL Server 2012 Columnstore indexKevin GoffIntermediate
SQL Server 2012 TSQL Enhancements and AdditionsKevin BolesIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSRS 2008R2 Reporting GalleryKevin GoffIntermediate
Table CompressionJason BrimhallAdvanced
Table Partitioning made easy!John SterrettBeginner
Table Vars & Temp Tables - What you NEED to Know!Wayne SheffieldIntermediate
Taking BI to the Next Level: CollaborationStacia MisnerIntermediate
Tame Your Unruly Data...With Constraints!Rob VolkBeginner
Tax, Finance, and Money Tips for consultantsBrian MoranBeginner
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
Ten Common SQL Server Mistakes!John SterrettBeginner
The Art of Questions and success as an IT ProBrian MoranBeginner
The new tabular model in Analysis Services 2012Kevin GoffIntermediate
Transaction Log Deep DiveKevin BolesAdvanced
T-SQL for Application Developers - Attendees choseKevin GoffIntermediate
Upgrading to SSIS 2012Paul RizzaIntermediate
Using Expressions to Avoid Three SSRS AnnoyancesGeoff JohnsonIntermediate
Virtualizing Business Critical SQL ServersDavid KleeIntermediate
Virtualizing SQL 2012: Doing It RightMichael CoreyIntermediate
Way Too Deep--Inside AlwaysOnJoseph D'AntoniAdvanced
Windowing Functions in SQL Server 2012Wayne SheffieldIntermediate
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