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 1 - Room: UP3206BI 2 - Room: UP3207DBA 1 - Room: UP4104DBA 2 - Room: UP4105Misc - Room: UP3205Performance - Room: UP3208SSIS - Room: UP4103
08:30 AMMichael Antonovich

Introduction to PowerPivot for Excel

Level: Beginner

download
William E. Pearson III

Getting Started with MDX

Level: Beginner
Don Stevic

The Fundamentals of DBA-ism

Level: Beginner

download
Buck Woody

From Ground to Cloud for Databases

Level: Beginner
Andy Warren

Building a Professional Development Plan

Level: Beginner

download
Erin Stellato

You’re My Density: Making Sense of Statistics

Level: Beginner
Bradley Schacht

Introduction to SSIS

Level: Beginner
09:45 AMDavid Liebman

0 to SSRS Presentation

Level: Beginner
Adam Jorgensen

Analysis - 0 to PowerPivot

Level: Beginner
Kendal Van Dyke

Working With XML In SQL Server

Level: Intermediate

download
Daniel Taylor

Useful tools for a DBA and or Database Developer

Level: Beginner

download
Michael Wells

Rapidly Deploying SQL Server with PowerShell

Level: Beginner
Janis Griffin

Performance Management – 2008 MDW - How & Why

Level: Beginner

download
Eric Wisdahl

SSIS Data Flow Buffer Breakdown

Level: Intermediate
11:00 AMRob Collie

PowerPivot: BI & Massive Data Analysis for Humans

Level: Beginner

download
Phillip E. Rosen

Biz Intel Dashboards W/Excel OLAP formulas

Level: Beginner
Rodney Landrum

T-SQL Alphabet Soup

Level: Beginner
Craig Purnell

Upgrade Roadmap: Taking YOU to R2

Level: Beginner

download
Ronald Dameron

Powershell by Example

Level: Intermediate

download
Nathan Heaivilin

Introduction to Execution Plan

Level: Beginner
Mike Davis

Using Script Task and Components in SSIS

Level: Advanced

download
12:45 PMBob Abernethy

Mission Possible: Pervasive BI

Level: Beginner
 Russ Fustino

Reporting in Silverlight

Level: Beginner
Janis Griffin

Sql Server On VMware???

Level: Beginner

download
 Herve Roggero

SQL Azure Performance Considerations

Level: Beginner
 
01:30 PMKyle Walker

SSRS Subscriptions

Level: Beginner

download
Robert Biddle

Loading a Data Warehouse with SSIS

Level: Intermediate

download
Norm Bowen

Data Conversions: Steps, Tips and Best Practices

Level: Beginner

download
Bradley Ball

Page & Row Compression Deep Dive

Level: Advanced
Chad Miller

Storing PowerShell Output

Level: Intermediate

download
Eddie Wuerch

TempDB Performance Troubleshooting and Optimizing

Level: Intermediate

download
Bradley Schacht

Dynamic SSIS: Configs, Expressions and Variables

Level: Beginner
02:45 PMWilliam E. Pearson III

Becoming DAX: An Introduction ...

Level: Intermediate
Jeff Garbus

Rewriting Bad Code

Level: Beginner

download
Patrick Thompson

Where to with NoSql

Level: Beginner

download
Rob Volk

Revenge: The SQL!

Level: Intermediate

download
Maximo Trinidad

Extend your T-SQL Scripting with PowerShell

Level: Intermediate
Kevin Boles

Parallel Query Execution Deep Dive

Level: Advanced

download
James McAuliffe

SSIShare The Code Man

Level: Advanced
04:00 PMChris Wolfley

Advancing Data Storage for Databases

Level: Beginner
Brian McDonald

Reporting Services Deep Dive

Level: Intermediate
Dmitri Korotkevitch

Data Sharding in OLTP Systems

Level: Advanced

download
Plamen Ratchev

T-SQL Enhancements in Denali

Level: Intermediate

download
Jorge Segarra

Policy-Based Management in a Nutshell

Level: Beginner
Kevin Boles

Transaction Log Deep Dive

Level: Advanced

download
Mike Davis

SQL Smackdown SSIS vs T-SQL

