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: SSISTrack 2 - Room: BI (SSAS/SSRS)Track 3 - Room: DBA (Monitoring/Optimization)Track 4 - Room: Application DevelopmentTrack 5 - Room: Introductory TopicsTrack 6 - Room: DBA
8:30 AMAndy Leonard

Build Your First SSIS Package

Level: Beginner

download
Rafael Salas

Dimensional Modeling: Why Should You Care?

Level: Beginner

download
Sergey Pustovit

SQL Server Performance Related DMVs

Level: Intermediate

download
Kevin Boles

Common TSQL Programming Mistakes

Level: Intermediate

download
Flavio Almeida

Self-Service BI with PowerPivot

Level: Beginner
Geoff Hiten

Clustering for Mere Mortals

Level: Intermediate

download
9:45 AMJohn Welch

Processing Flat Files with SSIS

Level: Intermediate

download
Mark Tabladillo

Data Mining with PowerPivot 2010

Level: Intermediate

download
Jana Sattainathan

Partitioning in SQL Server 2005/2008

Level: Intermediate

download
Tim Chapman

How, where, why, and when to use Dynamic SQL

Level: Intermediate

download
Jessica Moss

Who Needs a Data Warehouse?

Level: Beginner

download
Aaron Nelson

The Dirty Dozen: PowerShell Scripts for Busy DBAs

Level: Beginner

download
11:00 AMChris Skorlinski

Introduction to Change Data Capture

Level: Beginner

download
Mark Tabladillo

Document Classification using DMX in SSAS

Level: Intermediate

download
Andrew Kelly

Maximizing Plan Re-use in SQL 2008

Level: Intermediate

download
Kevin Goode

Embracing the CLR

Level: Intermediate

download
Mike Davis

Reporting Services 2008 R2, the New Stuff

Level: Beginner

download
Eric Humphrey

Object Relational Mappers for the DBA

Level: Beginner

download
01:00 PMJohn Welch

Patterns for SSIS Configuration and Deployment

Level: Intermediate

download
William Pearson

Attribute Discretization in Analysis Services

Level: Intermediate

download
Grant Fritchey

Identifying and Fixing Performance Problems using

Level: Intermediate

download
Andy Leonard

Database Design for Developers

Level: Intermediate

download
Jason Hall

Recipe for a Happy DBA - A Guide for SQL Server De

Level: Beginner

download
Ed Wilson

Windows PowerShell Best Practices for SQL DBA's

Level: Intermediate

download
02:15 PMAndy Leonard

SSIS Design Patterns

Level: Advanced

download
Steve Wright

The Shade Tree Mechanic's Guide to SSAS

Level: Beginner

download
Thomas LaRock

Performance Tuning Made Easy

Level: Intermediate

download
Allen White

XQuery Basics

Level: Beginner

download
Geoff Hiten

Bad SQL

Level: Intermediate

download
Andrew Kelly

SQL Server Configuration Best Practices

Level: Beginner

download
3:30 PMChris Skorlinski

Integrating CDC and SSIS for Incremental Data Load

Level: Advanced

download
Mike Davis

Using Parameters in SQL Server Reporting Services

Level: Beginner

download
Kevin Goode

Statistics, how to prove everything but the truth.

Level: Intermediate

download
Kevin Boles

