PASS Program Schedule

LEGEND

AD

DBA

BIA

BID

CLOUD

PD

Lightning Talks

Sunday, November 4, 2012 5:00 PM - 8:00 PM Registration, South Lobby 5:00 PM - 8:00 PM PASS Booth, 4C

Monday, November 5, 2012 7:00 AM - 8:30 AM Pre-Conference Attendee Registration, South Lobby 7:30 AM - 5:00 PM General Conference Attendee Registration, South Lobby 7:30 AM - 8:30 AM Continental Breakfast, Dining Hall 4F - Registered Pre-Conference attendees only ROOM 602-604 606-607 608-609 611-612

8:30 AM - 10:00 AM

613-614

615-617

618-620

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

SSIS Design Patterns

Demystifying Database Administration Best Practices

SQL Server 2012 in a Highly Available World

BI Dashboards with Dashboard Designer & PerformancePoint Services 2010

Relational Database Design Workshop

Practical SQL Server Performance Troubleshooting

Building a SQL Server 2012 BI Platform

Andy Leonard, Jessica Moss, Matt Masson, Michelle Ufford, Tim Mitchell

Argenis Fernandez, Robert Davis

Denny Cherry

Rod Colledge

Louis Davidson

Klaus Aschenbrenner

Brian Knight

BIA-299-P

DBA-397-P

DBA-399-P

BID-398-P

AD-397-P

DBA-398-P

BIA-298-P

10:00 AM - 10:15 AM Refreshment Break, 6th Floor, East Lobby - Registered Pre-Conference attendees only

10:15 AM - 12:00 PM

12:00 PM - 1:00 PM

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

SSIS Design Patterns

Demystifying Database Administration Best Practices

SQL Server 2012 in a Highly Available World

BI Dashboards with Dashboard Designer & PerformancePoint Services 2010

Relational Database Design Workshop

Practical SQL Server Performance Troubleshooting

Building a SQL Server 2012 BI Platform

Andy Leonard, Jessica Moss, Matt Masson, Michelle Ufford, Tim Mitchell

Argenis Fernandez, Robert Davis

Denny Cherry

Rod Colledge

Louis Davidson

Klaus Aschenbrenner

Brian Knight

BIA-299-P

DBA-397-P

DBA-399-P

BID-398-P

AD-397-P

DBA-398-P

BIA-298-P

Pre-conference Lunch, Dining Hall 4E - Registered Pre-Conference attendees only Pre-Conference

1:00 PM - 2:30 PM

2:30 PM - 2:45 PM

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Relational Database Design Workshop

Practical SQL Server Performance Troubleshooting

Building a SQL Server 2012 BI Platform

SSIS Design Patterns

Demystifying Database Administration Best Practices

SQL Server 2012 in a Highly Available World

BI Dashboards with Dashboard Designer & PerformancePoint Services 2010

Andy Leonard, Jessica Moss, Matt Masson, Michelle Ufford, Tim Mitchell

Argenis Fernandez, Robert Davis

Denny Cherry

Rod Colledge

Louis Davidson

Klaus Aschenbrenner

Brian Knight

BIA-299-P

DBA-397-P

DBA-399-P

BID-398-P

AD-397-P

DBA-398-P

BIA-298-P

Refreshment Break, 6th Floor, East Lobby - Registered Pre-Conference attendees only Pre-Conference

2:45 PM - 4:30 PM

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Relational Database Design Workshop

Practical SQL Server Performance Troubleshooting

Building a SQL Server 2012 BI Platform

SSIS Design Patterns

Demystifying Database Administration Best Practices

SQL Server 2012 in a Highly Available World

BI Dashboards with Dashboard Designer & PerformancePoint Services 2010

Andy Leonard, Jessica Moss, Matt Masson, Michelle Ufford,Tim Mitchell

Argenis Fernandez, Robert Davis

Denny Cherry

Rod Colledge

Louis Davidson

Klaus Aschenbrenner

Brian Knight

BIA-299-P

DBA-397-P

DBA-399-P

BID-398-P

AD-397-P

DBA-398-P

BIA-298-P

* Note: Sessions subject to change.

PASS Summit 2012 | Seattle, WA.

1

PASS Program Schedule

LEGEND

AD

DBA

BIA

BID

CLOUD

