Application & Database DevelopmentBI Information DeliveryBI Platform Architecture, Development & AdministrationCloud Application Development & DeploymentEnterprise Database Administration & DeploymentProfessional Development

Schedule is subject to change.


Monday, Oct 14, 2013 Pre-Conference Schedule

Room 207 A-B 207 C-D 208 A-B 213 C-D 217 A 217 B-C-D 218 A-B
08:30 AM - 10:00 AM Scaling SQL Server 2012

Glenn Berry

DBA-396-P
Enterprise High Availability with AlwaysOn Availability Groups

Curt Mathews, Shon Hauck

DBA-398-P
Practical T-SQL – Efficient Solutions

Itzik Ben-Gan

AD-399-P
Practical Disaster Recovery Techniques

Paul Randal

DBA-499-P
Growing Up with SSAS: From PowerPivot to MOLAP Cubes

Brian Knight, Devin Knight

BIA-299-P
Understanding the Optimizer and Interpreting Execution Plans

Paul White

AD-599-P
From Reporting Services Rookie to Rockstar

Stacia Misner

BID-299-P
10:00 AM - 10:15 AM Break
Room 207 A-B 207 C-D 208 A-B 213 C-D 217 A 217 B-C-D 218 A-B
10:15 AM - 12:00 PM Scaling SQL Server 2012

Glenn Berry

DBA-396-P
Enterprise High Availability with AlwaysOn Availability Groups

Curt Mathews, Shon Hauck

DBA-398-P
Practical T-SQL – Efficient Solutions

Itzik Ben-Gan

AD-399-P
Practical Disaster Recovery Techniques

Paul Randal

DBA-499-P
Growing Up with SSAS: From PowerPivot to MOLAP Cubes

Brian Knight, Devin Knight

BIA-299-P
Understanding the Optimizer and Interpreting Execution Plans

Paul White

AD-599-P
From Reporting Services Rookie to Rockstar

Stacia Misner

BID-299-P
12:00 PM - 01:00 PM Lunch
Room 207 A-B 207 C-D 208 A-B 213 C-D 217 A 217 B-C-D 218 A-B
01:00 PM - 02:30 PM Scaling SQL Server 2012

Glenn Berry

DBA-396-P
Enterprise High Availability with AlwaysOn Availability Groups

Curt Mathews, Shon Hauck

DBA-398-P
Practical T-SQL – Efficient Solutions

Itzik Ben-Gan

AD-399-P
Practical Disaster Recovery Techniques

Paul Randal

DBA-499-P
Growing Up with SSAS: From PowerPivot to MOLAP Cubes

Brian Knight, Devin Knight

BIA-299-P
Understanding the Optimizer and Interpreting Execution Plans

Paul White

AD-599-P
From Reporting Services Rookie to Rockstar

Stacia Misner

BID-299-P
02:30 PM - 02:45 PM Break
Room 207 A-B 207 C-D 208 A-B 213 C-D 217 A 217 B-C-D 218 A-B
02:45 PM - 04:30 PM Scaling SQL Server 2012

Glenn Berry

DBA-396-P
Enterprise High Availability with AlwaysOn Availability Groups

Curt Mathews, Shon Hauck

DBA-398-P
Practical T-SQL – Efficient Solutions

Itzik Ben-Gan

AD-399-P
Practical Disaster Recovery Techniques

Paul Randal

DBA-499-P
Growing Up with SSAS: From PowerPivot to MOLAP Cubes

Brian Knight, Devin Knight

BIA-299-P
Understanding the Optimizer and Interpreting Execution Plans

Paul White

AD-599-P
From Reporting Services Rookie to Rockstar

Stacia Misner

BID-299-P

Tuesday, Oct 15, 2013 Pre-Conference Schedule

Room 207 A-B 207 C-D 208 A-B 213 C-D 217 A 217 B-C-D 218 A-B
08:30 AM - 10:00 AM SQLCAT: Windows Azure Data Platform Technical Immersion Day

Michael Thomassy, Silvano Coriani...

