PASS Summit 2011: Spotlight Sessions

Spotlight session speakers have received high ratings and great reviews for previously delivered sessions at PASS Summit. These engaging and highly regarded speakers have been invited back by popular demand for PASS Summit 2011. (Please note that these sessions are subject to change.)

Don't miss out, register for PASS Summit 2011 right now.


Search sessions by track:
Application and Database Development
BI Architecture, Development and Administration Topics
BI Client Reporting and Delivery Topics
Enterprise Database Administration and Deployment

Application and Database Development

Bug or Feature? (AD-309-S)
Some behaviors in T-SQL are clear bugs and some are clear features. But being a relational language...
Itzik Ben-Gan

DMOs as a Shortcut for Performance Tuning (AD-207-S)
Dynamic Management Objects(DMO) expose a wealth of information to the database administrator....
Grant Fritchey

Five Physical Database Design Blunders and How to Avoid Them (AD-208-S)
What’s going on in your physical data models and databases? Who actually decides what goes into the...
Karen Lopez

Joins, SARGability and the Evils of Residualiciousness (AD-310-S)
You wouldn't believe how often people just aren't using their indexes effectively, whether it be...
Rob Farley

Query Tuning Mastery: Zen and the Art of Workspace Memory (AD-500-S)
As SQL Server professionals, we often think of memory in vague, instance-level terms: buffer pool,...
Adam Machanic

SQL Server Execution Plans – From Compilation To Caching To Reuse (AD-403-S)
Execution plan reuse is one of the most important aspects of building well-performing and scalable...
Maciej Pilecki

T-SQL Awesomeness - 3 Ways to Write Cool SQL (AD-308-S)
There’s nothing quite as satisfying as writing a cool bit of T-SQL. Luckily for us, there are some...
Audrey Hammonds

BI Architecture, Development and Administration Topics

Introduction to Data Mining in SQL Server Analysis Services (BIA-310-S)
Data mining is one of the key hidden gems inside of Analysis Services but has traditionally had a...
Brian Knight

One Hard Problem: Multivalued Dimension Relationships (BIA-203-S)
Many attendees know the basics of dimensional modeling: facts, dimensions, and dimension attribute...
Joy Mundy

Temporal Snapshot Fact Table (BIA-406-S)
You are designing a BI Solution and your customer ask you to keep a snapshot of the status of all...
Davide Mauri

Upgrading SSIS to Denali –Management Considerations and Best Practices (BIA-311-S)
SQL Server Denali introduces a number of exciting new features that will change the way we deploy...
Rushabh Mehta

Zero to Cube - Fast Track to SSAS Development (BIA-202-S)
This session was TOP 3 in its track last year and is always a crowd pleaser. I won a coveted Summit...
Adam Jorgensen

BI Client Reporting and Delivery Topics

End-to-End SQL Server PowerPivot (BID-305-S)
One of the pillars of SQL Server 2008 R2 is Managed Self-Service BI. The SQL Server PowerPivot for...
Peter Myers

Visual Report Design: Bringing Sexy Back (BID-304-S)
Do your users have the same old, mundane table reports they’ve been using for decades? Stop living...
Paul Turley

Enterprise Database Administration and Deployment

Bad plan! Sit! (DBA-311-S)
Bad execution plans are the bane of database performance everywhere they crop up. But what is a bad...
Gail Shaw

BLITZ! The SQL - More One Hour SQL Server Takeovers (DBA-104-S)
During last year's 24 Hours of PASS, Brent Ozar gave you a script to quickly assess the health,...
Brent Ozar

Hardware 301: Diving Deeper into Database Hardware (DBA-312-S)
Making the right hardware selection decisions is extremely important for database scalability....
Glenn Berry

Implementing SQL Server Denali Using Windows Server Core (DBA-408-S)
One of the most exciting new features in SQL Server Denali is support for Windows Server Core....
Allan Hirt

Isolated Disasters in VLDBs (DBA-315-S)
SQL Server provides a few key features that allow VLDBs to survive—and keep processing—after...
Kimberly Tripp

More DBA Mythbusters (DBA-316-S)
It's amazing how many myths and misconceptions have sprung up and persisted over the years about...
Paul Randal

New Year, New Dirty Dozen PowerShell Scripts (DBA-335-S)
You’ve heard it said, “If you have to do it twice, automate it.” That’s great advice and PowerShell...
Aaron Nelson

Using Event Notifications in SQL Server 2005/2008 (DBA-313-S)
Event Notifications are a powerful tool in the Database Administrators tool kit that are often...
Jonathan Kehayias

What Happened? Exploring the Plan Cache (DBA-314-S)
What Happened? Exploring the Plan Cache Being pro-active,and using one of the various tracing...
Kalen Delaney




Why Attend?

■ All SQL Server. All the time

■ Over 170 technical sessions

■ Dr. David DeWitt Keynote

■ 2 days of Pre-Con Seminars

■ Networking with MVPs, experts, and peers

■ Face-to-face support with     Microsoft CSS and SQLCAT

■ Ask the Experts Pods



Premier Sponsor


Platinum Sponsor