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 - Room: Room 4Database Development - Room: Room 3DBA - Room: Room 1DBA/DEV Advanced - Room: Room 2Professional Development - Room: Room 5
08:30 AMJose Chinchilla

Business Intelligence: Decaffeinated Please!

Level: Beginner
Joel Cochran

SSIS for real: A walk through a real world project

Level: Beginner
Jeremiah Peschka

Fundamentals of SQL Server Internals

Level: Beginner
Allen White

Automate Policy-Based Management using PowerShell

Level: Advanced
Andy Leonard

Some Thoughts on Managing Teams

Level: Intermediate
09:45 AMMatt Van Horn

SSRS Interactive Reports

Level: Beginner
Joel Cochran

Intro to C# for the SSIS Script Component

Level: Beginner
Sandra Mueller

Data Files and Transaction Logs – Beyond the GUIs

Level: Beginner
Allen White

Gather SQL Server Performance Data with PowerShell

Level: Advanced
Steve Radich

A better way to store and archive SQL Backups

Level: Intermediate
11:00 AMKevin Goff

Introduction to PowerPivot

Level: Beginner
John Sterrett

Monitor your SQL Server farm with PBM and CMS

Level: Beginner
Kendra Little

Table Partitioning: Evaluation, Planning, Options

Level: Beginner
Edwin Sarmiento

DBA Disaster Recovery Techniques To Keep Handy

Level: Advanced
Michael Coles

Sell Yourself Into An Interview!

Level: Beginner
01:00 PMWilliam Pearson

Design and Implement BI Like Edison!

Level: Beginner
Joseph Dantoni

Deploying Data Tier Applications with SQL 2k8 R2

Level: Intermediate

download
Jana Sattainathan

Partitioning in SQL Server 2005/2008

Level: Intermediate

download
Jared Nielsen

SQL and SEO - the FUZION of data and marketing

Level: Intermediate

download
Edwin Sarmiento

Presentation WOW!

Level: Beginner
02:15 PMJohn Welch

Processing Flat Files with SSIS

Level: Intermediate
Andy Leonard

Introduction to Incremental Loads

Level: Intermediate
Sergey Pustovit

SQL Server Performance Related DMVs

Level: Intermediate
Michael Coles

Introduction to SQL Server Spatial Data

Level: Intermediate
Jose Chinchilla

Get Cert! Get Cred!

Level: Beginner
03:30 PMKevin Goff

Applied MDX in OLAP applications

Level: Intermediate
Karen Lopez

Database Design Contentious Issues

Level: Intermediate

download
Thomas LaRock

Performance Tuning Made Easy

Level: Intermediate
Tim Chapman