Tuesday, November 6, 2012 7:00 AM - 7:00 PM Registration, South Lobby 7:30 AM - 8:30 AM Continental Breakfast, Dining Hall 4F - Registered Pre-Conference attendees only ROOM 602-604 606-607 608-609 611-612

8:30 AM - 10:00 AM

PD

Lightning Talks

613-614

615-617

618-620

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

T-SQL Querying and Query Tuning Enhancements in SQL Server 2005-2012

Customer Stories from the Front Lines

Query Performance Tuning: Start to Finish

Building the Agile Data Warehouse with SQL Server 2012

Real-World System Design for the DBA: Private Cloud and SQL as a Service

Zero to BI Semantic Model with SQL Server 2012

Automate and Manage SQL Server with PowerShell

Itzik Ben-Gan

Bob Ward, Adam Saxton

Grant Fritchey

Davide Mauri

Allan Hirt, Ben DeBow

Peter Myers

Allen White

AD-398-P

DBA-499-P

AD-399-P

BIA-399-P

DBA-299-P

BID-399-P

DBA-298-P

10:00 AM - 10:15 AM Refreshment Break, 6th Floor, East Lobby - Registered Pre-Conference attendees only

10:15 AM - 12:00 PM

12:00 PM - 1:00 PM

1:00 PM - 2:30 PM

1:00 PM - 1:45 PM 2:00 PM - 2:45 PM 2:30 PM - 2:45 PM

2:45 PM - 4:30 PM

3:00 PM - 3:45 PM 4:00 PM - 4:45 PM 5:30 PM - 6:30 PM 6:30 PM - 8:00 PM 7:30 PM - 8:15 PM 8:00 PM - 11:00 PM

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

T-SQL Querying and Query Tuning Enhancements in SQL Server 2005-2012

Customer Stories from the Front Lines

Query Performance Tuning: Start to Finish

Building the Agile Data Warehouse with SQL Server 2012

Real-World System Design for the DBA: Private Cloud and SQL as a Service

Zero to BI Semantic Model with SQL Server 2012

Automate and Manage SQL Server with PowerShell

Itzik Ben-Gan

Bob Ward, Adam Saxton

Grant Fritchey

Davide Mauri

Allan Hirt, Ben DeBow

Peter Myers

Allen White

AD-398-P

DBA-499-P

AD-399-P

BIA-399-P

DBA-299-P

BID-399-P

DBA-298-P

Pre-Conference Lunch, Dining Hall 4E - Registered Pre-Conference attendees only Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

T-SQL Querying and Query Tuning Enhancements in SQL Server 2005-2012

Customer Stories from the Front Lines

Query Performance Tuning: Start to Finish

Building the Agile Data Warehouse with SQL Server 2012

Real-World System Design for the DBA: Private Cloud and SQL as a Service

Zero to BI Semantic Model with SQL Server 2012

Automate and Manage SQL Server with PowerShell

Itzik Ben-Gan

Bob Ward, Adam Saxton

Grant Fritchey

Davide Mauri

Allan Hirt, Ben DeBow

Peter Myers

Allen White

AD-398-P

DBA-499-P

AD-399-P

BIA-399-P

DBA-299-P

BID-399-P

DBA-298-P

First-Timers Networking Session 1, Room 4C 3-4 First-Timers Networking Session 2, Room 4C 3-4 Refreshment Break, 6th Floor, East Lobby - Registered Pre-Conference attendees only Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

Pre-Conference

T-SQL Querying and Query Tuning Enhancements in SQL Server 2005-2012

Customer Stories from the Front Lines

Query Performance Tuning: Start to Finish

Building the Agile Data Warehouse with SQL Server 2012

Real-World System Design for the DBA: Private Cloud and SQL as a Service

Zero to BI Semantic Model with SQL Server 2012

Automate and Manage SQL Server with PowerShell

Itzik Ben-Gan

Bob Ward, Adam Saxton

Grant Fritchey

Davide Mauri

Allan Hirt, Ben DeBow

Peter Myers

Allen White

AD-398-P

DBA-499-P

AD-399-P

BIA-399-P

DBA-299-P

BID-399-P

DBA-298-P

First-Timers Networking Session 3, Room 4C 3-4 First-Timers Networking Session 4, Room 4C 3-4 First-Timers Orientation & Networking Session, Hall 4A PASS Summit 2012 Welcome Reception, Ballroom 6ABCE First-Timers Networking Session 5, Room 4C 3-4 Exceptional DBA Awards Party, Room 3AB (Red Gate & SQLServerCentral.com)

