Sessions


Track Key:
 BI, Big Data, and Data Visualization Keynotes & General Sessions
 SQL Server Administration and Maintenance SQL Server Features and Components
 SQL Server for the Developer SQL Server in the Cloud
 SQL Server Performance Tuning and Optimization SQL Server Tools, Tricks, and Techniques
 Workshops
Sunday, November 17, 2013
TIME EVENT
Sunday
4:00pm - 9:00pm
 
Pre-Conference Registration
Sunday
6:00pm - 9:00pm
 
Dine-A-Round Dinner
Monday, November 18, 2013
TIME EVENT
Monday
8:00am - 5:00pm
 
SQM01   Workshop: The Data Warehousing Process in a Day - Design, Build, and Deliver

Craig Utley

Monday
8:00am - 5:00pm
 
SQM02  Workshop: SQL Server Maintenance and PTO Crash Course

Don Jones, MVP

Monday
8:00am - 5:00pm
 
SQM03   Workshop: SQL Server for Developers

Leonard Lobel, MVP

Monday
5:00pm - 7:00pm
 
EXPO Preview
Monday
7:00pm - 8:00pm
 
Live! 360 Keynote: Mary Jo Foley on Microsoft and the Devices and Services Reality

Mary Jo Foley

Tuesday, November 19, 2013
TIME EVENT
Tuesday
8:00am - 9:00am
 
SQL Server Live! Keynote: SQL Server 2014 and the New World of Data

Scott Klein

Tuesday
9:00am - 9:30am
 
Networking Break • Visit the EXPO
Tuesday
9:30am - 10:45am
 
SQT01   SQL Server 2012 Enterprise Features That Every Business Should Know

Bradley Ball

Tuesday
9:30am - 10:45am
 
SQT02   Introducing SQL Server Data Tools

Leonard Lobel, MVP

Tuesday
9:30am - 10:45am
 
SQT03   Analysis Services 2012 End-to-End

Craig Utley

Tuesday
9:30am - 10:45am
 
SQT04  Everything You Never Wanted to Know About Indexes, but Have to Know Anyway

Don Jones, MVP

Tuesday
11:00am - 12:15pm
 
SQT05   SQL Server 2014: A First Look at Whats New!

Bradley Ball

Tuesday
11:00am - 12:15pm
 
SQT06   Programming the T-SQL Enhancements in SQL Server 2012

Leonard Lobel, MVP

Tuesday
11:00am - 12:15pm
 
SQT07   Add It Up: Analysis Services Aggregations

Craig Utley

Tuesday
11:00am - 12:15pm
 
SQT08  The Creepy DBA, How to Stalk Your Users

Jason Strate

Tuesday
12:15pm - 2:00pm
 
Lunch • Visit the EXPO
Tuesday
2:00pm - 3:15pm
 
SQT09   HSQL Server 2014 "Hekaton" (a.k.a. In-Memory OLTP) Deep Dive

Bradley Ball

Tuesday
2:00pm - 3:15pm
 
SQT10  "What Did I Do?" T-SQL Worst Practices

Pinal Dave, MS Computer Science

Tuesday
2:00pm - 3:15pm
 
SQT11   Securing SSAS Data Without Tying Yourself in Knots

Craig Utley

Tuesday
2:00pm - 3:15pm
 
SQT12  DBA Task Automation: Unleash the PowerShell Hero in You!

Michael Wells

Tuesday
3:15pm - 4:15pm
 
Networking Break • Visit the EXPO
Tuesday
4:15pm - 5:30pm
 
SQT13  Dealing with Errors in SSIS 2012

David Dye

Tuesday
4:15pm - 5:30pm
 
SQT14  SQL Server Tracing for Developers

Jason Strate

Tuesday
4:15pm - 5:30pm
 
SQT15   An Overview of PowerPivot for Excel

William E. Pearson III

Tuesday
4:15pm - 5:30pm
 
SQT16  Using PowerShell to Quickly Deploy New SQL Server Instances

Michael Wells

Tuesday
5:30pm - 7:30pm
 
Live! 360 Exhibitor Reception
Wednesday, November 20, 2013
TIME EVENT
Wednesday
8:00am - 9:00am
 
Live! 360 Keynote: There’s No Future in the Past: A Critique of Conventional Thinking on the Radical Changes in Our Industry

Billy Hollis

Wednesday
9:15am - 10:30am
 
SQW01   Into the Wild....Taming Unstructured Data with Semantic Search

Christopher Price

Wednesday
9:15am - 10:30am
 
SQW02   Near Unlimited Scalability with SQL Azure Federations

Arie Jones

Wednesday
9:15am - 10:30am
 
SQW03   Through Gardens Overgrown: PowerPivot to Analysis Services 2012 Tabular

William E. Pearson III

Wednesday
9:15am - 10:30am
 
SQW04   Database Performance Tricks Every SharePoint Admin Must Know

Pinal Dave, MS Computer Science

Wednesday
10:30am - 11:00am
 
Networking Break • Visit the EXPO
Wednesday
11:00am - 12:15pm
 
SQW05   Integrating Reporting Services with SharePoint

