This 24 Hours of PASS: Summit Preview event took place on September 9, beginning at 12:00 UTC and featured 24 webcasts delivered over 24 hours. The event provided a glimpse into the unparalleled content on offer at PASS Summit 2014, November 4-7, in Seattle, WA.

Search sessions by track:
Application & Database Development
BI Information Delivery
BI Platform Architecture, Development & Administration
Enterprise Database Administration & Deployment
Professional Development

Application & Database Development

Are Your Indexes Hurting You or Helping You?
Queries need your help! Your mission, should you choose to accept it, is to make great decisions...
Jes Borland

Query Performance Tuning in SQL Server 2014 
At Summit, I’ll be presenting a full-day session that takes you through everything you need in...
Grant Fritchey

Real World SQL 2014 Migration Path Decisions
The mission is clear: update your SQL Server to SQL Server 2014. But this may be where the clarity...
Chris Shaw, John Morehouse

Spatial Data: Looking Outside the Map
It’s been said before and it’ll be said again: spatial data doesn't get much love in SQL Server....
Hope Foley

Zero to Hero with PowerShell and SQL Server
There are two kinds of people in the SQL Server world: those who are using PowerShell, and those...
Robert Cain, Bradley Ball, Jason Strate

BI Information Delivery

"I Want It NOW!" Data Visualization with Power View
Historically, users have been constrained to consume data in fixed platforms, with one specific...
Julie Koesmarno

Business Intelligence Toolkit Overview: Microsoft Power BI and R
The "why" of Business Intelligence is every bit as important as the "how" we do it technically....
Jen Stirrup

Past to Future: Self-service Forecasting with Microsoft BI
Imagine taking historical sales data and using data science to more accurately predict future sales...
Peter Myers

Troubleshoot Customer Performance Problems Like a Microsoft Engineer
In this session Microsoft Principal field engineer Denzil Ribeiro and Senior field engineer Tim...
Tim Chapman, Denzil Ribeiro

BI Platform Architecture, Development & Administration

Agile Data Warehousing: Start to Finish
This session will be a preview of Davide Mauri's PASS Summit 2014 Agile Data Warehousing Workshop....
Davide Mauri

Create your first SSAS Tabular Model
In this session, you will learn how to create your first Analysis Services Tabular model, using...
Marco Russo

DAX Formulas in Action 
In this demo-heavy session, Alberto Ferrari will show you how to build a working prototype of a...
Alberto Ferrari

Performance Tuning SQL Server Integration Services (SSIS)
In this demo-rich presentation, Brian Knight shows you some of the common and not-so-common ways to...
Brian Knight

Predictive Analytics in the Enterprise
Data science is a booming field, but what does that mean for SQL Server DBAs, developers and...
Carlos Bossy

Enterprise Database Administration & Deployment

Availability Groups vs. Failover Cluster Instances: What’s the Difference?
Both availability groups (AGs) and clustered instances of SQL Sevrer (FCIs) use an underlying...
Allan Hirt

Developers: Who Needs a DBA?
You store data in SQL Server, but you don't have enough work to keep a full-time DBA busy. In...
Brent Ozar

Everything You Never Wanted to Know about Extended Events
Let's cut to the chase: it's time to start using Extended Events (XE). We know you have your...
Erin Stellato, Jonathan Kehayias

Guessing Games: Statistics, Heuristics, and Row Estimations
Estimated rows: 17.5862. Ever wonder how the query optimizer comes up with these row estimations?...
Gail Shaw

In-Memory OLTP Internals: How is a 30x Performance Boost Possible?
SQL Server Hekaton, a.k.a. In-Memory OLTP, will completely change the way you think about data...
Kalen Delaney

Manage Both On-Prem and Azure Databases with PowerShell
In today's world, you're more likely to have databases both on premises and in the cloud. Managing...
Allen White

Secure Your SQL Server Instance without Changing Any Code
Secure your SQL Server infrastructure and your Windows installations to enhance resiliency and...
Argenis Fernandez

SQL Server AlwaysOn Quickstart
In this session, we will discuss what the SQL Server AlwaysOn high availability and disaster...
Ryan Adams

Professional Development

Hiring the Right People: Interviewing and Selecting the Right Team
Interviews are the business equivalent of “speed dating.” We shuffle through resumes, rapidly...
Joe Webb

Irreplaceable: Techniques to Fireproof Your IT Career
What are the life skills that some IT professionals have in common that enable them to avoid...
Kevin Kline

PASS Summit 2014