* Note: Sessions subject to change.

PASS Summit 2012 | Seattle, WA.

2

PASS Program Schedule

LEGEND

AD

DBA

BIA

BID

Wednesday, November 7, 2012 6:30 AM - 6:15 PM Registration, South Lobby 7:00 AM - 8:00 AM Continental Breakfast, Dining Hall 4E-F 7:00 AM - 8:00 AM SQL Server Clinic, 4C-3 8:15 AM - 10:00 AM Keynote: Bill Graziano & Ted Kummert, Ballroom 6ABCE 10:00 AM - 10:15 AM Refreshment Break, 6th Floor, East Lobby 10:00 AM - 4:00 PM Exhibit Hall 4B 10:00 AM - 5:00 PM SQL Server Chalk Talks, 4C-4 10:00 AM - 6:15 PM SQL Server Clinic, 4C-3 ROOM 301 - TCC 302 - TCC 303 - TCC

CLOUD

305 - TCC

PD

307-308

* Note: Sessions subject to change.

Lightning Talks

602-604

606-607

608

609

611

612

613-614

Spotlight (90 min)

10:15 AM - 11:30 AM (11:45 AM for Spotlight sessions )

10:30 AM - 6:00 PM 11:30 AM - 1:30 PM

The What, Why, and How of Filegroups

SQL Server 2012 AlwaysOn: Availability Groups Drilldown

Building Compelling Power View Reports

What's New in Analysis Services 2012?

Jes Borland

Luis Vargas

Sean Boon

Chris Webb

Brian Moran

DBA-204

DBA-307-M

BID-208-M

BIA-303

PD-100

Tax, Finance, and Money 10 Extraordinary Things Tips for the Independent to Achieve with Consultant Integration Services 2012

PowerPivot 101

Matthew Roche, Peter Myers

Cindy Gross, Dipti Sangani

Bradley Schacht

Kevin Cox

BIA-322-S

BIA-305-A

BID-100

AD-307-M

618-620

Spotlight (90 min)

Spotlight (90 min)

SQLCAT: Best Practices and Lessons Learned on SQL Server in an Azure VM

Extended Events: Work Smarter Not Harder

DBCC Commands: The Quick and the Dangerous

Mobile Business Intelligence

Darwin Schweitzer

Michael Rys

Steve Howard, Arvind Ranasaria

Jason Strate

Erin Stellato

Jen Underwood, Carolyn Chau, John Sirmon

BIA-204-M

AD-500-M

CLD-309-A

DBA-321-S

DBA-210-S

BID-302-M

Microsoft Hands-On Labs, Room 304 (3rd floor of TCC ) PASS Chapters Luncheon, Dining Hall 4E-F Half Day (3 hrs)

1:30 PM - 2:45 PM (4:30 PM for Half Day sessions)

2:45 PM - 3:00 PM 3:00 PM - 4:15 PM (4:30 PM for Spotlight & Half Day sessions )

4:45 PM - 6:00 PM (6:15 PM for Spotlight sessions )

6:15 PM - 9:15 PM

6E

XQuery and XML in SQL Server: Common Problems and Best Practice Solutions

SQLCAT: What Are the MAD About Data: Solve Problems and Develop a Largest SQL Server Projects in the World? “Data Driven Mindset”

SQLCAT: Big Data – All Abuzz About Hive

615-617

SQLCAT: SQLOS Memory Manager Changes in SQL Server 2012

The Biggest Loser: Database Edition

Manage SQL Server 2012 on Windows Server Core with PowerShell

SQLCAT: How Do I Troubleshoot My Database Now that It Is in the Cloud?

Gus Apostol, Jerome Halmans

Andrew Novick

Allen White

Silvano Coriani, Ewan Fairweather

DBA-403-M

AD-200

DBA-200

CLD-302-M

Half Day (3 hrs)

Secrets of SSAS Storage

PowerPivot 2 – Using NASA Data

Adapting Your ETL Solutions to Use SSIS 2012

Replication vs. AlwaysOn: Scalability Solutions with SQL Server 2012

Loping and Managing BI Semantic Models in SQL Server 2012 Analysis Services

Louis Davidson

Stacia Misner

Mark Stacey

Devin Knight

Meir Dudai

Kasper de Jonge

Juergen Thomas