CLD-499-P
Thriving as a DBA in the World of Cloud and On-Premise Data

Grant Fritchey

DBA-299-P
Big Data for the Business Intelligence Professional

Jen Stirrup, Allan Mitchell

BIA-499-P
Storage and Virtualization for DBAs

Denny Cherry

DBA-397-P
Plan and Deploy Successful Clustered Solutions for SQL Server

Allan Hirt

DBA-399-P
Make SQL Server Apps Go Faster

Brent Ozar, Kendra Little...

AD-299-P
How to Design a Relational Database

Louis Davidson

AD-398-P
10:00 AM - 10:15 AM Break
Room 207 A-B 207 C-D 208 A-B 213 C-D 217 A 217 B-C-D 218 A-B
10:15 AM - 12:00 PM SQLCAT: Windows Azure Data Platform Technical Immersion Day

Michael Thomassy, Silvano Coriani...

CLD-499-P
Thriving as a DBA in the World of Cloud and On-Premise Data

Grant Fritchey

DBA-299-P
Big Data for the Business Intelligence Professional

Jen Stirrup, Allan Mitchell

BIA-499-P
Storage and Virtualization for DBAs

Denny Cherry

DBA-397-P
Plan and Deploy Successful Clustered Solutions for SQL Server

Allan Hirt

DBA-399-P
Make SQL Server Apps Go Faster

Brent Ozar, Kendra Little...

AD-299-P
How to Design a Relational Database

Louis Davidson

AD-398-P
12:00 PM - 01:00 PM Lunch
Room 207 A-B 207 C-D 208 A-B 213 C-D 217 A 217 B-C-D 218 A-B
01:00 PM - 02:30 PM SQLCAT: Windows Azure Data Platform Technical Immersion Day

Michael Thomassy, Silvano Coriani...

CLD-499-P
Thriving as a DBA in the World of Cloud and On-Premise Data

Grant Fritchey

DBA-299-P
Big Data for the Business Intelligence Professional

Jen Stirrup, Allan Mitchell

BIA-499-P
Storage and Virtualization for DBAs

Denny Cherry

DBA-397-P
Plan and Deploy Successful Clustered Solutions for SQL Server

Allan Hirt

DBA-399-P
Make SQL Server Apps Go Faster

Brent Ozar, Kendra Little...

AD-299-P
How to Design a Relational Database

Louis Davidson

AD-398-P
02:30 PM - 02:45 PM Break
Room 207 A-B 207 C-D 208 A-B 213 C-D 217 A 217 B-C-D 218 A-B
02:45 PM - 04:30 PM SQLCAT: Windows Azure Data Platform Technical Immersion Day

Michael Thomassy, Silvano Coriani...

CLD-499-P
Thriving as a DBA in the World of Cloud and On-Premise Data

Grant Fritchey

DBA-299-P
Big Data for the Business Intelligence Professional

Jen Stirrup, Allan Mitchell

BIA-499-P
Storage and Virtualization for DBAs

Denny Cherry

DBA-397-P
Plan and Deploy Successful Clustered Solutions for SQL Server

Allan Hirt

DBA-399-P
Make SQL Server Apps Go Faster

Brent Ozar, Kendra Little...

AD-299-P
How to Design a Relational Database

Louis Davidson

AD-398-P

Wednesday, Oct 16, 2013 Conference Schedule

Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
10:15 AM - 11:30 AM Visualizing John Snow's Cholera Map Using Microsoft BI

Jason Thomas

BID-214
Putting Quality Back in Your Data Analysis

Michael Antonovich

BIA-208
Convince Me – Persuasion Techniques That Get Things Done

Kevin Kline

PD-201
Moving Your Database to the Cloud – What You Need to Know

Nabeel Derhem

CLD-304
BI Best Practices: The Good, the Bad, and the Ugly

Erin Welker

BIA-201
Query Performance Tuning: A 12-Step Method

Thomas LaRock, Tim Chapman

DBA-316
Making the Leap from Profiler to Extended Events

Erin Stellato

DBA-209-S
Windows Azure Deep Dive

Mark Russinovich

