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 TimeBusiness IntelligenceCafeteriaDatabase AdministrationDatabase DevelopmentProfessional DevelopmentSession Mix
08:30 AMRafael Salas
Planning your ETL architecture with SSIS
Thomas LaRock
DBA Survivor*
Aaron Nelson
The Dirty Dozen: PowerShell Scripts for Busy DBAs*
Allen White
XQuery Basics*
Andy Warren
Building a Professional Development Plan
Alan Brewer
SQL Server 2008 R2 Utility and Data-tier Apps*
9:45 AMDouglas McDowell
Realizing ROI for Business Intelligence Projects*
 Allen White
Gather SQL Server Performance Data with PowerShell*
William Pearson
Design and Implement Like Edison!
Stuart Ainsworth
The Social DBA: Resources for Career Building*
Andy Leonard
Database Design for Developers*
11:00 AMWayne Snyder
Information Visualization - Designing great Charts*
 Jason Strate
Are You Following Your Own Best Practices?
Hope Foley
Working with Spatial Data in SQL Server 2008 *
Mark Tabladillo
Data Mining with PowerPivot 2010
Jeremiah Peschka
Fundamentals of SQL Server Internals*
12:15 PM Kevin Kline
Keynote
    
01:00 PMCraig Utley
Analysis Services 2008 End-to-End
 Arie Jones
Monitoring Data Changes with Change Data Capture
Jack Cannon
From Access To SQL Server*
Jeremiah Peschka
Taking Control of Your Career*
Glenn Berry
DMV Emergency Room!
02:15 PMJessica Moss
Make Reporting Services Work For You*
 Kendra Little
Take the Awesomeness Home: the Data Collector
Kevin Boles
Common TSQL Mistakes*
John Welch
Creating Custom Components for SSIS
Brian Kelley
Fortress SQL Server
03:30 PMBarry Ralston
Introduction to MDX for SQL Programmers
 Thomas LaRock