AD-100

BIA-300-HD

BID-303

BIA-205

DBA-310

BIA-308-M

DBA-305-M

Spotlight (90 min)

Half Day (3 hrs)

Lightning Talks - 100

Triggers: Born Evil or Misunderstood?

Amy Lewis, Brent Ozar, Mark Broadbent, Rob Volk, Robert Davis, and Wendy Pastrick LT-100

Enterprise Information SQLCAT: Many-Core Management: Processors, SSDs, Large Memory: How to Benefit Bringing Together SQL Server SSIS, DQS, and MDS

Inside SQLOS 2012

The Evolution of Security in SQL Server 2012

Matthew Roche, Matt Masson

Bob Ward

Don Kiely

BIA-316-M

DBA-500-HD

DBA-501

Spotlight (90 min)

Half Day (3 hrs)

Stop Bad Data in Its OLTP Tracks

Inside SQLOS 2012

Real-Life SQL 2012 Availability Group Lessons Learned

Refreshment Break, 6th Floor, East Lobby and 3rd Floor Lobby of TCC

Tempdb: Performance and Manageability

Taking MERGE Beyond the Basics

Understanding Parallel Query Execution

Blazing Fast Backups

Spotlight (90 min)

SQLCAT: AlwaysOn

Tips and Tricks for Giving a Stellar Technical Presentation

Around the World with the SharePoint BI Toolbelt

Secrets of SSAS Storage

Developers Are from HA/DR Design Mars, Report Servers Are Patterns, Architectures from Venus

Inside Unstructured Learn About The Mentoring Experiment

Using SSIS 2012 for Data Data: SQL Server 2012 Warehouse ETL FileTable and Semantic

and Best Practices

Search

Robert Davis

Hugo Kornelis

Paul White

Sean McCown

Ronald Yenko

Brian Knight

Stacia Misner

Doug Lane

Sanjay Mishra, Mike Weiner

Andy Warren, Steve Jones

Thomas LeBlanc

Michael Rys

Denise McInerney

Bob Ward

Brent Ozar

DBA-206

AD-202

DBA-313

DBA-316

PD-108

BID-212-S

BIA-300-HD

BID-203

DBA-315-A

PD-104-S

BIA-319

AD-313-M

AD-209-S

DBA-500-HD

DBA-101

Spotlight (90 min)

Spotlight (90 min)

BI Architecture with SQL Server 2012 and SharePoint 2010

Data Model-Driven Database Design in the Real World

SQLCAT: Real-World Case Study of MissionCritical Active/Active Remote DCs

SQLCAT: AlwaysOn Unplugged – Everything You Want to Know About AlwaysOn

SQLCAT: How Does Microsoft Run Its SAP Landscape on Windows and SQL Server?

Rod Colledge

Neil Buchwalter, Karen Lopez

Lindsey Allen, Prem Mehra, Shep Sheppard

Sanjay Mishra

Juergen Thomas

Tobias Ternstrom, Jan Engelsberg

BIA-318

AD-206-CA

AD-402-A

DBA-314-M

DBA-306-M

AD-305-M

Practical Uses and Configuring Kerberos for Optimization of New TSharePoint 2010 BI in 7 SQL Features in SQL Steps Server 2012

Installing and Configuring SQL Server 2012 Reporting Services

Building Self-Service BI Applications using PowerPivot and Excel

Mobile Business Intelligence for Everyone, Now!

Monitoring SQL Server Analysis Services with DMVs

Chuck Heinzelman

Robert Cain

Diego Oppenheimer

Jen Stirrup

Erin Welker, Patrick Brady

BIA-304-M

BIA-317

BID-205-M

BID-102

BIA-307

Choose Your Own Maintain SQL Server Building a Tabular Model Adventure: Performance System and Performance Database Tuning Data with PowerShell

SQL Server and SharePoint: Best Frienemies

Steve Hughes

Thomas LaRock, Tim Chapman

Allen White

Lisa Gardner

BIA-208

DBA-408-S

DBA-319-S

AD-310-C

Exhibitor Reception, Exhibit Hall 4B

PASS Summit 2012 | Seattle, WA.

3

PASS Program Schedule

LEGEND

AD

DBA

BIA

BID

CLOUD