CLD-310-S




























NOTE: Spotlight sessions end at 11:45 AM
Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
10:45 AM - 12:00 PM































Exposing a Chatty Cathy: What a Drag!

Mindy Curnutt

AD-203
Visual Analytics with Power View in Excel 2013 & SharePoint 2013

Riccardo Muti, Amy Forstrom

BID-213-M
AlwaysOn in SQL Server 2014

Luis Vargas

DBA-301-M
Deploying Microsoft BI in SharePoint 2013, Part 1: PowerPivot

Kay Unkroth

BIA-305-M
Microsoft Power Query for Excel: Discover and Refine Your Data

Faisal Mohamood

BID-308-M
Building Your T-SQL Tool Kit: Window Function Fundamentals

Christina Leo

AD-201
Optimizing SQL Server Performance in a Virtual Environment

Denny Cherry

DBA-312
11:30 AM - 01:30 PM Lunch: PASS Chapters
Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
01:30 PM - 02:45 PM Congratulations, You're Now a DBA...

Ben DeBow

DBA-101
Understanding Transaction Isolation Levels

Randy Knight

AD-207
SQL Server XML 101

Stuart Ainsworth

AD-103
PowerPivot Data Modeling Techniques

Susan O'Connell

BID-209
Enriching Big Data for Analysis

Lara Rubbelke, Adam Jorgensen

BIA-404-M
Creating an End-to-End Power View Reporting Solution

Devin Knight

BID-101
Indexes: Everything You Need to Know

Gail Shaw

AD-400-HD

Part 1 of 2
Professor DMV: How to Use DMVs to Diagnose Performance Issues

Glenn Berry

DBA-315
Windows Azure SQL Database for the DBA

Scott Klein

CLD-308-M
Predictive Analytics: Letting the Data Decide

Carlos Bossy

BID-210
Busting Myths: Windows Azure Security and Compliance

Lori Woehler

CLD-312-M
Extended Events in SQL Server 2012

Ajay Jagannathan

DBA-326-M
Understanding Data Files at the Byte Level

Mark S. Rasmussen

DBA-501
Data Cleansing in SSIS

Tim Mitchell

BIA-203
Inside SQL Server 2012 Memory: The Sequel

Bob Ward

DBA-500-HD

Part 1 of 2
02:45 PM - 03:00 PM Refreshment Break
Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
03:00 PM - 04:15 PM Hirable and Desirable: How to Make Companies Want You

Nicholas Cain

PD-101
Using PowerShell to Quickly Deploy New SQL Server Instances

Michael Wells

DBA-318
Lightning Talks 101

Craig Purnell, Daniel Evans...

LT-101
Accelerate Database Performance Through Data Compression

Joseph D'Antoni

DBA-201
Ninja Data Moves in Office 2013

Brian Knight

BID-216-S
Reduce, Reuse, Recycle: Automating Your BI Framework

Stacia Misner

BIA-315-S
Indexes: Everything You Need to Know

Gail Shaw

AD-400-HD

Part 2 of 2
SQL Server Integration Services Roadmap

Matt Masson, Wee Hyong Tok

BIA-309-M
Spatial Data: Cooler Than You'd Think!

Hope Foley

AD-102
T-SQL: Bad Habits and Best Practices

Aaron Bertrand

AD-209-S
Private and Hybrid Cloud: Better Together

Darmadi Komo

CLD-305-M
SQL Server 2012 Data Mining: Taking App Design to the Next Level

Peter Myers

BID-311-M
Deploying Microsoft BI in SharePoint 2013, Part 2: SSRS & Power View

Riccardo Muti, Chuck Heinzelman

BIA-316-M
SQL Server 2014 and Sharks with Freakin’ Lasers

Dandy Weyn, Ari Schorr

DBA-210-S
Inside SQL Server 2012 Memory: The Sequel

Bob Ward

DBA-500-HD

Part 2 of 2
NOTE: Spotlight and 1/2-Day sessions end at 4:30 PM
Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
04:45 PM - 06:00 PM Under the Covers of Hadoop on Windows

