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 Time - Room: 104/Aud - Room: 202/203 - Room: 301 - Room: 302/303 - Room: 304 - Room: 305 - Room: 306 - Room: 307
08:30 AMBrad McGehee

Best Practices Every SQL Server DBA Must Know

Level: Beginner

download
Dev Nambi

Database Development: Keep It Agile, Not Fragile

Level: Intermediate

download
Argenis Fernandez

Troubleshooting SQL Server with SysInternals Tools

Level: Advanced

download
Benjamin Muller

Self-service BI with project 'Crescent'

Level: Beginner

download
Allen White

Gather SQL Server Performance Data with PowerShell

Level: Intermediate

download
Janis Griffin

Looney Tuner? No, there IS a method to my madness!

Level: Beginner

download
Rob Garrison

Exploring SQL 2008's MERGE

Level: Intermediate

download
Harry Chandra

Intro to SQL Server Mirroring and Log Shipping

Level: Beginner
10:15 AMBuck Woody

Hybrid Database Solutions with SQL Azure

Level: Intermediate
Carlos Bossy

Real-time Data Warehouse and Reporting

Level: Intermediate
Christina Leo

Working with Server Side Traces

Level: Intermediate

download
Rick Morelan

Basic Performance Tips and Gotchas

Level: Beginner

download
Karen Lopez

Database Design Contentious Issues

Level: Intermediate

download
Doug Lane

Devs are from Mars, Report Servers are from Venus

Level: Beginner
Erik Monchen

Scripting in SSIS

Level: Intermediate

download
Paul Turley

So you've built a cube...Now what? MDX essentials

Level: Beginner

download
12:00 PMSopheap Suy

Lunch: WIT -Panel Discussion

Level: Beginner

download
Greg Grow

Lunch: Medford Area Gathering

Level: Beginner
Greg Grow

Lunch: Medford Area Gathering

Level: Beginner
Oregon SQL Team

Lunch: Portland Area Gathering

Level: Beginner
Brandon Williams

Lunch: Bend Area Gathering

Level: Beginner
Ben Pickett

Lunch: Salem Area Gathering

Level: Beginner

download
Dan Guzman

Lunch: Eugene Area Gathering

Level: Beginner
Greg Grow

Lunch: Medford Area Gathering

Level: Beginner
1:15 PMHugo Kornelis

Advanced indexing

Level: Advanced

download
Kendra Little

No More Bad Dates: Working With Dates and Times

Level: Intermediate
Erin Stellato

You’re My Density: Making Sense of Statistics

Level: Beginner
Douglas Barrett

Data Warehousing Best Practices

Level: Advanced

download
Allen White

Let Service Broker Help You Scale Your Application

Level: Beginner

download
Tim Ford

The Periodic Table of Dynamic Management Objects

Level: Intermediate
Rob Farley

Deeper JOINs

Level: Intermediate
Mitchell Bottel

Want a promotion? It’s up to you!

Level: Beginner

download
03:00 PMJes Borland

Reporting Services 201: From Basic To WOW!

Level: Intermediate

download
Marc Beacom

Introduction to Analysis Services

Level: Beginner

download
Edwin Quick

Management Data Warehouse and Custom Collectors

Level: Intermediate

download
Robert Davis

10 Things all BI System Administrators Should Know

Level: Intermediate

download
Vern Rabe

Columnstore Indexes in SQL Server Denali

Level: Intermediate

download
Victor Isakov

Parallelism in SQL Server

Level: Intermediate
Sopheap Suy

SSIS Package Design: Choosing the Right Components

Level: Intermediate

download
Aaron Allison

SQL Driven Mobile Platforms

Level: Beginner
04:30 PMPaul Turley

Models, Cubes & Marts: how & why to choose

Level: Intermediate

download
Rob Farley

Bad Indexes

Level: Intermediate
John Huang

Multi-threading TSQL

Level: Advanced

download
Neil Hambly

Extended Events – New Age of Profiling

Level: Intermediate
Bill Fellows