Thursday, November 8, 2012 6:45 AM - 8:10 AM Breakfast Presentation, 3AB (SIOS Technology and Fusion-io) 7:00 AM - 5:00 PM Registration, South Lobby 7:00 AM - 8:00 AM SQL Server Clinic, 4C-3 7:00 AM - 8:00 AM Continental Breakfast, Dining Hall 4E-F 8:15 AM - 8:35 AM PASSion Award Announcement, Ballroom ABCE 8:15 AM - 10:00 AM Keynote: Douglas McDowell, Thomas LaRock, and Quentin Clark, Ballroom 6ABCE 10:00 AM - 10:15 AM Refreshment Break, 6th Floor, East Lobby 10:00 AM - 4:00 PM SQL Server Chalk Talks, 4C-4 10:00 AM - 5:00 PM Exhibit Hall, Hall 4B 10:00 AM - 6:30 PM SQL Server Clinic, 4C-3 ROOM 301 - TCC 302 - TCC 303 - TCC 305 - TCC 10:15 AM - 11:30 AM (11:45 AM for Spotlight sessions )

10:30 AM - 6:00 PM 11:30 AM - 1:30 PM 11:30 AM - 1:30 PM

SQL I/O Uh-Oh

READPAST & Furious: Transactions, Locking, and Isolation

Using Power View with Multidimensional models

PD

307-308

* Note: Sessions subject to change.

Lightning Talks

602-604

606-607

Spotlight (90 min)

Spotlight (90 min)

609

SQL Server Parallel Data warehouse

Brian Knight

Alberto Ferrari

Meir Dudai

Melissa Coates

BIA-405-S

BIA-321-S

DBA-405

BID-206

Mindy Curnutt

Mark Broadbent

Sivakumar Harinath

Mladen Prajdić

DBA-311

DBA-309

BID-307-M

AD-205

DBA-302-M

611

612

613-614

615-617

618-620

6E

Spotlight (90 min)

Spotlight (90 min)

Spotlight (90 min)

Bootstrapping Data Warehousing in Azure for Use with Hadoop

Data Modeling Best Practices for Enterprise Tabular Models

Storing Columnstore Indexes

Demystifying Database Statistics

Query Tuning Mastery: The Art and Science of Manhandling Parallelism

Kay Unkroth

James Podgorski, Olivier Matrat, Rafael Fernandez, and Steve Howard

Carlos Bossy

Kalen Delaney

Erin Stellato

Adam Machanic

BID-310-M

AD-300-M

BIA-202

AD-321-S

DBA-211-S

AD-501-S

AlwaysOn: Availability Groups and Replication Working Together

The Best Microsoft BI Tools You've Never Heard Of

SQL Server 2012 Memory Management

How to Defragment Indexes for Peak Performance

What to Look for in Execution Plans

Peer-to-Peer Replication: Deploying and Real-Life Dashboards: When to Managing a PowerPivot Implementations and Choose Which MSBI Tool for SharePoint 2013 Best Practices Infrastructure

SQL Injection: From Website to SQL Server

Eric Kraemer, Bob Schmidt

Data Cleansing with SSIS Querying and Optimizing 2012 DAX

608

Microsoft Hands-On Labs, Room 304 (3rd floor of TCC ) Lunch, Dining Hall 4E-F Women in Technology Luncheon Ballroom AB (SQL Sentry Inc. ) Half Day (3 hrs)

1:30 PM - 2:45 PM (4:30 PM for Half Day sessions)

2:45 PM - 3:00 PM

SQL Server 2012 Security for Developers

Understanding Transaction Isolation Levels

Upgrading to SQL Server 2012 “Done Right”

Andreas Wolter

Randy Knight

Dandy Weyn

AD-301

AD-207

DBA-301-M

How Klout Changed the Landscape of Social Media with Hadoop and BI

Lightning Talks - 101

Aaron Nelson, Bill Fellows, Jes Borland, Denny Lee, David Mariani Niko Neugebauer, Oliver Engels, Sanjaya Padhi BIA-306-M

LT-101

4:35 PM - 5:00 PM

Visual Report Design: Bringing Sexy Back

Running Reporting Services in SharePoint Integrated Mode: How and Why

ColumnStore Indexes: Near Real-Time Analytics The Turbobooster Inside with xVelocity (without SQL Server 2012 DirectQuery)

Mark Tabladillo

Paul Turley

Chuck Heinzelman

Klaus Aschenbrenner

Marco Russo

Jean-Yves Devant