Rohit Bakhshi , Brian Swan

BIA-405
Periodic Table of DMVs: Part 2012 - The SQL

Tim Ford

DBA-313
Installing and Configuring SQL Server 2012 Reporting Services

Robert Cain

BIA-205
So You Want to Be a Rockstar Report Developer?

Melissa Coates

BID-310
Keeping an Eye on Your Data with Change Data Capture

Arie Jones

AD-205
How Active Directory Affects SQL Server

Ryan Adams

DBA-308
What’s New in Database Development with SQL Server Data Tools and Visual Studio?

Adam Mahood

CLD-313-M
Automate Your ETL Infrastructure with SSIS and PowerShell

Allen White

BIA-210-S
Fraud Detection: Notes from the Field

Dejan Sarka

BID-305
Enriching Your BI Semantic Tabular Models with DAX

Kasper de Jonge

BID-304-M
How to Model and Implement a Hierarchy in SQL Server

Louis Davidson

AD-318-S
Troubleshooting Clusters

Allan Hirt

DBA-324-S
Windows Azure Virtual Machines and SQL Server Unplugged

Luis Vargas, Sanjay Mishra...

DBA-319-M
Introduction to Power BI for Office 365

Dandy Weyn, Michael Tejedor

BID-201-M
Query Performance Tuning for Azure SQL Database

Grant Fritchey

CLD-309-S
NOTE: Spotlight sessions end at 6:15 PM

Thursday, Oct 17, 2013 Conference Schedule

Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
10:15 AM - 11:30 AM DANGER! The Art and Science of Presenting

Mark Vaillancourt

PD-104
Unit and Integration Testing for SSIS Packages

John Welch

BIA-313
Table Partitioning: Secret Weapon for Big Data Problems

John Sterrett

DBA-205
Best Practices for Optimizing SQL Server with Solid State Disk

Patrick O'Keeffe, Richard Douglas

DBA-327
Choosing the Right Analysis Services: MOLAP vs. Tabular

Devin Knight, Dustin Ryan

BIA-202
PowerPivot + Power View = Self-Service BI Revolution

Jose Chinchilla

BID-105
What Is a BI DBA?

Jorge Segarra

BIA-212-S
Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad

Kimberly Tripp

DBA-321-S




























NOTE: Spotlight sessions end at 11:45 AM
10:45 AM - 12:00 PM































NoSQL: An Introduction

Nabeel Derhem

AD-309
Running with Elephants: Predictive Analytics with HDInsight

Christopher Price

CLD-401
Compliance in Azure: The Big Data Conversation

Lara Rubbelke, Rafael Fernandez

AD-306-M
Lap Around Windows Azure SQL Database Premium Service

Gregory Leake

CLD-311-M
Columnstore Indexes Today & v.Next: Flipping the DW /faster Bit

Jimmy May

AD-305-M
Discover, Document, and Diagnose Your Servers on Your Coffee Break

Kendal Van Dyke

DBA-102
Power BI – This Is How We Do It

Matthew Roche, Faisal Mohamood...

BID-313-M
11:30 AM - 01:30 PM Lunch
11:45 AM - 01:15 PM Women in Technology Luncheon
Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
01:30 PM - 02:45 PM SQL Server Reference Architectures on Cisco Unified Compute System

Frank Cicalese

DBA-211
Unit Testing Made Easy for Database Development

Sanil Mhatre

AD-208
Anatomy of a Join

Luke Jian

DBA-302
Geospatial Analytics Using Microsoft BI

Jason Thomas

BID-103
Design Matters! The Performance Impact of Database Design

Audrey Hammonds

AD-202
From Minutes to Milliseconds: High-Performance SSRS Tuning

Doug Lane

BID-306
Slicing and Dicing: Attributes and Hierarchies in SSAS 2012

Thomas LeBlanc

BIA-300-HD

Part 1 of 2
Windows Azure SQL Database Design: Silver Lining and Dark Side

Karen Lopez

CLD-203
CAT: Architecting Near Real-Time Data Warehouses on PDW

John Hoang, Binh Cao...

