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 Time	BI - Room: Room 3	BI - Room: Room 2	DBA - Room: Room 5	DBA / DEV - Room: Room 4	DBA / DEV - Room: Room 1
8:30 AM	Marc Beacom Introduction to Data Warehousing* Level: Beginner	Bill Fellows Kama Sutra of SSIS: A guide to loving ETL* Level: Beginner	Tim Ford The Periodic Table of Dynamic Management Objects* Level: Intermediate	Ted Malone To the Cloud and Back Again! Level: Intermediate	Jason Horner PowerShell for the Reluctant DBA / Developer Level: Beginner
9:30 AM	Thomas LeBlanc Dimenional Modeling 101* Level: Intermediate	Josh Fennessy GASP Real-time user defined sets in SSAS* Level: Advanced	Grant Fritchey 7 Ways to Fix Bad Parameter Sniffing* Level: Intermediate	Chris Randall SQL Azure: Future-Proofing Your SQL Career* Level: Intermediate	Keith Tate Development Mise en Place Level: Beginner
11:00 AM	Doug Lane Devs are from Mars, Report Servers are from Venus* Level: Beginner	Carlos Bossy Using Columnstore Indexes in SQL Server 2012* Level: Beginner	Jim Murphy AlwaysOn - Finally, A usable 'mirror'! Level: Beginner	Ben DeBow Your own Private Cloud for SQL* Level: Intermediate	Vicky Harp Edge Case Testing for the Database Professional* Level: Beginner
1:30 PM	David Eichner SQL Report Builder for Business Intelligence* Level: Beginner	Troy Ketsdever Predictive Analytics - You Can, Too!* Level: Intermediate	Jason Strate Discovering the Plan Cache* Level: Intermediate	Tom Norman PBM and you! Level: Beginner	Meredith Ryan-Smith Backup Basics - Know your options* Level: Beginner
2:30 PM	Michael Sexton ETL as MDM* Level: Intermediate	John Halunen & Aubra Moore Reporting DBs behind Virtual IP's* Level: Intermediate	Joe Sack Performance Issue Archetypes* Level: Intermediate	Thomas LaRock Choose Your Own Adventure: Performance Tuning Level: Advanced	John Morehouse 10 Things That Every DBA Should Know!* Level: Beginner
4:00 PM	William E Pearson III PowerPivot for Excel Level: Beginner	Michael Fal Eating the Elephant: SQL Server Table Partitioning* Level: Intermediate	Karen Lopez Database Design Contentious Issues Level: Intermediate	Randy Knight But it worked great in Dev! Perfomance for Devs* Level: Beginner	Mark Halstead PowerShell and VBScript for the DBA* 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.