Chris Webb

Neil Hambly

Brad McGehee

Grant Fritchey

BIA-400-HD

BID-313

BID-300-M

BIA-311

BIA-312

DBA-303-M

BID-202

DBA-312

DBA-201

AD-201

Half Day (3 hrs)

Spotlight (90 min)

Spotlight (90 min)

Spotlight (90 min)

Database Design Throwdown

T-SQL Tips and Tricks

Dive into the Query Optimizer: Undocumented Insight

Itzik Ben-Gan

Benjamin Nevarez

AD-101-S

AD-401

Refreshment Break, 6th Floor, East Lobby and 3rd Floor Lobby of TCC Half Day (3 hrs)

3:00 PM - 4:15 PM (4:30 PM for Spotlight & Half Day sessions )

Enterprise Data Mining with SQL Server

Spotlight (90 min)

Data Quality Services in the Enterprise

NoSQL for the SQL Server Professional

Recovering Lost Data

Moves Like Jagger: Upgrading to SQL Server 2012

Are You Cut Out for a Consulting Career?

Enterprise Data Mining with SQL Server

Exploring PowerPivot for Excel and Power View in SQL Server 2012

SQL Azure Reporting: What Is It, and Why Should You Care?

Tim Mitchell

Lynn Langit

Robert Davis

Mark Broadbent

Rick Heiges

Mark Tabladillo

Peter Myers

Stacia Misner

AD-208

AD-311

DBA-400-HD

DBA-308

PD-200

BIA-400-HD

BID-308-S

CLD-100

SQLCAT: SQL Azure Design Patterns and Best Practices Mark Simms, Michael Thomassy CLD-300-M

Leadership – Influence vs. Authority

Enriching Your BI Semantic Tabular Models with DAX

Bad Reports: Fixing Their Mistakes

Kevin Kline

Kasper de Jonge

Roger Noble

PD-106-S

BIA-309-M

BID-210

PASS to Prizes, Exhibit Hall 4B Half Day (3 hrs)

5:00 PM - 6:15 PM (6:30 PM for Spotlight & Half Day sessions )

7:00 PM - 10:00 PM

Thomas LaRock, Karen Lopez AD-322-S

Index Psychiatry: Diagnose and Treat the Top 5 Disorders

What DBAs Should Know About Windows Server 8

Recovering Lost Data

Connecting to the World's Data

Providing Effective Feedback

BI Power Hour

Devin Knight

BID-101

Kendra Little

Victor Isakov

Robert Davis

Max Uritsky

Joe Webb

Matt Masson, Chuck Heinzelman, Matthew Roche, Patrick LeBlanc, Peter Myers, and Sean Boon

AD-204

DBA-208

DBA-400-HD

BID-213-M

PD-300

BIA-206-M

Creating a Power View Reporting Solution

SQLCAT: SQL Server 2012 AlwaysOn HA/DR Customer Panel Sanjay Mishra, Ayad Shammout, David Smith, Michael Steineke, Thomas Grohser, Wolfgang Kutschera DBA-323-A

Spotlight (90 min)

Spotlight (90 min)

Load Millions of Records in a SplitSecond with Partition Switching

Waiter, There's a Fly in My Data

Microsoft BI End-User Tools 360°

Monitoring Analysis Services: What’s Going on with Your Cube Performance?

Improve Query Performance by Fixing Bad Parameter Sniffing

Diagnose T-SQL Performance Problems Fast with sp_Blitz

A Developer's Guide to Dangerous Queries

John Lambert

Rafael Salas

Markus EhrenmuellerJensen

Tim Peterson

Grant Fritchey

Brent Ozar

Jeremiah Peschka

DBA-304-M

BIA-101

BID-104

BIA-404

AD-210-S

DBA-320-S

AD-203

Community Appreciation Party: Experience Music Project (PASS & Microsoft)

PASS Summit 2012 | Seattle, WA.

4

PASS Program Schedule

LEGEND

AD

DBA

BIA

Friday, November 9, 2012 7:00 AM - 5:30 PM Registration, South Lobby 7:00 AM - 2:00 PM SQL Server Clinic, 4C-3 7:00 AM - 8:00 AM Continental Breakfast, Dining Hall 4E-F ROOM 301 - TCC 302 - TCC 8:00 AM - 9:15 AM (9:30 AM for Spotlight & Half Day sessions )