AD-301-M
SQL Server 2014 and the Hybrid Cloud

Evgeny Krivosheev, Kevin Farlee

AD-311-M
Power BI and the Data Management Gateway

Matt Masson, Wee Hyong Tok

BID-309-M
Demystifying Big Data for BI Professionals: The Essentials

Jen Stirrup, Allan Mitchell

BIA-400-HD

Part 1 of 2
A Systematic Approach to ETL Performance Tuning

Erin Welker

BIA-301
SQL Server 2014 In-Memory OLTP: DBA Deep Dive

Kevin Liu

DBA-328-M
Power BI: Modern Device and Data Search Experiences

Adam Wilson, Amy Forstrom

BID-207-M
02:30 PM - 03:00 PM Refreshment Break
Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
03:00 PM - 04:15 PM DBA Task Automation: Unleash the PowerShell Hero in You!

Michael Wells, Aaron Nelson

DBA-401
Self-Service ETL and Power Query: Are We There Yet?

Rafael Salas

BID-211
Lightning Talks 102

Jose Chinchilla, Yuri Diomin...

LT-102
CAT: Business Continuity with SQL Server – Real-Life War Stories

Sanjay Mishra

AD-324-M
Doing More with Less: SQL Server Policy-Based Management

Colin Stasiuk

DBA-202
Designing an SSIS Framework

Andy Leonard

BIA-403
Slicing and Dicing: Attributes and Hierarchies in SSAS 2012

Thomas LeBlanc

BIA-300-HD

Part 2 of 2
Being the DBA of the Future: A World of On-Premise and Cloud

Grant Fritchey, Dandy Weyn

CLD-301
CAT: PDW Architecture Gets Real - Customer Implementations

Murshed Zaman, Brian Walker

AD-304-M
CAT: Performance Tuning Tabular Models in SSAS 2012

John Sirmon, Greg Galloway

BIA-402-M
SQL Server Archaeology: Dig into the Past with system_health

Jonathan Kehayias

DBA-322-S
Demystifying Big Data for BI Professionals: The Essentials

Jen Stirrup, Allan Mitchell

BIA-400-HD

Part 2 of 2
Maximizing Plan Reuse

Andrew Kelly

AD-405-S
These Aren't the Joins You're Looking for...

Rob Farley

AD-319-S
Power BI 3D Visualization and Storytelling with Power Map

Ari Schorr, Lara Rubbelke

BID-206-M
NOTE: Spotlight and 1/2-Day sessions end at 4:30 PM
Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
05:00 PM - 06:15 PM SQL Server Database Projects in SQL Server 2012 Data Tools

Robert Cain

AD-206
PerformancePoint: Not a Lost Treasure, An Analytic Gem

Josh Fennessy

BID-104
CAT: Architecture Patterns & Lessons Learned from Azure Projects

Kun Cheng

AD-302-M
CAT: SQL Server on Azure VM – Performance and Best Practices

Sanjay Mishra, Silvano Coriani

DBA-305-M
Polybase Deep Dive

Brian Mitchell

AD-310-M
Planning Your Report Design

Stacia Misner

BID-205
Dos and Don’ts of Database Corruption

Gail Shaw

DBA-320-S
10 Query Tuning Techniques Every SQL Programmer Should Know

Kevin Kline, Aaron Bertrand

AD-104-S
Automating in the Cloud

Matt Velic

CLD-201
Type More, Click Less: Programmatically Build SSIS Packages

Bill Fellows

BIA-312
From S to 3XL: Implementing Data Partitioning and Tiered Storage

Dmitri Korotkevitch

DBA-402
OLTP Sharding Techniques for Massive Scale

Conor Cunningham

DBA-403-M
Index Methods You're Not Using

Jes Borland

AD-204
Waits, Latches, and Spinlocks: Internals and Analysis

Paul Randal

DBA-503-S
BI Power Hour

Matt Masson, Matthew Roche...

BID-215-S
NOTE: Spotlight sessions end at 6:30 PM

Friday, Oct 18, 2013 Conference Schedule

Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
08:00 AM - 09:15 AM From Data to Insight: Views from Microsoft Finance

