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 TimeMain Hall / Large Meeting Room - Room: TBDBI 1 - Room: 215BI 2 - Room: 217BI 3 - Room: 218DB Admin 1 - Room: 216ADB Admin 2 - Room: 219DB Admin 3 - Room: 218DB Development - Room: 101Professional Dev - Room: 113
08:00 AMStaff SQL Saturday

Registration / Check-In

Level: Beginner
        
08:15 AMStaff SQL Saturday

Opening Remarks

Level: Beginner
        
8:30 AM Rafael Salas

DW-ETL: 10 Mistakes to Avoid

Level: Beginner
John Welch

Do More (ETL) with Less (Effort) - Automating SSIS

Level: Intermediate
Jessica Moss

Introducing Microsoft's EDIM Products

Level: Beginner

download
Geoff Hiten

Fast Track Data Warehouse

Level: Intermediate
Kevin Goode

Deploying Visual Studio 2010 Database Projects

Level: Intermediate

download
Sandra Mueller

SSRS Administration - Enter a BIDS Free Zone

Level: Intermediate

download
Alex Tocitu

A Best Practice Approach to SQL Server CLR

Level: Intermediate
Jorge Segarra

SQL University: Class is in Session!

Level: Beginner

download
9:45 AM Julie Smith

Up and Running with SSIS in 5,4,3,2, (Datachix)1 !

Level: Beginner

download
William Pearson

Design and Implement BI Like Edison!

Level: Beginner
Andy Leonard

Designing an SSIS Framework

Level: Advanced
Allen White

Gather SQL Server Performance Data with PowerShell

Level: Intermediate

download
Chris Skorlinski

"Extra Eyes" with Microsoft Atlanta

Level: Beginner

download
Andrew Kelly

Configuring and Troubleshooting Tempdb

Level: Intermediate

download
Plamen Ratchev

Zen and the Art of Writing SQL Query

Level: Intermediate

download
Stuart Ainsworth

From DBA to Data Architect: Changing Your Game

Level: Beginner

download
11:00 AM Brian K McDonald

Reporting Services Deep Dive

Level: Beginner

download
Nathan Mourfield

SQL Developer's Intro to SSAS

Level: Beginner

download
Tejas Patel

Role of Microsoft Solver Foundation In BI

Level: Beginner

download
Brian Davis

Service Broker...What's That & How Do I Use It?

Level: Beginner

download
Geoff Hiten

Bad SQL

Level: Intermediate
Craig Purnell

Database Mirroring in the Real World

Level: Intermediate
Audrey Hammonds

T-SQL Awesomeness – 3 Ways to Write Cool SQL

Level: Intermediate

download
Jason Hall

Recipe for a happy DBA

Level: Beginner

download
12:15 PMAndy Leonard

Source Control for SQL Server (Red Gate Sponsored)

Level: Beginner
        
01:15 PM John Welch

Handling Advanced Data Warehouse Scenarios in SSIS

Level: Intermediate

download
Melissa Coates

Report Calcs - SSRS Source Query vs. Expressions

Level: Beginner

download
Cory Loriot

Powerful BI in SharePoint 2010

Level: Intermediate

download
Aaron Nelson

PowerShell for Data Professionals

Level: Intermediate
Tim Radney

You inherited a database, now what?

Level: Beginner

download
Ashton Hobbs

All about Indexes

Level: Intermediate
Stuart Ainsworth

Dirt, Spit, and Happy FLWOR: Hands on with XQuery.

Level: Intermediate

download
William E. Pearson III

Entity Strategies: Structuring Your Consultancy

Level: Beginner
02:30 PM Mark Tabladillo

Enterprise Data Mining for SQL Servr Professionals

Level: Intermediate

download
Jessica Moss

Adding SSRS Report Bells and Whistles

Level: Intermediate

download
Wayne Snyder

Information: Are You Blinded by the Light ?

Level: Advanced
Ed Wilson

Windows PowerShell Best Practices for DBA's

Level: Beginner

download
Steve Wright

Shade Tree Mechanic's Guide to SSAS

Level: Beginner

download
Sergey Pustovit