Level: Intermediate


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
0 to SSRS PresentationDavid LiebmanBeginner
Advanced TSQL SolutionsKevin BolesAdvanced
Advancing Data Storage for DatabasesChris WolfleyBeginner
An Introductory Look at Execution PlansEric WisdahlIntermediate
An Overview of PowerPivot in SharePointWilliam E. Pearson IIIIntermediate
Analysis - 0 to PowerPivotAdam JorgensenBeginner
Anti-patterns in Database design and T-Sql codeDmitri KorotkevitchIntermediate
Applying FastTrack & PDW Best Practices to your DWBrian MitchellIntermediate
As a DBA, Where Do I Start?!?Mike WalshBeginner
Attribute Discretization in Analysis Services (BI)William E. Pearson IIIIntermediate
Baseline Basics: Where to Start, What You NeedErin StellatoBeginner
Becoming DAX: An Introduction ... William E. Pearson IIIIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Beyond Plateaux: Optimize SSAS with Best PracticesWilliam E. Pearson IIIIntermediate
Biz Intel Dashboards W/Excel OLAP formulasPhillip E. RosenBeginner
Building a Professional Development PlanAndy WarrenBeginner
Checklist for 1st time on-call DBA’sDaniel TaylorBeginner
Data Conversions: Steps, Tips and Best PracticesNorm BowenBeginner
Data Sharding in OLTP SystemsDmitri KorotkevitchAdvanced
Database Mirroring in the Real WorldCraig PurnellIntermediate
Design and Implement BI Like Edison!William E. Pearson IIIBeginner
Documenting Your Integrated Microsoft BI SolutionWilliam E. Pearson IIIIntermediate
Dynamic SSIS: Configs, Expressions and VariablesBradley SchachtBeginner
Entity Strategies: Structuring Your ConsultancyWilliam E. Pearson IIIBeginner
Extend your T-SQL Scripting with PowerShellMaximo TrinidadIntermediate
File IO Stalls and Wait Stats - Tune Like Guru!Kevin BolesAdvanced
From Ground to Cloud for DatabasesBuck WoodyBeginner
Fundamentals of Join OperationsKevin BolesBeginner
Getting Started with MDXWilliam E. Pearson IIIBeginner
Iceberg, Dead Ahead!Mike WalshBeginner
Introduction to Execution PlanNathan HeaivilinBeginner
Introduction to PowerPivot for ExcelMichael AntonovichBeginner
Introduction to SSISBradley SchachtBeginner
Introduction to StatisticsAndy WarrenBeginner
It’s a Matter of Style: Coding with StylePlamen RatchevBeginner
Let’s talk about SQL PowerShellMaximo TrinidadBeginner
Loading a Data Warehouse with SSISRobert BiddleIntermediate
Looney Tuner? No, there IS a method to my madnessJanis GriffinBeginner
Many-to-Many: Multiple Calendars in a Single CubeWilliam E. Pearson IIIAdvanced
Mission Possible: Pervasive BIBob AbernethyBeginner
NoSQL- What is it and why do I care?Craig PurnellBeginner
Page & Row Compression Deep DiveBradley BallAdvanced
Page and Row Compression How, When, and WhyBradley BallIntermediate
Parallel Query Execution Deep DiveKevin BolesAdvanced
Performance Management – 2008 MDW - How & WhyJanis GriffinBeginner
Pivot Tables & Charts from T-SQL thru SharePointMichael AntonovichIntermediate
Policy-Based Management in a NutshellJorge SegarraBeginner
PowerPivot for ExcelWilliam E. Pearson IIIBeginner
PowerPivot: BI & Massive Data Analysis for HumansRob CollieBeginner
Powershell by ExampleRonald DameronIntermediate
Practical Hierarchies: The Social NetworkPlamen RatchevAdvanced
Rapidly Deploying SQL Server with PowerShellMichael WellsBeginner
Reporting in Silverlight Russ FustinoBeginner
Reporting Services Deep DiveBrian McDonaldIntermediate
Revenge: The SQL!Rob VolkIntermediate
Rewriting Bad CodeJeff GarbusBeginner
Scaling your BI solutionBrian MitchellIntermediate
Serene Velocity: Reporting Services and SSAS DataWilliam E. Pearson IIIAdvanced
SQL as an External Data Source for SharePointMichael AntonovichIntermediate
SQL Azure Performance ConsiderationsHerve RoggeroBeginner
SQL InjectionKevin BolesIntermediate
SQL Server - Good enough for government workRonald DameronBeginner
Sql Server On VMware??? Janis GriffinBeginner
Sql Server On VMware??? Janis GriffinBeginner
SQL Server Service Broker – An OverviewJanis GriffinIntermediate
SQL Smackdown SSIS vs T-SQLMike DavisIntermediate
SQL University: Back That Thang Up!Jorge SegarraBeginner
SSIS - Analyzing your data integrating PowerShellMax TrinidadIntermediate
SSIS Data Flow Buffer BreakdownEric WisdahlIntermediate
SSIShare The Code ManJames McAuliffeAdvanced
SSRS SubscriptionsKyle WalkerBeginner
Storing PowerShell OutputChad MillerIntermediate
Take Charge of your Career!Craig PurnellBeginner
TempDB Performance Troubleshooting and OptimizingEddie WuerchIntermediate
The Art of the TraceDon StevicIntermediate
The Fundamentals of DBA-ism Don StevicBeginner
Transaction Log Deep DiveKevin BolesAdvanced
T-SQL Alphabet SoupRodney LandrumBeginner
T-SQL Enhancements in DenaliPlamen RatchevIntermediate
Upgrade Roadmap: Taking YOU to R2Craig PurnellBeginner
Useful tools for a DBA and or Database Developer Daniel TaylorBeginner
Using Script Task and Components in SSISMike DavisAdvanced
Where to with NoSqlPatrick ThompsonBeginner
Who's Responsible? The Vendor or the DBA?Mike WalshBeginner
Working With XML In SQL Server Kendal Van DykeIntermediate
You Can Improve Your Own SQL Code!Mike WalshBeginner
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