Marc Reguera

BID-203-M
Get Your MDX/DAX Tips and Tricks: Currency Conversion

Christian Wade

BIA-306
Transitioning from T-SQL to MDX

Thomas LeBlanc

BIA-311
Advanced Analytics in Excel 2013

Dejan Sarka

BID-302
How to Avoid Living at Work: Lessons from Working at Home

Thomas LaRock, Aaron Bertrand...

PD-102
Dashboard Design Best Practices

Dan Bulos

BID-102
Upgrading SQL Server – Done Right

Dandy Weyn

DBA-317-M
SQL Server Index Internals: A Deep Dive

Tim Chapman

DBA-405-M
Securing SSAS Tabular Models

Patrick LeBlanc

BIA-209-M
CAT: How Do I Troubleshoot My Database in the Cloud?

Michael Thomassy, Silvano Coriani

DBA-304-M
Mastering the CUBE Functions in Excel

Peter Myers

BID-307-M
Load Testing with SQL Server Tools

Neil Hambly

DBA-310
Why Is SQL Server Slow Right Now?

Brent Ozar

DBA-207
How to Tell When Storage Is a Problem

Kendra Little

DBA-208-S
Table Expressions: So Much More than CTEs

Rob Farley

AD-322-S
NOTE: Spotlight sessions end at 9:30 AM
09:15 AM - 09:45 AM Refreshment Break
Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
09:45 AM - 11:00 AM Geospatial Data Types in SQL Server 2012

Leonard Lobel

AD-101
Leadership: Transcending Management

Richard Bolesta

PD-302
Never Have to Say "Mayday!!!" Again

Mike Walsh

PD-202-S
SQL Server Showdown

Colin Stasiuk

CLD-101
Storage Subsystem Basics for the DBA

Glenn Berry

DBA-103
SQL Server High Availability & Disaster Recovery in Windows Azure

Luis Vargas, Sanjay Mishra

CLD-306-M
Data Internals Deep Dive

Bradley Ball

DBA-502-S
Policy-Based Management and Central Management Server

Ryan Adams

DBA-314




























NOTE: Spotlight sessions end at 11:15 AM
10:15 AM - 11:30 AM































Visualize Your Big Data with HDInsight, Power View, and Excel

Jen Stirrup

BID-312
Using Batching to Optimize SQL Database Apps on Windows Azure

Jason Roth, Silvano Coriani

AD-315-M
Power BI Self-Service Information Management and Data Stewardship

Matthew Roche, Ofer Ashkenazi

BIA-207-M
Zero to 60 with HDInsight

Cindy Gross

AD-317-M
SQL Server 2014 In-Memory OLTP: DB Developer Deep Dive

Kevin Farlee

AD-323-M
Unseen Minions: Improving Parallel Processing in SSIS

Josef Richberg

BIA-314
Death by a Thousand Cuts: A Look at Power View Performance

Adam Saxton

BIA-304-M
11:00 AM - 01:00 PM Lunch: Birds of a Feather
Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
01:00 PM - 02:15 PM Whatcha Doin'? Passive Security for Hostile Environments

Bob Pusateri

DBA-206
Building an Effective Data Warehouse Architecture

James Serra

BIA-101
From Locks to No Locks – Concurrency in SQL Server

Andreas Wolter

AD-308
SQL Server Transaction Log Internals

Tim Chapman, Denzil Ribeiro

DBA-406-M
Moving Big Data: SSIS, Pig, and Sqoop

John Welch

BIA-206
The New Hotness: SQL Server 2012 and SharePoint 2013

Bradley Schacht

BID-212
SQL Server Performance and Monitoring in Windows Azure at Scale

Daniel Sol

CLD-307-M
Data Mining in SQL Server Analysis Services

Brian Knight

BIA-211-S
Building a Better Team Through Feedback

Joe Webb

PD-201-S
Top Tricks and Best Practices for .NET SQL Server Developers

Mark S. Rasmussen

AD-314
CAT: From Question to Insight with HDInsight and BI

