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: Some speakers alternately upload their sessions to their own blog sites, which you can locate their site when you click on their session below.

Start Time	BI - Room: Franklin Lab	BI/Dev - Room: EBC	DBA I - Room: MRP II	DBA II - Room: MRP I	Dev - Room: Wynnewood	Dev/Misc - Room: TBD	Performance - Room: 30th Street	Prof Dev/Misc - Room: Berwyn	Sponsor Session - Room: TBD
08:30 AM	Kevin Bucher Business Analytics Level: Beginner	Donald Scott Enterprise Information Management Using SQL Server 2012 Level: Intermediate	Matt Velic Automating in the Cloud Level: Intermediate	Christopher Bell “Indexing” Encrypted Data Level: Intermediate	Bill Wolff Using SQL Server for the Model in MVC Level: Advanced	Mark Scott Building Datamarts with SQL Server 2012 Level: Advanced	Janis Griffin Extend Your Knowledge with Extended Events! Level: Beginner	Andy Warren Building Your Professional Development Plan Level: Beginner
9:45 AM	Mark Hudson Making Predictions with Microsoft Data Mining Tools Level: Intermediate	Akesh Gupta Self Service BI using Office 2013 and SQL 2012 Level: Intermediate	Michael Corey Virtualizing SQL 2012: Doing IT Right Level: Intermediate	Joseph D'Antoni Using Compression to Improve Database Performance Level: Intermediate	Wayne Sheffield Windowing Functions in SQL Server 2012 Level: Intermediate	Darryll Petrancuri Loading a Partitioned Fact Table using SSIS 2012. Level: Advanced	Benjamin Nevarez Dive into the Query Optimizer-Undocumented Insight Level: Advanced	Brian Moran Awesome coaching questions every geek, analyst, leader, and consultant must know. Level: Intermediate
11:00 AM	Dominic Falso Introduction to Spatial Data in SQL Server Level: Intermediate	Mike Hillwig Recovery and Backup for Beginners Level: Beginner	Steve Jones Searching Binary Data in SQL Server 2012 Level: Intermediate	Jim Murphy AlwaysOn - Finally, A usable 'mirror'! Level: Beginner	Kevin Goff T-SQL for Application Developers - Attendees chose Level: Intermediate	Darryll Petrancuri Loading a Partitioned Fact Table using SSIS 2012 (Continuation) Level: Advanced	Hope Foley My SQL Server is Not Slow for Pete's Sake! - Server Side Performance Analysis Level: Beginner	Melissa Demsak Data Career Paths and Decision Making Strategies Level: Non-Technical	Eric Schwartz Accelerating Microsoft SQL Databases & Critical Applications with Fusion-io Level: Beginner
12:00 PM	Dave Bermingham and Eric Schwartz High Performance SANLess Clustering Level: Beginner	WIT Panel Recruiting, Retaining & Advancing Women in Technology: Why does it matter? Level: Non-Technical
01:30 PM	Jessica Moss Exploring your Data with Power View Level: Beginner	Ravi Gudlavalleti Building a Reusable ETL Framework using SSIS 2012 Level: Intermediate	Robert Pearl HealthySQL Level: Beginner	Mike Hillwig What the VLF? Level: Advanced	Samuel Vanga Automate SSIS Development for Loading a Data Warehouse Level: Intermediate	Benjamin Nevarez Top Query Optimizer Topics for Better Performance Level: Intermediate	Eddie Wuerch Partitioning for Perf & Management of Large Tables Level: Intermediate	Mark Kromer Big Data & Microsoft SQL Server in the Real World Level: Intermediate
02:45 PM	A.J. Mee Analysis Services - Multidimensional vs. PowerPivot vs. Tabular/BISM Level: Intermediate	Paul Rizza Upgrading to SSIS 2012 Level: Beginner	Charles Rivel Move Your On Premise Database to a Windows Azure SQL Database and Setup Data Sync Level: Intermediate	Jason Brimhall SQL 2012 Extended Events Level: Advanced	Kevin Boles Common TSQL Mistakes Level: Intermediate	Wayne Sheffield Table Vars & Temp Tables - What you NEED to Know! Level: Intermediate	Sebastian Meine 15 aspects of SQL Server indexes that you might not know Level: Intermediate	Muthu Ramanathan All about NoSQL databases !! Level: Intermediate
04:00 PM	Craig Collier M2M Relationships in SSAS Tabular and PowerPivot Level: Intermediate	Steven Wake ABCs of CDC with SSIS 2012 Level: Intermediate	Timothy McAliley A Walk Around the SQL Server 2012 Audit Feature Level: Intermediate	David Bermingham SQL Server 2012 AlwaysOn Step-by-Step Level: Intermediate	Joshua Lynn Learn RegEx In TSQL & Kick as{2}\|a[s][s]+ Level: Beginner	Kevin Boles Transaction Log Deep Dive Level: Advanced	Mark Wojciechowicz Easy Database Refactoring with SQL Server Database Level: Beginner	Brian Davis Goodbye Next Next Next, Hello Automated Installs Level: Intermediate

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
“Indexing” Encrypted Data	Christopher Bell	Intermediate
15 aspects of SQL Server indexes that you might not know	Sebastian Meine	Intermediate
5 Key Points for Effective T-SQL Unit Testing	Sebastian Meine	Intermediate
A Walk Around the SQL Server 2012 Audit Feature	Timothy McAliley	Intermediate
ABCs of CDC with SSIS 2012	Steven Wake	Intermediate
Accelerating Microsoft SQL Databases & Critical Applications with Fusion-io	Eric Schwartz	Beginner
All about NoSQL databases !!	Muthu Ramanathan	Intermediate
AlwaysOn - Finally, A usable 'mirror'!	Jim Murphy	Beginner
An Introduction to SQL Server Virtualisation	Gethyn Ellis	Beginner
Analysis Services - Multidimensional vs. PowerPivot vs. Tabular/BISM	A.J. Mee	Intermediate
Ask the experts	Donald Scott	Intermediate
Automate SSIS Development for Loading a Data Warehouse	Samuel Vanga	Intermediate
Automating in the Cloud	Matt Velic	Intermediate
Awesome coaching questions every geek, analyst, leader, and consultant must know.	Brian Moran	Intermediate
Beyond the cube - Introduction to Tabular SSAS	Josh Fennessy	Beginner
Beyond the cube - Introduction to Tabular SSAS	Josh Fennessy	Beginner
Big Data & Microsoft SQL Server in the Real World	Mark Kromer	Intermediate
Branding Yourself for a Dream Job	Steve Jones	Beginner
Build your own Virtual Lab	Matt Velic	Intermediate
Building a Reusable ETL Framework using SSIS 2012	Ravi Gudlavalleti	Intermediate
Building Datamarts with SQL Server 2012	Mark Scott	Advanced
Building Your Own Monitors with the SQL Agent	Mike Hillwig	Intermediate
Building Your Professional Development Plan	Andy Warren	Beginner
Bulk Insert - Friend or Foe	Joshua Lynn	Beginner
Business Analytics	Kevin Bucher	Beginner
Business and Money Tips for Independent Consultants: 20 years in 75 minutes	Brian Moran	Intermediate
Change Data Capture in SQL Server 2008/2012	Kevin Goff	Intermediate
Common TSQL Mistakes	Kevin Boles	Intermediate
Communicate for Great Good!	Matt Velic	Non-Technical
Data Career Paths and Decision Making Strategies	Melissa Demsak	Non-Technical
Data Quality Services Approach to Cleansing	Charles Gaddy	Intermediate
Defy the Defaults!	Mike Hillwig	Beginner
Dive into the Query Optimizer-Undocumented Insight	Benjamin Nevarez	Advanced
Don't Panic, DBAs! Databases on VMware made easy.	Janis Griffin	Intermediate
Easy Database Refactoring with SQL Server Database	Mark Wojciechowicz	Beginner
Enterprise Information Management Using SQL Server 2012	Donald Scott	Intermediate
Enterprise-Ready ETL Solutions Using SSIS 2012	Donald Scott	Intermediate
Exploring your Data with Power View	Jessica Moss	Beginner
Extend Your Knowledge with Extended Events!	Janis Griffin	Beginner
Getting Reports on Your Schedule	Jessica Moss	Beginner
Global Address Data: Storage and Verification	Charles Gaddy	Intermediate
Goodbye Next Next Next, Hello Automated Installs	Brian Davis	Intermediate
HealthySQL	Robert Pearl	Beginner
High Performance SANLess Clustering	Dave Bermingham and Eric Schwartz	Beginner
Integrating MDX code with OLAP applications	Kevin Goff	Intermediate
Integrating Reporting Services with SharePoint	Kevin Goff	Intermediate
Introduction to Spatial Data in SQL Server	Dominic Falso	Intermediate
Join Us! Getting Started as a Technical Speaker	Eddie Wuerch	Beginner
Learn RegEx In TSQL & Kick as{2}\|a[s][s]+	Joshua Lynn	Beginner
Loading a Partitioned Fact Table using SSIS 2012 (Continuation)	Darryll Petrancuri	Advanced
Loading a Partitioned Fact Table using SSIS 2012.	Darryll Petrancuri	Advanced
Looney Tuner? No, there IS a method to my madness	Janis Griffin	Intermediate
M2M Relationships in SSAS Tabular and PowerPivot	Craig Collier	Intermediate
Making Predictions with Microsoft Data Mining Tools	Mark Hudson	Intermediate
Matching and Survivorship	Charles Gaddy	Intermediate
Minimally Invasive - Tools to Doctor Up Your Code	Wayne Sheffield	Intermediate
Move Your On Premise Database to a Windows Azure SQL Database and Setup Data Sync	Charles Rivel	Intermediate
Much Ado About Indexes - Tips, Tricks and TSQL	Robert Pearl	Beginner
My SQL Server is Not Slow for Pete's Sake! - Server Side Performance Analysis	Hope Foley	Beginner
Page Latches for Mere Mortals	Eddie Wuerch	Advanced
Partitioning for Perf & Management of Large Tables	Eddie Wuerch	Intermediate
Put Your Data on the Map	Mark Hudson	Beginner
Recovery and Backup for Beginners	Mike Hillwig	Beginner
Recruiting, Retaining & Advancing Women in Technology: Why does it matter?	WIT Panel	Non-Technical
Searching Binary Data in SQL Server 2012	Steve Jones	Intermediate
Self Service BI using Office 2013 and SQL 2012	Akesh Gupta	Intermediate
SharePoint COOP Using 2008R2 Log Shipping	Donald Scott	Intermediate
SharePoint COOP Using SQL Server 2012 Always-On	Donald Scott	Intermediate
Shortcuts to Building SSIS in .Net	Paul Rizza	Beginner
Spatial Data: Cooler Than You'd Think!	Hope Foley	Beginner
SQL 2012 Extended Events	Jason Brimhall	Advanced
SQL 2012 Table Compression	Jason Brimhall	Advanced
SQL Injection	Kevin Boles	Intermediate
SQL Server 2012 AlwaysOn Demystified	David Bermingham	Beginner
SQL Server 2012 AlwaysOn Step-by-Step	David Bermingham	Intermediate
SQL Server 2012 Columnstore index	Kevin Goff	Intermediate
SQL Server 2012 TSQL Enhancements and Additions	Kevin Boles	Intermediate
SQL Server Backup and Recovery Fundamentals	Ayman El-Ghazali	Beginner
SQL Server Columnstore Index – How it works	Sebastian Meine	Advanced
SQL Server Reporting Services, attendees choose	Kevin Goff	Intermediate
SQL Server Security for Developers	Andy Warren	Beginner
SRS Report Builder for Business Intelligence	David Eichner	Beginner
SSAS Tabular 2012 vs SSAS Multidimensional OLAP	Kevin Goff	Intermediate
SSIS 2012: More Than Just a Pretty UI	Steven Wake	Beginner
SSIS Templates Can Make Your Life Easier	Brian Davis	Beginner
Stress testing SQL Server	Hilary Cotter	Advanced
Table Vars & Temp Tables - What you NEED to Know!	Wayne Sheffield	Intermediate
Test	Wesley Chang	Beginner
The Data Whisperer: Detecting & Extracting Meaning From Changing Data	Joshua Lynn	Intermediate
The Encryption Primer	Steve Jones	Beginner
The new tabular model in Analysis Services 2012	Kevin Goff	Intermediate
Top Query Optimizer Topics for Better Performance	Benjamin Nevarez	Intermediate
Transaction Log Deep Dive	Kevin Boles	Advanced
T-SQL for Application Developers - Attendees chose	Kevin Goff	Intermediate
Understanding Parameter Sniffing	Benjamin Nevarez	Intermediate
Upgrading to SSIS 2012	Paul Rizza	Beginner
Using Compression to Improve Database Performance	Joseph D'Antoni	Intermediate
Using SQL Server for the Model in MVC	Bill Wolff	Advanced
Virtualizing SQL 2012: Doing IT Right	Michael Corey	Intermediate
Visualize Twitter Data, with Tools You Already Know!	Samuel Vanga	Beginner
What Can DQS Do for You?	Mark Hudson	Beginner
What the VLF?	Mike Hillwig	Advanced
What’s new in SQL Server Integration Services 2012	Kevin Goff	Intermediate
Why OLAP? Building SSAS cubes and benefits of OLAP	Kevin Goff	Intermediate
Windowing Functions in SQL Server 2012	Wayne Sheffield	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.