Advanced TSQL Solutions

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
How, where, why, and when to use Dynamic SQLTim ChapmanIntermediate
Advanced TSQL SolutionsKevin BolesAdvanced
Attribute Discretization in Analysis ServicesWilliam PearsonIntermediate
Automate SQL Server Administration with PowerShellAllen WhiteIntermediate
Avoiding Disaster--Clusterining and Mirroring Joseph D'AntoniIntermediate
Bad SQLGeoff HitenIntermediate
Build Your First SSIS Package Andy LeonardBeginner
Clustering for Mere MortalsGeoff HitenIntermediate
Common TSQL Programming MistakesKevin BolesIntermediate
Consolidated SQL Server ArchitecturesBen DeBowBeginner
Creating Custom Components for SSISJohn WelchIntermediate
Data Mining with PowerPivot 2010Mark TabladilloIntermediate
Data Mining with PowerPivot 2010Mark TabladilloIntermediate
Database Design for Developers Andy LeonardIntermediate
Delivering BI Solutions Rapidly using VulcanJohn WelchIntermediate
De-mystifying Query Plan AnalysisDave TurpinIntermediate
Design and Implement Like Edison!William PearsonBeginner
Diagnosing connectivity issues with SQL ServerEvan BasalikIntermediate
Dimensional Modeling: Why Should You Care?Rafael SalasBeginner
Document Classification using DMX in SSASMatthew DuffieldIntermediate
Document Classification using DMX in SSASMark Tabladillo Intermediate
Documenting Your Integrated Microsoft BI SolutionWilliam PearsonBeginner
Dynamics CRM & SSRSEric HumphreyBeginner
Embracing the CLRKevin GoodeIntermediate
Extract, Transform, and Load your Data WarehouseJessica MossBeginner
Fortress SQL Server Brian KelleyIntermediate
Fuzzy logic and Conformed DimensionsMatthew DuffieldIntermediate
Fuzzy logic and Conformed DimensionsMatthew DuffieldIntermediate
Gather SQL Server Performance Data with PowerShellAllen WhiteAdvanced
How, where, why, and when to use Dynamic SQLTim ChapmanIntermediate
Identifying and Fixing Performance Problems using Grant FritcheyIntermediate
Integrating CDC and SSIS for Incremental Data LoadChris SkorlinskiAdvanced
Introduction to Change Data CaptureChris SkorlinskiBeginner
Introduction to Incremental Loads Andy LeonardIntermediate
Introduction to Transactional ReplicationChris SkorlinskiBeginner
Make Reporting Services Work For YouJessica MossIntermediate
Managing Server Work Load with Resource GovernorFlavio AlmeidaBeginner
Maximizing Plan Re-use in SQL 2008Andrew KellyIntermediate
Migrate Data with PowerShell and SQL ServerAllen WhiteIntermediate
Monitoring Transactional Replication PerformanceChris SkorlinskiIntermediate
Object Relational Mappers for the DBAEric HumphreyBeginner
Parallel Query Execution Deep DiveKevin BolesAdvanced
Partitioning in SQL Server 2005/2008Jana SattainathanIntermediate
Patterns for SSIS Configuration and DeploymentJohn WelchIntermediate
Performance Tuning Made EasyThomas LaRockIntermediate
Planning your ETL architecture with SSISRafael SalasIntermediate
PowerShell 2.0 Beyond the Dirty DozenAaron NelsonIntermediate
Processing Flat Files with SSISJohn WelchIntermediate
Q & A -- Stump the SpeakersSQL SaturdayBeginner
Recipe for a Happy DBA - A Guide for SQL Server DeJason HallBeginner
Red Gate SoftwareSQL SaturdayBeginner
Replication Comparison - Then and NowJason HallIntermediate
Reporting Services 2008 R2, the New StuffMike DavisBeginner
RESTful DataChris EargleIntermediate
Say NO to Maintenance PlansAndrew KellyIntermediate
Schemas and Security, Oh My! Brian KelleyIntermediate
Self-Service BI with PowerPivotFlavio AlmeidaBeginner
SQL Azure: Your Data in the Cloud is a Good ThingEvan BasalikBeginner
SQL Server 2008/R2 OverviewSergey PustovitIntermediate
SQL Server Configuration Best PracticesAndrew KellyBeginner
SQL Server Diagnostics Tools Unleashed Sergey PustovitIntermediate
SQL Server Encryption Decrypted Brian KelleyIntermediate
SQL Server Memory Deep DiveKevin BolesAdvanced
SQL Server Performance Related DMVs Sergey PustovitIntermediate
SQL Server Utility environmentBen DeBowIntermediate
SSIS Design PatternsAndy LeonardAdvanced
SSIS Design PatternsAndy LeonardAdvanced
Statistics, how to prove everything but the truth.Kevin GoodeIntermediate
SWAG Give AwaySQL SaturdayBeginner
The Dirty Business of Auditing Brian KelleyIntermediate
The Dirty Dozen: PowerShell Scripts for Busy DBAsAaron NelsonBeginner
The Shade Tree Mechanic's Guide to SSASSteve WrightBeginner
Things To Do With PowerShell & SMOEric HumphreyBeginner
Top 5 fastest ways as DBA to get firedChris SkorlinskiBeginner
Top 5 fastest ways as DBA to get firedChris SkorlinskiBeginner
Trigger Happy Database SecurityBrian KelleyBeginner
Troubleshooting SSRS PerformanceEvan BasalikIntermediate
Unit Testing SSIS PackagesJohn WelchIntermediate
Using Parameters in SQL Server Reporting Services Mike DavisBeginner
Virtualizing SQL Best PracticesAmy StyersIntermediate
VS 2010 DB tools: Schema Management Made Easier!Rafael SalasBeginner
What’s New in Reporting Services 2008 and 2008 R2?William PearsonIntermediate
Who Needs a Data Warehouse?Jessica MossBeginner
Windows PowerShell Best Practices for SQL DBA'sEd WilsonIntermediate
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
Change ManagementIntermediate
Data Security and Encryption Deep Dive Intermediate
Merge ReplicationIntermediate
SSIS Deployment StrategiesIntermediate
Statistics and PerformanceIntermediate
Team Foundation Server for SQL SERVER 2008Intermediate

SQLSaturday Home
PASS