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 4
08:00 AMDave Schutz

Registration/Intro

Level: Beginner
   
09:00 AMKaren Lopez

5+ Database Design Blunders and How To Avoid Them

Level: Beginner
Craig Purnell

SQL Server 101 for IT Pros

Level: Beginner

download
Aaron King

A Complete BI Solution in About an Hour!

Level: Beginner

download
Jason Spangler

Profiler? What is this tool you speak of?

Level: Beginner

download
10:30 AMDave Rodabaugh

Transaction and Balance Facts: Identical Cousins

Level: Advanced
Lisa Gardner

SQL Server and Sharepoint: Best Frienemies

Level: Intermediate

download
William E. Pearson III

Design and Implement BI Like Edison!

Level: Beginner
Adam Belebczuk

Introduction to SQL Server Service Broker

Level: Beginner

download
12:00 PMDave Schutz

Lunch - Women In Technology Session

Level: Beginner
   
1:00 PMThomas LaRock

Choose Your Own Adventure: Performance Tuning

Level: Advanced
Kevin Boles

Parallel Query Execution Deep Dive

Level: Advanced

download
John Sterrett

Performance Tuning for Pirates

Level: Advanced
Mike Donnelly

SSIS: Figuring Out Configuring

Level: Intermediate
2:30 PMJose Chinchilla

Change Data Capture a tool for BI,DR,Audit & more

Level: Beginner
Louis Davidson

What Sequence objects are (and are not)

Level: Intermediate

download
Ira Whiteside

Creating a Metadata Mart w/ SSIS - Data Governance

Level: Intermediate
Grant Fritchey

Execution Plans a Deep Dive

Level: Advanced

download
3:45 PMEddie Wuerch

TempDB Performance Troubleshooting and Optimizing

Level: Intermediate

download
Wendy Pastrick

Visualizing Your Indexes - Science vs Art

Level: Beginner
Kevin Bullen

Getting Started With PowerShell and SQL Server

Level: Beginner

download
Randy Knight

Understanding SQL Server XML Features

Level: Intermediate
5:00 PMDave Schutz

SWAG Giveaway! Wrap Up

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
Allen SmithIntermediate
*GASP* Real-time user defined sets in SSASJosh FennessyAdvanced
5+ Database Design Blunders and How To Avoid ThemKaren LopezBeginner
A Complete BI Solution in About an Hour! Aaron KingBeginner
Administering the BI StackJosh FennessyIntermediate
An Overview of PowerPivotWilliam E. Pearson IIIBeginner
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIBeginner
Become Bilingual! Oracle for the SQL Server DBARandy KnightIntermediate
Becoming DAX: An Introduction ... William E. Pearson IIIIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Bridging the Chasm: BI Theory vs. PracticeWilliam E. Pearson IIIBeginner
But it worked great in Dev! Perfomance for DevsRandy KnightBeginner
Change Data Capture a tool for BI,DR,Audit & more Jose ChinchillaBeginner
Choose Your Own Adventure: Performance TuningThomas LaRockAdvanced
Creating a Metadata Mart w/ SSIS - Data GovernanceIra WhitesideIntermediate
Database Design Contentious IssuesKaren LopezIntermediate
Design and Implement BI Like Edison! William E. Pearson IIIBeginner
Documenting Your Integrated Microsoft BI Solution William E. Pearson IIIIntermediate
Driving process improvement through reportingJohn IosubIntermediate
Entity Strategies: Structuring Your Consultancy William E. Pearson IIIBeginner
Error Handling in ETLMichael SextonBeginner
ETL as MDMMichael SextonIntermediate
Evaluate your daily Checklist with PBM and CMSJohn SterrettIntermediate
Execution Plans a Deep DiveGrant FritcheyAdvanced
Factors for Successful Business IntelligenceDave RodabaughBeginner
Form And Substance: The “T” of ETLMichael SextonIntermediate
Free SQL Tools for Your ToolboxKevin BullenBeginner
Fundamentals of Join OperationsKevin BolesBeginner
Getting Started with MDX William E. Pearson IIIBeginner
Getting Started With PowerShell and SQL Server Kevin BullenBeginner
Intro to Resource GovernorKevin BullenBeginner
Introduction to SQL Server Service BrokerAdam BelebczukBeginner
Join Us! Getting Started as a Technical SpeakerEddie WuerchBeginner
Little in the middle but got much [Write]BackJosh FennessyIntermediate
Lunch - Women In Technology SessionDave SchutzBeginner
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Model-Driven Database DesignKaren LopezBeginner
Monitoring Databases in a Virtual EnvironmentThomas LaRockIntermediate
Networking 101 for IT Pros: Let's get it done!Craig PurnellBeginner
Overcoming Barriers and Avoiding Mistakes with BIWilliam E. Pearson IIIBeginner
Page Latches for Mere MortalsEddie WuerchIntermediate
Parallel Query Execution Deep DiveKevin BolesAdvanced
Performance Tuning for PiratesJohn SterrettAdvanced
PowerPivot for ExcelWilliam E. Pearson IIIBeginner
Profiler? What is this tool you speak of?Jason SpanglerBeginner
Prototype with PowerPivot: External SSAS GroupsWilliam E. Pearson IIIIntermediate
Read Dirty to Me - Understanding IsolationWendy PastrickIntermediate
Read Dirty to Me - Understanding IsolationWendy PastrickIntermediate
Reciprocal Symmetry: MDX in PowerPivotWilliam E. Pearson IIIIntermediate
Registration/IntroDave SchutzBeginner
Serene Velocity: Reporting Services and SSAS Data William E. Pearson IIIIntermediate
So You Want a Career in Business Intelligence?Dave RodabaughBeginner
SQL Azure Andy ThiruBeginner
SQL InjectionKevin BolesIntermediate
SQL Server 101 for IT ProsCraig PurnellBeginner
SQL Server 2012 AlwaysOn Readable SecondariesAdam BelebczukIntermediate
SQL Server 2012 TSQL Enhancements and AdditionsKevin BolesIntermediate
SQL Server and Sharepoint: Best FrienemiesLisa GardnerIntermediate
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SRS Report Builder for Business IntelligenceDavid EichnerBeginner
SSIS: Figuring Out ConfiguringMike DonnellyIntermediate
SWAG Giveaway! Wrap UpDave SchutzBeginner
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
Top Tips for Writing Better T-SQL QueriesGrant FritcheyIntermediate
Transaction and Balance Facts: Identical CousinsDave RodabaughAdvanced
Transaction Log Deep DiveKevin BolesAdvanced
Transactional Replication 101Wendy PastrickBeginner
TSQL Road Less Traveled: MERGEKevin BolesIntermediate
TSQL Road Less Traveled: The Numbers TableKevin BolesIntermediate
Understanding And Eliminating SQL InjectionKevin FeaselIntermediate
Understanding SQL Server XML Features Randy KnightIntermediate
Understanding Transaction Isolation LevelsRandy KnightIntermediate
Upgrade Roadmap: Let’s delve into SQL Server 2012 Craig PurnellIntermediate
Visualizing Your Indexes - Science vs ArtWendy PastrickBeginner
What Counts For a DBALouis DavidsonBeginner
What is BI Semantic Model and why should you care?Jose ChinchillaIntermediate
What Sequence objects are (and are not)Louis DavidsonIntermediate
Windowing Functions: THE Reason to Upgrade to 2012Kevin BolesIntermediate


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