SQL Server Internals - how things work?

Level: Advanced
Brett Tomson

Introduction to Microsoft StreamInsight

Level: Beginner

download
David Taylor

To click or to type, that is the question

Level: Beginner

download
03:45 PM Andy Leonard

“I See a Control Flow Tab. Now What?”

Level: Beginner
Javier Guillen

DAX Formulas: Evaluation Context

Level: Beginner

download
Barry Ralston

PowerPivot, Idea to Solution in 60 Minutes

Level: Beginner
Allen White

Automate Policy-Based Management using PowerShell

Level: Intermediate

download
Sergey Pustovit

New features in SQL Server Denali

Level: Beginner
David Bermingham

Making sense of SQL Server availability options

Level: Beginner
Plamen Ratchev

Common SQL Programming Mistakes

Level: Intermediate

download
Audrey Hammonds

Down With Ugly Data - Relational Modeling Basics

Level: Beginner

download
04:45 PMStaff SQL Saturday

Closing Remarks / Raffle

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
"Extra Eyes" with Microsoft AtlantaChris SkorlinskiBeginner
(B)locking in SQL ServerAshton HobbsIntermediate
(SSIS, TSQL and MDS) - Record Linkage(Fuzzy MatchIra WhitesideIntermediate
“I See a Control Flow Tab. Now What?” Andy LeonardBeginner
A Best Practice Approach to SQL Server CLRAlex TocituIntermediate
Adding SSRS Report Bells and WhistlesJessica MossIntermediate
All about IndexesAshton HobbsIntermediate
An Overview of PowerPivot for Excel William PearsonIntermediate
An Overview of PowerPivot in SharePoint William PearsonIntermediate
An Overview of PowerPivot in SharePoint William PearsonIntermediate
Attribute Discretization in Analysis Services (BI)William PearsonIntermediate
Automate Policy-Based Management using PowerShellAllen WhiteIntermediate
Bad SQLGeoff HitenIntermediate
Become Bilingual! Oracle for the SQL Server DBARandy KnightIntermediate
Becoming DAX: An Introduction ...William E. Pearson IIIBeginner
Beyond Plateaux: Optimize SSAS via Best PracticesWilliam E. Pearson IIIIntermediate
Business Intelligence Solutions with PowerPivotBarry RalstonBeginner
Closing Remarks / RaffleStaff SQL SaturdayBeginner
Common SQL Programming MistakesPlamen RatchevIntermediate
Configuring and Troubleshooting Tempdb Andrew KellyIntermediate
Creating a Metadata Mart w/ SSIS - Data GovernanceIra WhitesideIntermediate
Database Mirroring in the Real WorldCraig PurnellIntermediate
DAX Formulas: Evaluation ContextJavier GuillenBeginner
Deeper into Tabular Models - M-M and the "W"Wayne SnyderIntermediate
Deploying Visual Studio 2010 Database ProjectsKevin GoodeIntermediate
Design and Implement BI Like Edison! William PearsonBeginner
Designing an SSIS FrameworkAndy LeonardAdvanced
Developing Date and Role-Playing DimensionsSandra MuellerIntermediate
Dirt, Spit, and Happy FLWOR: Hands on with XQuery.Stuart AinsworthIntermediate
Do More (ETL) with Less (Effort) - Automating SSISJohn WelchIntermediate
Do You Know the Data Flow?John WelchIntermediate
Documenting Your Integrated Microsoft BI SolutionWilliam PearsonIntermediate
Down With Ugly Data - Relational Modeling BasicsAudrey HammondsBeginner
DW-ETL: 10 Mistakes to AvoidRafael SalasBeginner
Enterprise Data Mining for SQL Servr ProfessionalsMark TabladilloIntermediate
Enterprise Text Mining with Analysis ServicesMark TabladilloIntermediate
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Fast Track Data WarehouseGeoff HitenIntermediate
From DBA to Data Architect: Changing Your GameStuart AinsworthBeginner
Gather SQL Server Performance Data with PowerShellAllen WhiteIntermediate
Getting Started with MDXWilliam PearsonIntermediate
Growing Pains - A Cautionary TaleBrett TomsonIntermediate
Handling Advanced Data Warehouse Scenarios in SSISJohn WelchIntermediate
How SQL Saved my Business Intelligence StrategyScott SchledwitzBeginner
Information: Are You Blinded by the Light ?Wayne SnyderAdvanced
Integrating SQL Server with Active DirectoryCraig PurnellIntermediate
Introducing Microsoft's EDIM ProductsJessica MossBeginner
Introduction to Microsoft StreamInsightBrett TomsonBeginner
Let Service Broker Help You Scale Your ApplicationAllen WhiteIntermediate
Making sense of SQL Server availability optionsDavid BerminghamBeginner
Many-to-Many: Multiple Calendars in a Single Cube William PearsonAdvanced
Multisite Clusters for HA and Disaster RecoveryDavid BerminghamBeginner
New features in SQL Server DenaliSergey PustovitBeginner
Opening RemarksStaff SQL SaturdayBeginner
Policy-Based Management in a NutshellJorge SegarraBeginner
Powerful BI in SharePoint 2010Cory LoriotIntermediate
PowerPivot, Idea to Solution in 60 Minutes Barry RalstonBeginner
PowerShell for Data ProfessionalsAaron NelsonIntermediate
Predictive Programming Using SQL08 R2 Data MiningTejas PatelBeginner
QL Server “Denali” High AvailabilityGeoff HitenIntermediate
Recipe for a happy DBAJason HallBeginner
Registration / Check-InStaff SQL SaturdayBeginner
Report Calcs - SSRS Source Query vs. ExpressionsMelissa CoatesBeginner
Reporting Services Deep DiveBrian K McDonaldBeginner
Resource Governor for SQL Server 2008Steve WrightBeginner
Role of Microsoft Solver Foundation In BITejas PatelBeginner
Service Broker...What's That & How Do I Use It?Brian DavisBeginner
Shade Tree Mechanic's Guide to SSASSteve WrightBeginner
Slipstreaming SQL ServerCraig PurnellBeginner
Source Control for SQL Server (Red Gate Sponsored)Andy LeonardBeginner
SQL Azure - Cloud Database Coolness Scott KleinIntermediate
SQL Developer's Intro to SSASNathan MourfieldBeginner
SQL Server 2008 R2 Parallel Data WarehouseSergey PustovitBeginner
SQL Server Internals - how things work?Sergey PustovitAdvanced
SQL Server Management Data Warehouse (MDW)Sergey PustovitIntermediate
SQL University: Class is in Session!Jorge SegarraBeginner
SSIS in 'Denali': The New Project Deployment ModelRafael SalasBeginner
SSRS Administration - Enter a BIDS Free ZoneSandra MuellerIntermediate
The Career Your Career Could Smell LikeShannon LowderBeginner
The Odd and the Strange with T-SQLNathan MourfieldIntermediate
Things to do in SQL when you’re dead(locked)Kevin GoodeBeginner
Things your mom never told you about replicationJason HallIntermediate
Things Your Mom Never Told You About SSMSJason HallIntermediate
To click or to type, that is the question David TaylorBeginner
T-SQL Awesomeness – 3 Ways to Write Cool SQLAudrey HammondsIntermediate
T-SQL Enhancements in DenaliPlamen RatchevIntermediate
Understanding Indexes in SQL Server 2008Andrew KellyIntermediate
Up and Running with SSIS in 5,4,3,2, (Datachix)1 !Julie SmithBeginner
Using Confio Ignite 8 for Production FailuresDale CunninghamIntermediate
Using PowerPivot to Prototype BI projectsJavier GuillenBeginner
Visual Studio 2010 Database ProjectsRandy KnightIntermediate
Who Needs a Data Warehouse?Jessica MossBeginner
Windows PowerShell Best Practices for DBA'sEd WilsonBeginner
You inherited a database, now what?Tim RadneyBeginner
Zen and the Art of Writing SQL QueryPlamen RatchevIntermediate
Zero to Analytics-SharePoint Business IntelligenceAdam JorgensenBeginner


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