Pre-Conference Sessions

To add a Pre-Conference session to your existing registration, please call Shannon Cunningham at 888.714.5544 or via email.

Pre-Con Previews

Go inside our full-day pre-conference sessions in this Q&A series with our presenters! 

Monday, November 03, 2014

Mastering T-SQL Querying Fundamentals (AD-299-P)
Application & Database Development
T-SQL was named the most popular programming language in 2013. If you work with SQL Server in any...
Itzik Ben-Gan

Real World End-to-End Performance Solutions (AD-399-P)
Application & Database Development
Do you ever wonder how other people approach real world business objectives from start to finish?...
Chris Shaw, John Morehouse

Zero to Hero with PowerShell and SQL Server (AD-297-P)
Application & Database Development
There are two kinds of people in the SQL Server world: those who are using PowerShell, and those...
Robert Cain, Bradley Ball, Jason Strate

Big Data: Deploy, Design, and Manage Like a Pro (BIA-396-P)
BI Platform Architecture, Development & Administration
Attendees will leave with a live-deployed Hadoop environment they can take back to their company...
Adam Jorgensen, John Welch

Data Modeling in SSAS Tabular (BIA-398-P)
BI Platform Architecture, Development & Administration
Analysis Services offers two different types of modeling: Tabular and Multidimensional. The...
Marco Russo

Predictive Analytics in the Enterprise (BIA-299-P)
BI Platform Architecture, Development & Administration
Data science is a booming field, but what does that mean for SQL Server DBAs, developers and...
Carlos Bossy

In-Memory OLTP Internals: How is a 30x Performance Boost Possible? (DBA-398-P)
Enterprise Database Administration & Deployment
SQL Server In-Memory OLTP (code name: Hekaton) is Microsoft’s new technology being shipped as part...
Kalen Delaney

Performance Troubleshooting Using Waits and Latches (DBA-499-P)
Enterprise Database Administration & Deployment
One of the first things you should check when investigating performance issues are wait and latch...
Paul Randal

Tuesday, November 04, 2014

Better Performance through Parallelism (AD-499-P)
Application & Database Development
Today's server hardware ships with a truly massive amount of CPU power. And while SQL Server is...
Adam Machanic

Query Performance Tuning in SQL Server 2014 (AD-298-P)
Application & Database Development
Sometimes, just buying bigger and better hardware is not an option, but you still have problems...
Grant Fritchey

Superhero Power BI (BID-399-P)
BI Information Delivery
Personal, heroic deeds, and the right gadgets are the making of a true superhero. In this day-long...
Peter Myers

Agile Data Warehousing: Start to Finish (BIA-399-P)
BI Platform Architecture, Development & Administration
The Data Warehouse plays a central role in any BI solution: it's the back end upon which everything...
Davide Mauri

From 0 to DAX  (BIA-397-P)
BI Platform Architecture, Development & Administration
The DAX language is the foundation of self-service Business Intelligence using the Microsoft stack....
Alberto Ferrari

SSIS: Problem, Design, Solution (BIA-395-P)
BI Platform Architecture, Development & Administration
Join this full-day session to learn how to solve real world data extraction problems using SSIS...
Brian Knight, Devin Knight

Everything You Never Wanted to Know about Extended Events (DBA-399-P)
Enterprise Database Administration & Deployment
Let's cut to the chase: it's time to start using Extended Events (XE). We know you have your...
Erin Stellato, Jonathan Kehayias

The A to Z of Availability Groups (DBA-397-P)
Enterprise Database Administration & Deployment
Ever since it was introduced in SQL Server 2012, Availability Groups (AGs) have been a source of...
Allan Hirt

Troubleshoot Customer Performance Problems Like a Microsoft Engineer (DBA-396-P)
Enterprise Database Administration & Deployment
Performance troubleshooting is arguably one of the most difficult aspects of being a database...
Tim Chapman, Denzil Ribeiro