Cindy Gross, Dipti Sangani

AD-401-M
Introducing Cube World to Users from Flat Table Land

Michael Antonovich

BIA-307
CAT: SQL Server 2014 In-Memory OLTP – Customer Migration

Mike Weiner, Michael Steineke...

AD-320-M
Squeezing Top Performance from Your Virtualized SQL Server

David Klee

DBA-323-S
Clustered Updatable Columnstore Indexes

Brian Mitchell

AD-321-M
NOTE: Spotlight sessions end at 2:30 PM
02:15 PM - 02:45 PM Refreshment Break
Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
02:45 PM - 04:00 PM Workplace Coaching: Simple Skills that Change Everything

Brian Moran

PD-301
Monitoring Methodologies: The Hierarchy of Database Needs

Michael Fal

DBA-203
Writing Better Queries with Window Functions

Kathi Kellenberger

AD-316
Building a Supportable ETL Framework

David Darden

BIA-302
Make Your SSIS Packages Run Faster: 10 Quick Tips

Tim Mitchell

BIA-316
From Impaired to Insightful: Analysis with Geospatial Data

Julie Koesmarno

BID-204
SQL Server Disaster Recovery and High Availability Overview

Kendal Van Dyke

DBA-300-HD

Part 1 of 2
Index Fragmentation: Internals, Analysis, and Solutions

Paul Randal

DBA-309
Custom Replication with Service Broker and CDC/CT

Mladen Prajdić

AD-307
Deep Dive into the Power Query Formula Language

Faisal Mohamood, Theresa Palmer-Boroski...

BID-401-M
CAT: High Performance, High Volume Data Movement in Azure

Steve Howard

BIA-303-M
Fast Performing SSAS Hierarchies: Tips and Tricks

Jose Chinchilla

BIA-200-HD

Part 1 of 2
Into the Blue: Extending AlwaysOn Availability Groups

Joseph D'Antoni

CLD-202
Power View with Analysis Services Multidimensional Models

Kasper de Jonge, Riccardo Muti

BID-208-M
CAT: AlwaysOn Customer Panel – Lessons Learned & Best Practices

Sanjay Mishra, Ayad Shammout...

DBA-303-M
Room 202 A-B 218 A-B 212 A-B 203 A 217 B-C 207 A-B 217 A Ballroom A 209 A-B 203 B 207 C-D 213 C-D 217 D 208 A-B Ballroom B
04:15 PM - 05:30 PM T-SQL Fundamentals: Logical Processing Order

Christina Leo

AD-105
The Not-So-Secret SQL Server Agent

Jes Borland

DBA-212
"R" vs "M": Languages for Data Exploration

Oliver Engels, Julian Breunung

BID-301
Mouth Wide Shut: Interviews from the Other Side of the Table

Jennifer McCown, Sean McCown

PD-103
NY, London, Paris, Munich… Everybody's talkin’ ‘bout Mobile BI

Paul Turley

BID-217
Database Development with SSDT for Visual Studio 2012

Aaron Nelson

AD-404
SQL Server Disaster Recovery and High Availability Overview

Kendal Van Dyke

DBA-300-HD

Part 2 of 2
Parallel Query Execution

Paul White

DBA-404
CAT: Event-Driven System-Health Monitoring at Microsoft Commerce

Rafael Fernandez, Lindsey Allen

AD-303-M
Running BI Workloads on Windows Azure Virtual Machines

Chuck Heinzelman

BIA-308-M
Delivering Analytics with Excel 2013: 10 Secrets for Success

Josh Fennessy

BID-202
Fast Performing SSAS Hierarchies: Tips and Tricks

Jose Chinchilla

BIA-200-HD

Part 2 of 2
SSIS Package Failed in Production? Here’s How to Troubleshoot

Reza Rad

BIA-310
Online Operations in SQL Server 2014

Ajay Jagannathan, Ajay Jagannathan

DBA-325-M
Defeating the Limitations of the Query Optimizer

Benjamin Nevarez

AD-501
NOTE: 1/2-Day sessions end at 5:45 PM