Title	Speaker	Level
"SOA What??": Service Broker Basics	Jason Horner	Beginner
GASP Real-time user defined sets in SSAS	Josh Fennessy	Advanced
10 Things That Every DBA Should Know!	John Morehouse	Beginner
5+ Database Design Blunders and How To Avoid Them	Karen Lopez	Beginner
7 Ways to Fix Bad Parameter Sniffing	Grant Fritchey	Intermediate
Administering the BI Stack	Josh Fennessy	Intermediate
AlwaysOn - Finally, A usable 'mirror'!	Jim Murphy	Beginner
An Overview of PowerPivot	William E Pearson III	Beginner
Attribute Discretization in Analysis Services (BI)	William E Pearson III	Beginner
Backup Basics - Know your options	Meredith Ryan-Smith	Beginner
Become Bilingual! Oracle for the SQL Server DBA	Randy Knight	Intermediate
Becoming DAX: An Introduction ...	William E Pearson III	Intermediate
Beyond Plateaux: Optimize SSAS with Best Practices	William E Pearson III	Intermediate
But it worked great in Dev! Perfomance for Devs	Randy Knight	Beginner
Choose Your Own Adventure: Performance Tuning	Thomas LaRock	Advanced
Consolidated SQL Server Architectures	Ben DeBow	Intermediate
Data File Sizes – How much is enough, if you don’t	Tjay Belt	Beginner
Data-Driven Report Subscriptions with SSIS	Doug Lane	Intermediate
Database Design Contentious Issues	Karen Lopez	Intermediate
Design and Implement BI Like Edison!	William E Pearson III	Beginner
Develop a Star Schema for High Performance Reports	Carlos Bossy	Beginner
Development Mise en Place	Keith Tate	Beginner
Devs are from Mars, Report Servers are from Venus	Doug Lane	Beginner
Dimenional Modeling 101	Thomas LeBlanc	Intermediate
Discovering the Plan Cache	Jason Strate	Intermediate
Documenting Your Integrated Microsoft BI Solution	William E Pearson III	Intermediate
Drive Your Way to the DMV	Jason Strate	Intermediate
Eating the Elephant: SQL Server Table Partitioning	Michael Fal	Intermediate
Edge Case Testing for the Database Professional	Vicky Harp	Beginner
Entity Strategies: Structuring Your Consultancy	William E Pearson III	Beginner
Error Handling in ETL	Michael Sexton	Beginner
ETL as MDM	Michael Sexton	Intermediate
Execution Plan Basics - Beginners	Thomas LeBlanc	Beginner
Execution Plan Intermiediate	Thomas LeBlanc	Advanced
Execution Plans and tuning queries	Mark Halstead	Intermediate
Extended Events, Work Smarter Not Harder	Jason Strate	Intermediate
Find Performance Problems by Reading the Waits	Eddie Wuerch	Intermediate
Form And Substance: The “T” of ETL	Michael Sexton	Intermediate
Getting Started with MDX	William E Pearson III	Beginner
Getting to Know Index Operation Stats	Jason Strate	Intermediate
Getting To Know Your Indexes	Jason Strate	Intermediate
Hardware 301: Diving Deeper into Database Hardware	Glenn Berry	Intermediate
Introduction to Analysis Services	Marc Beacom	Beginner
Introduction to Common Table Expressions	Vicky Harp	Intermediate
Introduction to Data Warehousing	Marc Beacom	Beginner
Introduction to Integration Services	Marc Beacom	Beginner
Isn't that Spatial	Jason Horner	Beginner
Kama Sutra of SSIS: A guide to loving ETL	Bill Fellows	Beginner
Little in the middle but got much [Write]Back	Josh Fennessy	Intermediate
Many-to-Many: Multiple Calendars in a Single Cube	William E Pearson III	Advanced
Monitoring Databases in a Virtual Environment	Thomas LaRock	Intermediate
Only You Can Prevent Database Fires!	John Morehouse	Beginner
Page Latches for Mere Mortals	Eddie Wuerch	Intermediate
Parallel Processing Database Architecture	Jeff Renz	Beginner
PBM and you!	Tom Norman	Beginner
Performance Enhancing Laziness	Tim Ford	Beginner
Performance Issue Archetypes	Joe Sack	Intermediate
Performance Tuning Triage	Joe Sack	Intermediate
PowerPivot for Excel	William E Pearson III	Beginner
PowerShell and VBScript for the DBA	Mark Halstead	Beginner
PowerShell for the Reluctant DBA / Developer	Jason Horner	Beginner
Predictive Analytics - You Can, Too!	Troy Ketsdever	Intermediate
Production is all Virtualized, Is Yours?	Tom Norman	Beginner
Real-time Data Warehouse and Reporting	Carlos Bossy	Intermediate
Reporting DBs behind Virtual IP's	John Halunen & Aubra Moore	Intermediate
Scaling SQL Server	Glenn Berry	Intermediate
Searching for the Holy Grail of DDL Auditing	Colleen Morrow	Beginner
Serene Velocity: Reporting Services and SSAS Data	William E Pearson III	Intermediate
something about Powershell and SQL Server	Tjay Belt	Beginner
SQL Azure: Future-Proofing Your SQL Career	Chris Randall	Intermediate
SQL Report Builder for Business Intelligence	David Eichner	Beginner
Stand-alone DBA daily/weekly/monthly tasks	Tjay Belt	Beginner
TDE, oh what fun! Auditing, No!!	Tom Norman	Intermediate
TempDB Performance Troubleshooting and Optimizing	Eddie Wuerch	Intermediate
The Creepy DBA, How to Stalk Your Users	Jason Strate	Intermediate
The Fabulous Query Plan Primer	Michael Fal	Intermediate
The Honey Badger Approach to Policy Based Mgmt	Mitchell Bottel	Beginner
The One Week Data Mart	Jeff Renz	Beginner
The Periodic Table of Dynamic Management Objects	Tim Ford	Intermediate
The Point of Attack – SQL Intrusion and Prevention	Gabriel Villa	Beginner
To SSIS or Not SSIS, That is the Question	Jeff Renz	Beginner
To the Cloud and Back Again!	Ted Malone	Intermediate
Understanding SQL Server XML Features	Randy Knight	Intermediate
Understanding Transaction Isolation Levels	Randy Knight	Intermediate
Using Columnstore Indexes in SQL Server 2012	Carlos Bossy	Beginner
Want a promotion? It’s up to you!	Mitchell Bottel	Beginner
What Are You Waiting For?	Jason Strate	Intermediate
XQuery Basics for the DBA	Jason Strate	Intermediate
Your own Private Cloud for SQL	Ben DeBow	Intermediate

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 Title	Skill Level
PowerShell for Dummies	Beginner