Kevin Goff, Microsoft SQL Server MVP

Wednesday
11:00am - 12:15pm
 
SQW06   Migrating to Windows Azure SQL Database

Scott Klein

Wednesday
11:00am - 12:15pm
 
SQW07   Exploring Data with Data Explorer

Steve Hughes

Wednesday
11:00am - 12:15pm
 
SQW08  Inside the Query Optimizer

Bradley Ball

Wednesday
12:15pm - 1:45pm
 
Round Table Lunch • Visit the EXPO
Wednesday
1:45pm - 3:00pm
 
SQW09   Implementing a Tabular Data Model with Microsoft PowerPivot and Analysis Services

Arman Saffarnia

Wednesday
1:45pm - 3:00pm
 
SQW10   Troubleshooting and Monitoring Windows Azure SQL Databases

Scott Klein

Wednesday
1:45pm - 3:00pm
 
SQW11   Excel: An Analytics Superhub

Andrew Brust

Wednesday
1:45pm - 3:00pm
 
SQW12  Ancient Problems and Modern Solutions - Troubleshooting CPU

Pinal Dave, MS Computer Science

Wednesday
3:00pm - 4:00pm
 
Networking Break • Visit the EXPO • Expo Raffle @ 3:30 p.m.
Wednesday
4:00pm - 5:15pm
 
SQW13   Planning and Configuring SQL and SharePoint 2013 Business Intelligence (PowerPivot and Power View)

Arman Saffarnia

Wednesday
4:00pm - 5:15pm
 
SQW14   The Absolute Beginner's Guide to Windows Azure SQL Database

Kevin Goff, Microsoft SQL Server MVP

Wednesday
4:00pm - 5:15pm
 
SQW15   Big Data 101 with HDInsight

Andrew Brust

Wednesday
4:00pm - 5:15pm
 
SQW16  To Be Announced
Wednesday
8:00pm - 10:00pm
 
Live! 360 Dessert Luau
Thursday, November 21, 2013
TIME EVENT
Thursday
8:00am - 9:15am
 
SQH02  Virtualizing SQL Server (Yes, You Can)

Don Jones, MVP

Thursday
8:00am - 9:15am
 
SQH03   SSAS 911 -The Field Medics Guide to Performance Tuning Analysis Services

Christopher Price

Thursday
8:00am - 9:15am
 
SQH04   The Transaction Log and How It Affects High Availability and Disaster Recovery

Edwin Sarmiento

Thursday
9:30am - 10:45am
 
SQH05   Fundamentals of SQL Server AlwaysOn Availability Groups

Edwin Sarmiento

Thursday
9:30am - 10:45am
 
SQH06  Column Level Encryption in SQL Server

David Dye

Thursday
9:30am - 10:45am
 
SQH07  SQL Server 2012 Columnstore Index

Kevin Goff, Microsoft SQL Server MVP

Thursday
9:30am - 10:45am
 
SQH08   Performance Tuning When It Isn't Your Database

Don Jones, MVP

Thursday
11:00am - 12:15pm
 
SQH09   Architecting a SQL Server AlwaysOn Availability Groups Topology

Edwin Sarmiento

Thursday
11:00am - 12:15pm
 
SQH10  Implementing Auditing in SQL Server 2012

David Dye

Thursday
11:00am - 12:15pm
 
SQH11   What's New in SQL Server Integration Services 2012

Kevin Goff, Microsoft SQL Server MVP

Thursday
11:00am - 12:15pm
 
SQH12  To Be Announced
Thursday
12:15pm - 1:30pm
 
Lunch
Thursday
1:30pm - 2:45pm
 
SQH13  A Window into Your Data Using SQL Window Functions

Steve Hughes

Thursday
1:30pm - 2:45pm
 
SQH14  Designing and Managing a SQL Server Replication Topology

Chad Churchwell

Thursday
1:30pm - 2:45pm
 
SQH15   Utilizing Knowledge with Data Quality Services in SQL Server 2012

Arie Jones

Thursday
1:30pm - 2:45pm
 
SQH16   Troubleshoot SQL Server Performance Issues using Wait Statistics

Edwin Sarmiento

Thursday
3:00pm - 4:15pm
 
SQH17   O, There's My Data, OData for Data Guys

Steve Hughes

Thursday
3:00pm - 4:15pm
 
SQH18  Managing SQL Server in the Enterprise

Chad Churchwell

Thursday
3:00pm - 4:15pm
 
SQH19   MDS in Practice: An Integrated Approach

Christopher Price

Thursday
3:00pm - 4:15pm
 
SQH20   SQL Server Query Performance Tuning: A 12-Step Process

Scott Klein

Thursday
4:30pm - 5:45pm
 
.NET Rocks! & Xamarin - Building Modern Apps Leveraging the Cloud
Friday, November 22, 2013
TIME EVENT
Friday
8:00am - 5:00pm
 
SQF02   Workshop: Big Data and NoSQL for Database and BI Pros - Intermediate

Andrew Brust

Friday
8:00am - 5:00pm
 
SQF01   Workshop: Cloud Ready - Preparing Yourself for Azure SQL Databases

Arie Jones