9:30 AM - 9:45 AM 9:45 AM - 11:00 AM 9:45 AM - 11:00 AM (11:15 AM for Spotlight & Half Day sessions )

10:00 AM - 2:00 PM 10:00 AM - 4:00 PM 10:00 AM - 4:00 PM 11:15 AM - 11:30 AM 11:30 AM - 1:00 PM

BID

CLOUD

PD

* Note: Sessions subject to change.

Lightning Talks

303 - TCC

305 - TCC

307-308

602-604

606-607

608

609

611

612

613-614

615-617

618-620

6E

Troubleshooting SQL Server 2012 Performance with Extended Events

Integrating Solid State Storage with SQL Server

Harnessing Big Data with Hadoop

What's New for Columnstore Indexes and Batch Mode Processing?

Mouth Wide Shut: Coherent Interviewing

Microsoft's Big Play for Big Data

SQL Server 2012 Highly Available BI Environments: From the Field

SQLCAT: What Are the Largest Azure Projects in the World?

Tips and Tricks for Building Rich Reporting Services Reports

Power (View)ful Tabular BI Semantic Model Development

Using Amazon's Cloud for the SQL Server Professional

Dashboard Design: Making Reports Pop

How to Configure the OS for Optimal SQL Server Performance

Advanced SQL Server Troubleshooting

Working with Claims and SQL Server BI Technologies

Rohit Nayak

Wesley Brown

Mike Flasko

Len Wyatt

Sean McCown

Andrew Brust

Chris Testa-O'Neill

Kevin Cox

Bob Meyers

Mark Davis

Lynn Langit

Paul Turley

Brad McGehee

Klaus Aschenbrenner

Adam Saxton

DBA-407-C

DBA-209

AD-316-M

DBA-317-M

PD-103

BIA-200

BIA-302

CLD-303-A

BID-306-M

BIA-313

CLD-305

BID-305

DBA-202

DBA-404

BIA-401-C

Spotlight (90 min)

Spotlight (90 min)

Spotlight (90 min)

Refreshment Break, 6th Floor, East Lobby and 3rd Floor Lobby of TCC PASS Board Q&A, 401

Migrating to SQL Server 2012

Geospatial Data Types in SQL Server 2012

Troubleshooting Spatial Query Performance: Deep Dive into Spatial Indexing

Page And Row Compression Deep Dive

Lightning Talks - 102

Business Intelligence and Data Visualization in SQL Server 2012

SQLCAT: Architecture Patterns and Lessons Learned from Azure ISV Projects

Parent-Child Hierarchies in Tabular

When ETL Goes Bad: Handling Errors and Data Anomalies in SSIS

Getting Reports on Your Schedule

Real-Time Data Warehouse and Reporting Solutions

SQL Server in Azure VM patterns: Hybrid DR, data movement and BI

Managing SQL Server in a Virtual World

Performance Tuning Through the Plan Cache

Big Data Meets SQL Server

Jen Stirrup

Kun Cheng

Alberto Ferrari

Tim Mitchell

Jessica Moss

Carlos Bossy

Guy Bowerman, Ross LoForte

Kevin Kline

Jason Strate

Dr. David DeWitt

BID-204

CLD-304-M

BIA-301

BIA-209

BID-103

BIA-203

CLD-301-M

DBA-322-S

DBA-409-S

DBA-410-S

Spotlight (90 min)

Spotlight (90 min)

Glenn Berry

Leonard Lobel

Michael Rys

Bradley Ball

Christian Wade, Edwin Sarmiento, Gabriel Villa, Julie Koesmarno, Laerte Junior, Neil Hambly

DBA-203

AD-308

AD-403-M

DBA-401

LT-102

Exhibit Hall 4B SQL Server Chalk Talks, 4C-4 Microsoft Hands-On Labs, Room 304 (3rd floor of TCC ) Exhibitor Raffles, Exhibit Hall 4B Birds of a Feather Luncheon, Dining Hall 4E-F Half Day (3 hrs)

1:00 PM - 2:15 PM (2:30 PM for Spotlight and Half Day sessions)

2:30 PM - 2:45 PM

Table Variables and Temporary Tables – What You Need to Know

Optimizing SQL Server I/O with Solid State Drives

Spotlight (90 min)

Query Optimizer Deep Dive

Data in the Sky: Efficient On-Premise to Cloud Data Transfer

Wayne Sheffield