Kama Sutra of SSIS: A guide to loving ETL

Level: Intermediate
Deepak Puri

Analyze and map spatial data with SQL Server 2008

Level: Intermediate

download
Steve Moss

SQL Server And Oracle

Level: Intermediate

download
Bilal Obeidat

Cube Monitoring & Load Balancing in MS-Adcenter

Level: Advanced

download


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
10 Things all BI System Administrators Should KnowRobert DavisIntermediate
A Peek At SQL Server Execution PlansEdwin SarmientoIntermediate
Advanced indexingHugo KornelisAdvanced
An Overview of PowerPivot William E. Pearson IIIBeginner
An Overview of PowerPivot in SharePoint William E. Pearson IIIIntermediate
Analyze and map spatial data with SQL Server 2008Deepak PuriIntermediate
Architectural Career PathsRobert DavisBeginner
Are your cubes really running?Erik MonchenIntermediate
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIIntermediate
Automate Policy-Based Management using PowerShellAllen WhiteAdvanced
Avoid Errors on ErrorsRick MorelanBeginner
Bad IndexesRob Farley Intermediate
Baseline Basics: Where to Start, What You NeedErin StellatoBeginner
Basic Performance Tips and GotchasRick MorelanBeginner
Becoming DAX: An Introduction ... William E. Pearson IIIIntermediate
Best Practices Every SQL Server DBA Must KnowBrad McGeheeBeginner
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Build a Scale-Out Reporting Services 2008 R2 FarmEdwin SarmientoIntermediate
Building Scalable and Well Performing DatabasesVictor IsakovBeginner
Business Intelligence for Managers/Decision MakersCarlos BossyBeginner
Columnstore Indexes in SQL Server DenaliVern RabeIntermediate
Cube Monitoring & Load Balancing in MS-Adcenter Bilal ObeidatAdvanced
Data Warehousing Best PracticesDouglas Barrett Advanced
Database AntipatternsSteve MossIntermediate
Database Design Contentious IssuesKaren LopezIntermediate
Database Development: Keep It Agile, Not FragileDev NambiIntermediate
Database Recovery Techniques To Keep HandyEdwin SarmientoAdvanced
Deeper JOINsRob FarleyIntermediate
Design and Implement BI Like Edison! William E. Pearson IIIBeginner
Developing a Tabular BI Semantic ModelPeter MyersIntermediate
Developing Rich Reporting Services VisualizationsPeter MyersIntermediate
Devs are from Mars, Report Servers are from VenusDoug LaneBeginner
Divide and Conquer: Federation 101Dev NambiBeginner
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Easily Manage your Servers with CMS and PMB Mitchell BottelBeginner
Effective Data Management using Data CompressionNeil HamblyBeginner
End-to-End PowerPivotPeter MyersBeginner
Enriching an Analysis Services 2008 R2 CubePeter MyersIntermediate
Enriching Applications with SSAS Data MiningPeter MyersAdvanced
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Excel 2010: everyman's OLAP client just got betterDeepak PuriBeginner
Exploring SQL 2008's MERGERob GarrisonIntermediate
Extended Events – New Age of ProfilingNeil HamblyIntermediate
Gather SQL Server Performance Data with PowerShellAllen WhiteIntermediate
Getting Started with MDXWilliam E. Pearson IIIBeginner
Gone Clustering in 60 MinutesEdwin SarmientoIntermediate
How is my business performing?Erik MonchenAdvanced
How to create your own data typeHugo KornelisAdvanced
How to Optimize tempb PerformanceBrad McGeheeIntermediate
How to Perform a SQL Server Health CheckBrad McGeheeIntermediate
Hybrid Database Solutions with SQL AzureBuck WoodyIntermediate
Important Trace Flags That Every DBA Should KnowVictor IsakovIntermediate
Indexing basicsHugo KornelisIntermediate
Integration Services in Project "Denali"Peter MyersIntermediate
Intro to SQL Server Mirroring and Log Shipping Harry ChandraBeginner
Introducing the New Features in SSRS 2008 R2Peter MyersIntermediate
Introduction to Analysis ServicesMarc BeacomBeginner
Introduction to Analysis Services 2008 R2 CubesPeter MyersIntermediate
Introduction to Integration ServicesMarc BeacomBeginner
Introduction to Reporting Services 2008 R2Peter MyersBeginner
Introduction to SQL TraceBrad McGeheeIntermediate
Let Service Broker Help You Scale Your ApplicationAllen WhiteBeginner
Looney Tuner? No, there IS a method to my madness!Janis GriffinBeginner
Lunch: Bend Area GatheringBrandon Williams Beginner
Lunch: Eugene Area GatheringDan GuzmanBeginner
Lunch: Medford Area GatheringGreg GrowBeginner
Lunch: Portland Area GatheringOregon SQL TeamBeginner
Lunch: Salem Area GatheringBen Pickett Beginner
Lunch: WIT -Panel DiscussionSopheap SuyBeginner
Make Your Voice Heard!Jes BorlandBeginner
Management Data Warehouse and Custom CollectorsEdwin QuickIntermediate
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Models, Cubes & Marts: how & why to choosePaul TurleyIntermediate
Multi-threading TSQLJohn HuangAdvanced
New Windowing functions in DenaliHugo KornelisIntermediate
No More Bad Dates: Working With Dates and TimesKendra LittleIntermediate
Parallelism in SQL ServerVictor IsakovIntermediate
Physical Database Design Guidelines Greg LarsenBeginner
PowerPivot for Excel William E. Pearson IIIBeginner
Real-time Data Warehouse and ReportingCarlos BossyIntermediate
Remote BLOB Storage: The Questions and the AnswersVictor IsakovBeginner
Replication Magic: Initializing From BackupsRobert DavisAdvanced
Report layout techniquesErik MonchenIntermediate
Reporting Services 201: From Basic To WOW!Jes BorlandIntermediate
Rolling Upgrades Leveraging Database MirroringArgenis FernandezIntermediate
Scripting in SSISErik MonchenIntermediate
Self-service BI with project 'Crescent'Benjamin MullerBeginner
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIIntermediate
So you've built a cube...Now what? MDX essentialsPaul TurleyBeginner
SQL Driven Mobile PlatformsAaron AllisonBeginner
SQL Respawn: Strategies for Migrating Your Server Argenis FernandezIntermediate
SQL Server And OracleSteve MossIntermediate
SQL Server FILSTREAMBen MillerIntermediate
Sql Server On VMware??? Janis GriffinIntermediate
SQL Server TDEBen MillerIntermediate
SSIS Package Design: Choosing the Right ComponentsSopheap SuyIntermediate
SSRS multi-language supportErik MonchenAdvanced
SSRS tips and tricksErik MonchenAdvanced
The ABC’s of Data WarehousingMarc BeacomBeginner
The Art of DashboardsErik MonchenIntermediate
The Periodic Table of Dynamic Management ObjectsTim FordIntermediate
Through the Looking-Glass with DMV'sGreg LarsenBeginner
Troubleshooting SQL Server with SysInternals ToolsArgenis FernandezAdvanced
Tune a Star Schema for High Performance ReportingCarlos BossyBeginner
Understanding Locking in SQL ServerVictor IsakovIntermediate
Visual Report Design: Bringing Sexy BackPaul TurleyIntermediate
Visualizing Your Indexes - Science vs ArtWendy PastrickBeginner
Want a promotion? It’s up to you!Mitchell BottelBeginner
Where are my customers?Erik MonchenIntermediate
WhereScape RED -IDE for Data WarehousesDouglas BarrettBeginner
Why are we Waiting..Neil HamblyAdvanced
Windows PowerShell for the SQL Server DBAEdwin SarmientoBeginner
Working with Project “Crescent”Peter MyersBeginner
Working with Server Side TracesChristina LeoIntermediate
XQuery BasicsAllen WhiteBeginner
You’re My Density: Making Sense of StatisticsErin StellatoBeginner


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