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 TimeBIDBADBA2MiscPerformancePowershellSponsor DemoSSISTSQL
09:00 AMAdam Jorgensen
Zero to Dashboard in 60 minutes
Kathi Kellenberger
Optimize Resources with MAP
Ken Simmons
Automating Routine Maintenance
Patrick Thompson
Parts of Facebook: Cassandra and MapReduce
Thomas LaRock
What Are You Waiting For?
Maximo Trinidad
Working with SQL Server - SQLPS
Dean Richards
Response Time Analysis of SQL Server Performance
Eric Wisdahl
SSIS - Data Flow Buffer Breakdown
Louis Davidson
Database Design Fundamentals
10:15 AMMike Davis
R2 Reporting Services, The New Stuff
Tim Beamer
Designing a highly available SQL Environment
Argenis Fernandez
Multi-Server Management with SQL Server 2008+
Timothy McAliley
ITIL V3 for the Database Administrator
Dmitri Korotkevitch
Locking and Blocking for Developers
Aaron Nelson
The Dirty Dozen: PowerShell Scripts for Busy DBAs
 Jose Chinchilla
Learning SSIS under 1 hour
Michael Stark
Spatial Queries in SQL 2008
11:30 AMDevin Knight
Introduction to Analysis Services
Brandie Tarvin
SQL Backups & Recovery
Mike Walsh
As a DBA, Where Do I Start?!
Jared Nielsen
SQL and SEO - Making Money with SQL Server
Nathan Heaivilin
Introduction to Execution Plans
Maximo Trinidad
Using PowerShell with SQL Server Agent
 Rafael Salas