Luke Jian

Paul White

Matt Masson, Wee Hyong Tok

AD-320

DBA-205

AD-400-HD

CLD-306-M

SQLCAT: How SQL Azure Supports LargeScale Customer Deployments Silvano Coriani, Ewan Fairweather, Mark Simms, Michael Thomassy CLD-308-A

Using Advanced DQS Concepts to Solve Complex Data Quality Problems

LinkedIn for SQL Server Professionals

Taking SQL Server 2012 into the World of Spatial Data Management

Optimizing Your BI Semantic Model for Performance and Scale

Building Your Professional Development Plan

Inside DAX Query Plans

Mobile BI with SSRS and SharePoint

The Good, Bad, and Ugly of Deploying AlwaysOn Availability Groups

SQL Server First Responder Kit

How I Learned to Stop Worrying and Love My SAN

Mathew Roche, Rakesh Parida

Craig Purnell

Michael Rys

Allan Folting, Akshai Mirchandani

Andy Warren

Marco Russo

Angel Abundez

Allan Hirt, David Smith, Michael Steineke

Kendra Little

Wesley Brown

BIA-315-M

PD-107

AD-314-M

BIA-402-M

PD-105-S

BIA-403

BID-200

DBA-300

DBA-212-S

DBA-213-S

Refreshment Break, 6th Floor, East Lobby and 3rd Floor Lobby of TCC Half Day (3 hrs)

2:45 PM - 4:00 PM (5:45 PM for Half Day sessions)

4:15 PM - 5:30PM (5:45 PM for Spotlight & Half Day sessions)

5:45 PM

DMVs: Power in Your Hands

Applied Enterprise Semantic Mining

Query Optimizer Deep Dive

CSI for SQL: Learn to be a SQL Sleuth

Licensing SQL Server for 2012

Database Development with SSDT and Visual Studio 2012

SharePoint for Business Intelligence

Data Quality Services – Finally!

Analyzing SSAS Data with Excel

Extending SSIS 2012 Reports with Analytics

Stream Data Processing in the Cloud with Windows Azure StreamInsight

Slowly Changing Dimensions: An Integrated Approach

Fast Track Data Warehouse and SQL Appliances

Disaster Recovery for Federations in SQL Azure

Where Should I Be Encrypting My Data?

Davide Mauri

Mark Tabladillo

Paul White

Mindy Curnutt

Scott Shaw

Barclay Hill, Adam Mahood, Gert Drapers

Bradley Schacht

Julie Smith

Stephan Stoltze

Patrick LeBlanc

Tiho Tarnavski

Mark Stacey

Dana Kaufman, Eric Kraemer

Cihan Biyikoglu

Denny Cherry

DBA-402

AD-312

AD-400-HD

DBA-406

DBA-102

AD-321-M

BID-201

BIA-100

BID-211

BIA-207-M

CLD-307-M

BIA-314

AD-302-M

CLD-400-M

AD-303

New Kid in Town: SQL Express LocalDB

SQL Server Database Projects in SQL Server 2012 Data Tools

Managing SQL Server with System Center 2012 (The "Better Together" Story)

A Window into Your Data: Using SQL Window Functions

T-SQL Application Compatibility in SQL Azure: Today and Tomorrow

Hadoop and Its Ecosystem Components in Action

Information on NoSQL and Big data Programmability

Hello, My Name Is DAX

Microsoft's In-Memory Strategies and Offerings

SQL LocalDB: A NoHassle, Lightweight SQL Express for Developers

Managed Self-Service BI

Deploying SQL Server 2012 Failover Clustering Instances

You Can Do That with TSQL?

Don Kiely

Robert Cain

Todd Furst, Bill Emmert

Steve Hughes

Scott Shaw

Paresh Motiwala

Umachandar Jayachandran, Tobias Ternstrom

Andrew Brust

Michael Rys

Michael Antonovich

Dandy Weyn

Srini Acharya

Melissa Coates

Allan Hirt

Tim Ford

AD-304

AD-317

DBA-324-M

AD-319

PD-102

DBA-502

AD-306-M

BIA-201

AD-315-M

BID-304

AD-102-M

AD-318-M

BID-207

DBA-327

DBA-318

Creating a SQL Server SQL Server in Healthcare Best Practices Document

Close of PASS Summit 2012

PASS Summit 2012 | Seattle, WA.

5