Writing faster queries

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
A better way to store and archive SQL BackupsSteve RadichIntermediate
Applied MDX in OLAP applicationsKevin GoffIntermediate
Attribute Discretization in Analysis ServicesWilliam PearsonBeginner
Automate Policy-Based Management using PowerShellAllen WhiteAdvanced
Build Your First SSIS Package Andy LeonardBeginner
Build Your Own Search Engine With SQL ServerMichael ColesIntermediate
Business Intelligence: Decaffeinated Please!Jose ChinchillaBeginner
Capturing SQL Server performance diagnosticsTim ChapmanAdvanced
Change Data Capture in SQL 2008Kevin GoffIntermediate
Cool Reporting Features in SSRS 2008R2 Kevin GoffIntermediate
Cracking Open Project Server OLAP Cube using VSMichael WhartonIntermediate
Data Files and Transaction Logs – Beyond the GUIs Sandra MuellerBeginner
Database Design Contentious IssuesKaren LopezIntermediate
Database Design for DevelopersAndy LeonardIntermediate
DBA Disaster Recovery Techniques To Keep HandyEdwin SarmientoAdvanced
Deep Dive in SQL ProfilerMichael WhartonIntermediate
Deploying Data Tier Applications with SQL 2k8 R2Joseph DantoniIntermediate
Design and Implement BI Like Edison!William PearsonBeginner
Do You Know the Data Flow?John WelchBeginner
Documenting Your Integrated Microsoft BI Solution William Pearson, CPA, CITP,CMA, CIA, MCSE, MCDBA, MVPIntermediate
Fundamentals of SQL Server InternalsJeremiah PeschkaBeginner
Gather SQL Server Performance Data with PowerShellAllen WhiteAdvanced
Get Cert! Get Cred!Jose ChinchillaBeginner
Getting Started with MDXWilliam PearsonBeginner
How, where, why, and when to use Dynamic SQLTim ChapmanIntermediate
Intro to C# for the SSIS Script ComponentJoel CochranBeginner
Intro to T-SQL ProgrammingMatt Van HornBeginner
Introduction to Analysis Services 2008Mark HudsonBeginner
Introduction to Incremental Loads Andy LeonardIntermediate
Introduction to PowerPivotKevin GoffBeginner
Introduction to SQL Server Spatial DataMichael ColesIntermediate
Jump Start Your SQL Server CareerJeremy KadlecBeginner
Managing SSRS using RS.exeRussel LoskiIntermediate
Many-to-Many: Multiple Calendars in a Single CubeWilliam PearsonIntermediate
Modeling Muddy DataJeremiah PeschkaBeginner
Monitor SQL Server with SSRS / SilverlightAlex TocituAdvanced
Monitor your SQL Server farm with PBM and CMSJohn SterrettBeginner
Moving Data with SQL Azure and SSISJohn WelchIntermediate
OLTP (yes!) Databases and Cube Design Sandra MuellerBeginner
Partitioning in SQL Server 2005/2008Jana SattainathanIntermediate
Performance Tuning Made EasyThomas LaRockIntermediate
Presentation WOW!Edwin SarmientoBeginner
Processing Flat Files with SSISJohn WelchIntermediate
Refactoring SQL ApplicationsJeremiah PeschkaBeginner
Report Builder 2.0Mark HudsonBeginner
Report Services Admin (no BIDs)Sandra MuellerBeginner
Secure Your Data @ Rest!Michael ColesIntermediate
SelfService Analytics with Excel 2010 & PowerPivotEdwin SarmientoBeginner
Sell Yourself Into An Interview!Michael ColesBeginner
Service BrokerSandra MuellerBeginner
Some Thoughts on Managing TeamsAndy LeonardIntermediate
SQL and SEO - the FUZION of data and marketingJared NielsenIntermediate
SQL Server 2008 for DevelopersJohn SterrettBeginner
SQL Server 2008 R2 for DBAsJeremy KadlecIntermediate
SQL Server 2008 R2 Parallel Data WarehouseSergey PustovitIntermediate
SQL Server CLR Best PracticesAlex TocituIntermediate
SQL Server Performance Related DMVsSergey PustovitIntermediate
SSIS and Excel 2007, the pains, trials and truth Sandra MuellerIntermediate
SSIS and SSRS Better TogetherRussel LoskiIntermediate
SSIS Design Patterns Andy LeonardAdvanced
SSIS for real: A walk through a real world projectJoel CochranBeginner
SSRS Interactive ReportsMatt Van HornBeginner
Stay Agile, Stay SaneKendra LittleBeginner
Stored procedure tracing using the xml datatype Russel LoskiIntermediate
Table Partitioning: Evaluation, Planning, OptionsKendra LittleBeginner
Three cool packages in SSIS 2008Kevin GoffIntermediate
Transact-SQL 2008 - Attendees pick the topics!Kevin GoffIntermediate
Windows PowerShell for the SQL Server DBAEdwin SarmientoIntermediate
Word-Of-Mouth Marketing For The SQL Server GuyEdwin SarmientoBeginner
Writing faster queriesTim ChapmanAdvanced
XQuery BasicsAllen WhiteBeginner


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.

Suggested Session TitleSkill Level
Source Control and SQL ServerBeginner

SQLSaturday Home
PASS