Planning your ETL architecture with SSIS
Michael Antonovich
XML 101 for the SQL Developer
01:15 PM Ken Simmons
Configuration Domination: Taking Control of SQL (M
Patrick Thompson
Cassandra, Mongo and Mapreduce (MINI)
 Plamen Ratchev
How to Make a Killer Presentation (MINI)
Ron Dameron
Why a DBA Should Learn PowerShell (MINI)
 Patrick LeBlanc
Speaking, Should I? (MINI)
Brandie Tarvin
Troubleshooting Tips (MINI)
01:30 PMWes Dumey
Data Warehousing with SQL Server 2008
Pam Shaw
Tips & Tricks for Dynamic SSRS Reports
Troy Gallant
Log Shipping vs. Replication; the Great Debate
Jack Corbett
Profiling: It's Okay in SQL Server
Jeff Garbus
Choosing Indexes For Performance
Ronald Dameron
Automate Login Administration & Compliance Reports
 Eric Wisdahl
SSIS Configurations, Expressions and Constraints
Jonathon Moorman
Everything you wanted to know about IDENTITY colum
02:45 PMMichael Mollenhour
Securing your Data Warehouse
Said Salomon
Data Encryption and Key Management in SQL
Jorge Segarra
Policy-Based Management in a Nutshell
Andy Warren
Introduction to SQL Server Statistics
Kevin Boles
SQL Server Memory Deep Dive
Aaron Nelson
PowerShell 2.0 Beyond the Dirty Dozen
 John Welch
Moving Data with SQL Azure and SSIS
Plamen Ratchev
Zen and the Art of Writing SQL Query - Part 1
04:00 PMMichael Antonovich
BI Pivot Tables & Charts, Not a 1 Tool Exercise
Rodney Landrum
DBA Script Thumb 2010
Kendal Van Dyke
Transactional Replication: Beyond The Basics
Scott Klein
Developing Applications with SQL Azure
Kevin Boles
SQL Server Partitioning from A to Z
Chad Miller
ETL with PowerShell
 Patrick LeBlanc
CDC + SSIS = SCD
Plamen Ratchev
Zen and the Art of Writing SQL Query - Part 2


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 Broad look at securing your organizationTim BeamerIntermediate
A Developer Guide to Execution PlansSteve SimonIntermediate
A Test AbstractAndy WarrenBeginner
Advanced TSQL SolutionsKevin BolesAdvanced
An Introductory Look at Execution PlansEric WisdahlIntermediate
As a DBA, Where Do I Start?!Mike WalshBeginner
Automate Login Administration & Compliance ReportsRonald DameronIntermediate
Automating Routine MaintenanceKen SimmonsBeginner
BI Pivot Tables & Charts, Not a 1 Tool ExerciseMichael AntonovichIntermediate
Building a Comprehensive Professional Development Andy WarrenBeginner
Cassandra, Mongo and Mapreduce (MINI)Patrick ThompsonBeginner
CDC + SSIS = SCD Patrick LeBlancIntermediate
Change Data Capture a tool for BI,DR,Audit & more Jose ChinchillaBeginner
Choosing Indexes For PerformanceJeff GarbusAdvanced
Collecting and Analyzing File & Wait Statistics Kevin BolesAdvanced
Common SQL Programming MistakesPlamen RatchevIntermediate
Configuration Domination: Taking Control of SQL (MKen SimmonsBeginner
Data Access Layers: A CornucopiaSteve SimonIntermediate
Data Access Layers: A Cornucopia Pt 2Steve SimonBeginner
Data Access Layers: A Cornucopia Pt 3Steve SimonIntermediate
Data Encryption and Key Management in SQL Said SalomonIntermediate
Data Mining.. Making $mart financial decisions Steve SimonIntermediate
Data Warehousing with SQL Server 2008Wes DumeyBeginner
Database Design FundamentalsLouis DavidsonIntermediate
Database Design PatternsLouis DavidsonIntermediate
DBA Script Thumb 2010Rodney LandrumIntermediate
Designing a highly available SQL EnvironmentTim BeamerIntermediate
Developing Applications with SQL AzureScott KleinIntermediate
Don't Be Trigger Happy: Safe Use of TriggersJack CorbettBeginner
Enforcing Compliance With Policy-Based ManagementKen SimmonsIntermediate
ETL with PowerShellChad MillerIntermediate
Everything you wanted to know about IDENTITY columJonathon MoormanBeginner
Getting familiar with Query OptimizerDmitri KorotkevitchBeginner
Getting familiar with SQL Server Storage EngineDmitri KorotkevitchBeginner
Handling data anomalies with Data Profiling Tasks.Steve SimonIntermediate
How to Make a Killer Presentation (MINI)Plamen RatchevBeginner
Indexing for Join OptimizationJeff GarbusAdvanced
Introduction to Analysis ServicesDevin KnightBeginner
Introduction to Data WarehousingDevin KnightBeginner
Introduction to Execution PlansNathan HeaivilinBeginner
Introduction to SQL Server StatisticsAndy WarrenBeginner
Introduction to the Sql Server ProfilerJonathon MoormanBeginner
Introduction to Transactional ReplicationTroy GallantBeginner
ITIL V3 for the Database Administrator Timothy McAlileyIntermediate
Learning SSIS under 1 hourJose ChinchillaBeginner
Locking and Blocking for DevelopersDmitri KorotkevitchBeginner
Log Shipping vs. Replication; the Great DebateTroy GallantBeginner
Making SQL Server and WPF work for you!!Steve SimonIntermediate
Managing Database Schemas With VS201 DB projectsRafael SalasBeginner
Moving Data with SQL Azure and SSISJohn WelchBeginner
Multi-Server Management with SQL Server 2008+Argenis FernandezBeginner
Optimize Resources with MAP Kathi KellenbergerIntermediate
Parts of Facebook: Cassandra and MapReducePatrick ThompsonAdvanced
Planning your ETL architecture with SSISRafael SalasIntermediate
Policy-Based Management in a NutshellJorge SegarraBeginner
PowerShell 2.0 Beyond the Dirty DozenAaron NelsonIntermediate
Profiling: It's Okay in SQL ServerJack CorbettBeginner
R2 Reporting Services, The New StuffMike DavisBeginner
Recursive Queries: Beautiful Events Always Recur Steve SimonIntermediate
Refactoring SQL for PerformancePlamen RatchevIntermediate
Response Time Analysis of SQL Server PerformanceDean RichardsIntermediate
Revive your codeDmitri KorotkevitchIntermediate
Securing your Data WarehouseMichael MollenhourIntermediate
Social and Not so Social Networking for the DBA Andy WarrenBeginner
Spatial Queries in SQL 2008Michael StarkIntermediate
Speaking, Should I? (MINI)Patrick LeBlancBeginner
SQL and SEO - Making Money with SQL ServerJared NielsenIntermediate
SQL Azure PerformanceHerve RoggeroBeginner
SQL Backups & RecoveryBrandie TarvinIntermediate
SQL Security - The BasicsBrandie TarvinBeginner
SQL Server Memory Deep DiveKevin BolesAdvanced
SQL Server Partitioning from A to ZKevin BolesAdvanced
SQL University 101: Starting the SQL JourneyJorge SegarraBeginner
SQL University 201: Managing a SQL Server pt 2Jorge SegarraBeginner
SSIS - Data Flow Buffer BreakdownEric WisdahlAdvanced
SSIS 2008 - Profiling Your DataEric WisdahlIntermediate
SSIS Configurations, Expressions and ConstraintsEric WisdahlIntermediate
The Art of IndexingKen SimmonsIntermediate
The Dirty Dozen: 12 ways to write poor queriesSteve SimonIntermediate
The Dirty Dozen: PowerShell Scripts for Busy DBAsAaron NelsonBeginner
The Nitty Gritty of Database BackupsBrandie TarvinBeginner
Tips & Tricks for Dynamic SSRS Reports Pam ShawBeginner
Transactional Replication: Beyond The BasicsKendal Van DykeBeginner
Troubleshooting Tips (MINI)Brandie TarvinBeginner
Using Parameters in SQL Server Reporting ServiceMike DavisBeginner
Using PowerShell with SQL Server AgentMaximo TrinidadIntermediate
Using Sql to Generate Sql (pt1)Jonathon MoormanIntermediate
Using Sql to Generate Sql (pt2)Jonathon MoormanIntermediate
What Are You Waiting For?Thomas LaRockIntermediate
What's New with Reporting Services?Kathi KellenbergerIntermediate
Why a DBA Should Learn PowerShell (MINI)Ron DameronBeginner
Working with SQL Server - SQLPSMaximo TrinidadIntermediate
XML 101 for the SQL Developer Michael AntonovichBeginner
XML 201 for the SQL DeveloperMichael AntonovichIntermediate
You Can Improve Your Own SQL CodeMike WalshBeginner
Zen and the Art of Writing SQL Query - Part 1Plamen RatchevIntermediate
Zen and the Art of Writing SQL Query - Part 2Plamen RatchevIntermediate
Zero to Dashboard in 60 minutesAdam JorgensenBeginner


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 Data Capture a tool for BI,DR,Audit & more Beginner
Data Profiling Tasks:Their practical benefitsIntermediate