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 TimeBI - Room: Room 7DBA - Room: Room 1DBA2 - Room: Room 3Misc - Room: Room 5Performance - Room: Room 2Powershell - Room: Room 8SSIS - Room: Room 6TSQL - Room: Room 4Sponsor Demo - Room: Room 9
09:00 AMAdam Jorgensen

Zero to Dashboard in 60 minutes

Level: Beginner
Kathi Kellenberger

Optimize Resources with MAP *

Level: Intermediate
Ken Simmons

Automating Routine Maintenance*

Level: Beginner
Patrick Thompson

Parts of Facebook: Cassandra and MapReduce*

Level: Advanced
Thomas LaRock

What Are You Waiting For?

Level: Intermediate
Maximo Trinidad

Working with SQL Server - SQLPS

Level: Intermediate
Eric Wisdahl

SSIS - Data Flow Buffer Breakdown*

Level: Advanced
Louis Davidson

Database Design Fundamentals

Level: Intermediate
 
10:15 AMMike Davis

R2 Reporting Services, The New Stuff

Level: Beginner
Tim Beamer

Designing a highly available SQL Environment

Level: Intermediate
Argenis Fernandez

Multi-Server Management with SQL Server 2008+*

Level: Beginner
Timothy McAliley

ITIL V3 for the Database Administrator *

Level: Intermediate
Dmitri Korotkevitch

Locking and Blocking for Developers*

Level: Beginner
Aaron Nelson

The Dirty Dozen: PowerShell Scripts for Busy DBAs*

Level: Beginner
Jose Chinchilla

Learning SSIS under 1 hour

Level: Beginner
Michael Stark

Spatial Queries in SQL 2008*

Level: Intermediate
Shawn McGehee

Red Gate Software - Ingeniously simple tools

Level: Beginner
11:30 AMDevin Knight

Introduction to Analysis Services*

Level: Beginner
Brandie Tarvin

SQL Backups & Recovery*

Level: Intermediate
Mike Walsh

As a DBA, Where Do I Start?!

Level: Beginner
Jared Nielsen

SQL and SEO - Making Money with SQL Server

Level: Intermediate
Nathan Heaivilin

Introduction to Execution Plans

Level: Beginner
Aaron Nelson

PowerShell 2.0 Beyond the Dirty Dozen

Level: Intermediate
Rafael Salas

Planning your ETL architecture with SSIS

Level: Intermediate
Michael Antonovich

XML 101 for the SQL Developer *

Level: Beginner
Andrew Szalaji

expressor data integration software product demons

Level: Beginner
01:15 PMBrian McDonald

Reporting Services Delivery Mechanisms (mini)*

Level: Beginner
Ken Simmons

Configuration Domination: Taking Control of SQL (M*

Level: Beginner
Patrick Thompson

Cassandra, Mongo and Mapreduce (MINI)*

Level: Beginner
Sherri McDonald

Documenting BI (mini)

Level: Beginner
Plamen Ratchev

How to Make a Killer Presentation (MINI)*

Level: Beginner
Ron Dameron

Why a DBA Should Learn PowerShell (MINI)*

Level: Beginner
Patrick LeBlanc

Speaking, Should I? (MINI)

Level: Beginner
Brandie Tarvin

Troubleshooting Tips (MINI)*

Level: Beginner
 
01:30 PMWes Dumey

Data Warehousing with SQL Server 2008

Level: Beginner
Pam Shaw

Tips & Tricks for Dynamic SSRS Reports

Level: Beginner
Troy Gallant

Log Shipping vs. Replication; the Great Debate

Level: Beginner
Jack Corbett

Profiling: It's Okay in SQL Server*

Level: Beginner
Jeff Garbus

Choosing Indexes For Performance*

Level: Advanced
Ronald Dameron

Automate Login Administration & Compliance Reports*

Level: Intermediate
Eric Wisdahl

SSIS Configurations, Expressions and Constraints*

Level: Intermediate
Jonathon Moorman

Everything you wanted to know about IDENTITY colum*

Level: Beginner
David Waugh

Response Time Analysis of SQL Server Performance

Level: Intermediate
02:45 PMMichael Mollenhour

Securing your Data Warehouse

Level: Intermediate
Said Salomon

Data Encryption and Key Management in SQL *

Level: Intermediate
Jorge Segarra

Policy-Based Management in a Nutshell

Level: Beginner
Andy Warren

Introduction to SQL Server Statistics*

Level: Beginner
Kevin Boles

SQL Server Memory Deep Dive*

Level: Advanced
Ed Wilson

Windows PowerShell Best Practices for SQL DBA’s*

Level: Beginner
John Welch

Moving Data with SQL Azure and SSIS

Level: Beginner
Plamen Ratchev

Zen and the Art of Writing SQL Query - Part 1*

Level: Intermediate
Scott Schledwitz

Information Builders

Level: Beginner
04:00 PMMichael Antonovich

BI Pivot Tables & Charts, Not a 1 Tool Exercise*

Level: Intermediate
Rodney Landrum

DBA Script Thumb 2010

Level: Intermediate
Kendal Van Dyke

Transactional Replication: Beyond The Basics

Level: Beginner
Scott Klein

Developing Applications with SQL Azure

Level: Intermediate
Kevin Boles

SQL Server Partitioning from A to Z*

Level: Advanced
Chad Miller

ETL with PowerShell*

Level: Intermediate
Patrick LeBlanc

CDC + SSIS = SCD

Level: Intermediate
Plamen Ratchev

Zen and the Art of Writing SQL Query - Part 2*

Level: Intermediate
Kathi Kellenberger

Women in Technology (WIT)*

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 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
Documenting BI (mini)Sherri McDonaldBeginner
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
expressor data integration software product demonsAndrew SzalajiBeginner
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
Information BuildersScott SchledwitzBeginner
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
Red Gate Software - Ingeniously simple toolsShawn McGeheeBeginner
Refactoring SQL for PerformancePlamen RatchevIntermediate
Reporting Services Delivery Mechanisms (mini)Brian McDonaldBeginner
Response Time Analysis of SQL Server PerformanceDavid WaughIntermediate
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
Transprent Data Encryption Inside and OutBradley BallIntermediate
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
Windows PowerShell Best Practices for SQL DBA’sEd WilsonBeginner
Women in Technology (WIT)Kathi KellenbergerBeginner
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