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: Session titles with an '*' have a download available.

Start TimeTrack 1 - Room: Room 1Track 2 - Room: Room 2Track 3 - Room: Room 3Track 4 - Room: Room 4
08:15 AMMatt Hester

Keynote*

Level: Beginner
   
09:15 AMDave Rodabaugh

Factors for Successful Business Intelligence

Level: Beginner
Louis Davidson

Database Design Fundamentals

Level: Intermediate
Allen White

XQuery Basics

Level: Beginner
Jeremiah Peschka

A Dynamic World Demands Dynamic SQL

Level: Intermediate
10:45 AMCraig Utley

PowerPivot: Delivering Self-Serve BI*

Level: Beginner
Louis Davidson

Database Design Patterns

Level: Intermediate
Brent Ozar

Performance Tuning for Race Car Drivers

Level: Advanced
Josh Fennessy

Building a functional Data Mart with SSIS

Level: Intermediate
12:00 PMLunch Time

Lunch and Sponsor Sessions

Level: Beginner
   
01:00 PMDave Rodabaugh

Star Schema Modeling Keys for Successful SSAS

Level: Advanced
Kevin Boles

Common TSQL Programming Mistakes *

Level: Intermediate
Brent Ozar

Hey Ma, Watch This: Useless and Dangerous Tricks

Level: Advanced
Allen White

Gather SQL Server Performance Data with PowerShell

Level: Advanced
02:30 PMCraig Utley

Do It Right: Best Practices for Analysis Services*

Level: Intermediate
Sam Nasr

Programming with FileStream Object*

Level: Intermediate
Jeremiah Peschka

Indexes and Other Free Performance Boosts

Level: Intermediate
Alexander Prusakov

Comparing Clustering Methods for SQL Server *

Level: Intermediate
03:45 PMCraig Utley

Avoid Slow SSAS Queries: MDX Query Troubleshooting*

Level: Advanced
Kevin Boles

Advanced TSQL Solutions *

Level: Advanced
Paul Hiles

DMVs- What are they and why should a DBA care?

Level: Beginner
Timothy Beamer

Disaster Recovery for your SQL Environment*

Level: Intermediate
5:00 PMDave Schutz

Wrap Up/Prize 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
A Dynamic World Demands Dynamic SQLJeremiah PeschkaIntermediate
Add It Up: Analysis Services AggregationsCraig UtleyAdvanced
Advanced TSQL Solutions Kevin BolesAdvanced
Analysis Services 2008 End-to-EndCraig UtleyBeginner
Automate SQL Server Administration with PowerShellAllen WhiteIntermediate
Avoid Slow SSAS Queries: MDX Query TroubleshootingCraig UtleyAdvanced
BI DevelopmentSam NasrIntermediate
BLITZ! One Hour SQL Server TakeoversBrent OzarIntermediate
Building a functional Data Mart with SSISJosh FennessyIntermediate
Common TSQL Programming Mistakes Kevin BolesIntermediate
Comparing Clustering Methods for SQL Server Alexander PrusakovIntermediate
Database Design FundamentalsLouis DavidsonIntermediate
Database Design Patterns Louis DavidsonIntermediate
Delivering BI DataCraig UtleyBeginner
Disaster Recovery for your SQL EnvironmentTimothy BeamerIntermediate
DMVs- What are they and why should a DBA care? Paul HilesBeginner
Do It Right: Best Practices for Analysis ServicesCraig UtleyIntermediate
Entity Framework 2010Sam NasrIntermediate
Factors for Successful Business IntelligenceDave RodabaughBeginner
Fundamentals of SQL Server InternalsJeremiah PeschkaIntermediate
Gather SQL Server Performance Data with PowerShellAllen WhiteAdvanced
Got BI?Sean HullIntermediate
Hard Lessons Learned from Data Conversion ProjectsAustin ZellnerBeginner
Hey Ma, Watch This: Useless and Dangerous TricksBrent OzarAdvanced
High-Availability Options for SQL ServerTimothy BeamerIntermediate
Indexes and Other Free Performance BoostsJeremiah PeschkaIntermediate
Intro to SQL Reporting Services 2008Matt Van HornBeginner
Introduction to WCF Data Services and ODataDavid HoersterBeginner
KeynoteMatt HesterBeginner
Lunch and Sponsor SessionsLunch TimeBeginner
Maintaining a Mirrored Database Tips and TricksPaul HilesIntermediate
Managing Tempdb ContentionAnthony DawsonIntermediate
Multiple Instance Consolidation PracticesAlexander PrusakovIntermediate
Parallel Query Execution Deep Dive Kevin BolesAdvanced
Performance Tuning for Race Car DriversBrent OzarAdvanced
PowerPivot: Delivering Self-Serve BICraig UtleyBeginner
Programming with FileStream ObjectSam NasrIntermediate
SQL Server - Disk performance tuningPrakash HedaIntermediate
SQL Server 2008 EncryptionAdam ClarkBeginner
SQL Server 2008 table paritioning Adam ClarkIntermediate
SQL Server Memory Deep Dive Kevin BolesAdvanced
SQL Server Service Broker - An OverviewJanis GriffinIntermediate
SQL Server Spatial Data - Getting StartedDan CrawfordIntermediate
SSRS Interactive ReportsMatt Van HornIntermediate
Star Schema Modeling Keys for Successful SSASDave RodabaughAdvanced
Storage Area Networks (SANs) for DBAsBrent OzarBeginner
Test PresentationAndy WBeginner
Tuna Helper for SQL Server DBA'sJanis GriffinIntermediate
Use PowerShell to Get the Most out of SQL ServerAllen WhiteBeginner
Wait-Time Based SQL Server Performance ManagementBronwyn AltizerIntermediate
Why Data Warehousing Projects FailCraig UtleyBeginner
Wrap Up/Prize RaffleDave SchutzBeginner
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
Disaster Recovery for your SQL EnvironmentIntermediate
High-Availability Options for SQL ServerIntermediate