What Are You Waiting For?*
Robert Cain
Data Dude - Making DB developers more productive*
Drew Minkin
Data Mining in Action: A case study
Andy Warren
Introduction to SQL Server Statistics
4:45 PM Experts Panel
Stump the "Experts"
    


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 Gentle Introduction to NoSQLJeremiah PeschkaBeginner
Add It Up: Analysis Services AggregationsCraig UtleyAdvanced
Advanced TSQL SolutionsKevin BolesAdvanced
Analysis Services 2008 End-to-EndCraig UtleyBeginner
Analytics with SSAS and PerformancePoint ServicesBarry RalstonIntermediate
Are You Following Your Own Best Practices?Jason StrateBeginner
Attribute Discretization in Analysis ServicesWilliam PearsonIntermediate
Automate SQL Server Administration with PowerShellAllen WhiteIntermediate
Automate Your DBA World With PowershellArie JonesIntermediate
Avoid Slow SSAS Queries: MDX Query TroubleshootingCraig UtleyAdvanced
Build Your First SSIS PackageAndy LeonardBeginner
Building a Professional Development PlanAndy WarrenBeginner
Collecting and Analyzing File & Wait StatisticsKevin BolesAdvanced
Common TSQL MistakesKevin BolesIntermediate
Conducting Effective MeetingsJoe WebbIntermediate
Confessions of a Data Integrator: Supporting Bad DStuart AinsworthIntermediate
Creating Custom Components for SSISJohn WelchIntermediate
Data Dude - Making DB developers more productiveRobert CainIntermediate
Data Mining in Action: A case studyDrew MinkinAdvanced
Data Mining with PowerPivot 2010Mark TabladilloIntermediate
Database Design for DevelopersAndy LeonardBeginner
Database Design FundamentalsLouis DavidsonIntermediate
DBA SurvivorThomas LaRockBeginner
Delivering BI DataCraig UtleyBeginner
Delivering BI Solutions Rapidly using VulcanJohn WelchIntermediate
Design and Implement Like Edison!William PearsonBeginner
Developing Custom Components for SSIS John WelchAdvanced
DMV Emergency Room!Glenn BerryIntermediate
Do It Right: Best Practices for Analysis ServicesCraig UtleyIntermediate
Do SQL Server Certifications Really Matter?Jason StrateBeginner
Documenting Your Integrated Microsoft BI SolutionWilliam PearsonBeginner
Efficient Data Warehouse DesignDr. Suresh RajappaAdvanced
EPM using R2 and SharePoint 2010Daniel EvansIntermediate
Eventual Consistency Using SQL ServerJeremiah PeschkaBeginner
Exploring SQL Server UtilityHope FoleyBeginner
Extended Events, Work Smarter Not Harder Jason StrateIntermediate
Extract, Transform, and Load your Data WarehouseJessica MossBeginner
Fortress SQL ServerBrian KelleyIntermediate
From Access To SQL ServerJack CannonBeginner
Fundamentals of SQL Server InternalsJeremiah PeschkaBeginner
Gather SQL Server Performance Data with PowerShellAllen WhiteAdvanced
Getting Started in IT ConsultingJoe WebbIntermediate
Getting To Know Your IndexesJason StrateIntermediate
Handling FILESTREAM in SQL Server 2008 R2Arie JonesIntermediate
Helping Your User Group Grow and Be HealthyBrian KelleyBeginner
Information Visualization - Designing great ChartsWayne SnyderAdvanced
Insights into SQL Server 2008R2 StreamInsightRobert CainIntermediate
Intro to Data Warehousing With SQL Server 2008 R2Arie JonesBeginner
Introduction to MDX for SQL ProgrammersBarry RalstonBeginner
Introduction to SQL Server Query TuningBrian KelleyBeginner
Introduction to SQL Server StatisticsAndy WarrenBeginner
KeynoteKevin KlineBeginner
Make Reporting Services Work For YouJessica MossIntermediate
Managing Database Schemas With VS201 DB projectsRafael SalasBeginner
Maximizing your Marketability in the IT WorkplaceRobert CainIntermediate
Migrate Data with PowerShell and SQL ServerAllen WhiteIntermediate
Monitoring Data Changes with Change Data CaptureArie JonesIntermediate
Off and Running with PowerPivot for Excel 2010Robert CainIntermediate
Patterns for SSIS Configuration and DeploymentJohn WelchIntermediate
Patterns for SSIS Configuration and DeploymentJohn WelchIntermediate
PHP and SQL Server - Open Source meets Enterprise Robert CainIntermediate
Planning your ETL architecture with SSISRafael SalasIntermediate
PowerPivot: Delivering Self-Serve BICraig UtleyBeginner
PowerShell 2.0 Beyond the BasicsAaron NelsonIntermediate
PowerShell for Data ProfessionalsAaron NelsonIntermediate
Processing Flat Files with SSISJohn WelchIntermediate
Processing Flat Files with SSISJohn WelchIntermediate
Realizing ROI for Business Intelligence ProjectsDouglas McDowellIntermediate
Reports for the Open Source World - SSRS for PHPRobert CainIntermediate
Schemas and Security, Oh My!Brian KelleyIntermediate
Selecting Database Hardware for OLTP PerformanceGlenn BerryIntermediate
Spiffy New Features in SQL Server 2008 R2 SSRSRobert CainIntermediate
SQL Server 2008 R2 Utility and Data-tier AppsAlan BrewerIntermediate
SQL Server AuditThomas LaRockBeginner
SQL Server Encryption DecryptedBrian KelleyIntermediate
SQL Server Full Text Searching for DBAs and DevsRobert CainIntermediate
SQL Server Locking & Blocking Made SimpleJoe WebbIntermediate
SQL Server Memory Deep DiveKevin BolesAdvanced
SQL Server Partitioning from A to ZKevin BolesIntermediate
SQL Server Replication Demystified Arie JonesIntermediate
SQL Server Reporting Services 2008 R2 Unleashed!Arie JonesIntermediate
SQL Server Service BrokerDan CrawfordIntermediate
SSIS Design Patterns Andy LeonardAdvanced
Stay Agile, Stay SaneKendra LittleBeginner
Stump the "Experts"Experts PanelBeginner
Take Control with Resource Governor and PBMArie JonesIntermediate
Take the Awesomeness Home: the Data CollectorKendra LittleBeginner
Taking Control of Your CareerJeremiah PeschkaBeginner
Teach an Old Dog New Tricks: Hook Up MSX and CMSKendra LittleBeginner
The Art & Science of Great Technical PresentationsJoe WebbBeginner
The Decoder Ring for DW/BI with SQL ServerRobert CainIntermediate
The Dirty Business of AuditingBrian KelleyBeginner
The Dirty Dozen: PowerShell Scripts for Busy DBAsAaron NelsonBeginner
The PowerShell Cookbook for the DBAJoe WebbIntermediate
The Social DBA: Resources for Career BuildingStuart AinsworthBeginner
Trigger Happy Database SecurityBrian KelleyBeginner
Using PowerShell With SQL ServerAlan BrewerBeginner
Using XML to Query Execution Plans Jason StrateIntermediate
What Are You Waiting For?Thomas LaRockIntermediate
What’s New in Reporting Services 2008 and 2008 R2?William PearsonBeginner
Who Needs a Data Warehouse?Jessica MossBeginner
Why Data Warehousing Projects FailCraig UtleyBeginner
Working with Spatial Data in SQL Server 2008 Hope FoleyBeginner
XQuery BasicsAllen WhiteBeginner
You Got XML In My Database? What's Up With That? Stuart AinsworthBeginner


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
SQL InjectionIntermediate