Please note that this website will be temporarily unavailable during the period 5:00 PM PST on Friday, Dec. 19 and 11:59 PM PST on Saturday, Dec. 20 due to a planned server migration. PASS apologizes for any inconvenience.

Best of PASS Summit 2009

PASS is pleased to announce the top sessions from PASS 2009 Summit based on the opinions of all attendees who submitted completed session evaluation forms (8008). To download the presentation slides for any of these top sessions, simply click on the session title (login required).  Note: Pre/Post-Conference seminars are not linked to a session recording or presentation materials.

Please click here to view the questions asked on the survey.

Top 10 Sessions of 2009

1) DBA - Manageability Series: Understand and Troubleshoot with Policy-Based Management and Policy Collector 
Buck Woody (Microsoft Corp.)

  Q1 Q2 Q3 Q4 Q5 Q6
Mean 4.92  4.98  5  4.90  4.85  4.96

 

2) DBA - Disaster Recovery: Tips, Tricks, and Techniques (Post-conference seminar)
Paul Randal & Kimberly Tripp  (SQLskills.com)

  Q1 Q2 Q3 Q4 Q5 Q6
Mean  4.93  5  5  4.93  4.78  4.88

 

3) DBA - SQL Server Covering: Concepts, Concerns, & Costs
Kimberly Tripp (SQLskills.com) 

  Q1 Q2 Q3 Q4 Q5 Q6
Mean  4.91  4.96  4.97  4.92  4.65  4.94

 

4) BID - Monitor Your Business with PerformancePoint Services Monitoring and Analytics
Craig Utley (Solid Quality Mentors)

  Q1 Q2 Q3 Q4 Q5 Q6
Mean  4.86  5  5  4.86  4.71  4.86

 

5) DBA - Using SQL Server 2008 for Performance Tuning
Buck Woody (Microsoft Corp.)

  Q1 Q2 Q3 Q4 Q5 Q6
Mean  4.84  4.94  4.95  4.85  4.72  4.9

 

6) DBA - Understanding Logging and Recovery in SQL Server
Paul Randal (SQLskills.com)

  Q1 Q2 Q3 Q4 Q5 Q6
Mean  4.71  4.96  4.98  4.88  4.58  4.80

 

7) DBA - Lies, damned lies and statistics
Gail Shaw  (XpertEase) 

  Q1 Q2 Q3 Q4 Q5 Q6
Mean  4.80  4.80  4.91  4.89  4.80  4.80

 

8) DBA - DRP101: Learn The Difference Between Your Log And Your Cluster
Brent Ozar (Quest Software) 

  Q1 Q2 Q3 Q4 Q5 Q6
Mean  4.72  4.89  4.83  4.78  4.67  4.83

 

9) DBA - Manageability Series: Microsoft SQL Server Automation on Steroids, Including PowerShell Support
Buck Woody 
(Microsoft Corp.) 

  Q1 Q2 Q3 Q4 Q5 Q6
Mean  4.71  4.95  4.92  4.76  4.53  4.77

 

10) DBA - Inside SQL Server Wait Types
Bob Ward 
(Microsoft Corp.)

  Q1 Q2 Q3 Q4 Q5 Q6
Mean  4.73  4.91  4.98  4.89  4.33  4.76

 

Top 5 Sessions Per Track

Sort by track: Aplication and Database Development | BI Platform Architecture, Development and Administration | BI Information Delivery | Enterprise Database Administration and Deployment | Professional Development

Application and Database Development

1) Managing Hierarchies in SQL Server 2008 with HIERARCHYID
Peter DeBetta  (Microsoft Corp.)

2) Optimizing SQL Server 2008 Applications using Table Valued Parameters, XML and MERGE
Tobias Ternstrom  (Microsoft Corp.)

3) T-SQL Tips & Tricks
Itzik Ben-Gan (Solid Quality Mentors)

4) Nordic - turn SQL Server into an Object Db
Paul Nielsen (www.SQLServerBible.com)

5) Making Effective Use of the Plan Cache
Greg Low (Solid Q Australia)

BI Platform Architecture, Development and Administration

1) Security and Deployment with Reporting Services 2008 R2
Lukasz Pawlowski (Microsoft Corp.)

2) ETL from the Trenches: Using SSIS in the Real World
Dave Fackler (Rolling Hills Enterprises, Inc.)

3) SQLCAT: A Preview of PowerPivot Best Practices
Denny Lee (Microsoft Corp.)

4) Managing PowerPivot
John Hancock  
(Microsoft Corp.)

5) BI Power Hour
Pej Javaheri (Microsoft Corp.)

BI Information Delivery

1) Monitoring Your Business with PerformancePoint Services Monitoring and Analytics
Craig Utley (Solid Quality Mentors)

2) Introducing PowerPivot for Excel
Amir Netz (Microsoft Corp.)

3) Business Intelligence in Microsoft SharePoint Server 2010
Pej Javaheri (Microsoft Corp.)

4) Advanced BI Capabilities in Excel & Excel Services
Diego Oppenheimer (Microsoft Corp.)

5) Data Analysis Expressions in PowerPivot for Excel 2010
Howie Dickerman (Microsoft Corp.)

Enterprise Database Administration and Deployment

1) Manageability Series: Understand and Troubleshoot with Policy-Based Management and Data Collector
Buck Woody (Microsoft Corp.)

2) SQL Server Covering: Concepts, Concerns, & Costs
Kimberly Tripp 
(SQLskills.com)

3) Using SQL Server 2008 for Performance Tuning
Buck Woody (Microsoft Corp.)

4) Understanding Logging and Recovery in SQL Server
Paul Randal (SQLskills.com)

5) Lies, damned lies and statistics
Gail Shaw (XpertEase)

Professional Development

1) Team Management Crash Course
Kevin Kline (Quest Software)

2) A Tale of Careers and User Groups
Andy Leonard 
(Unisys Corporation)

3) Achieving Work-Life Balance - What does it really mean?
Denise McInerney (Intuit)

4) Soft Skills - Now More Than Ever
Chuck Heinzelman (Big Hammer Data)

5) Social Computing for the Database Professional
Jason Massie (Terremark)

How Do You Compare?

Q1 - How would you rate the usefulness of the session information in your day-to-day environment?  
Sample Mean Median Lowest Score Highest Score
Overall for 2009  4.30  4.35  N/A  N/A
AD  4.19  4.26  3.43  4.81
BIA  4.25  4.33  3.52  4.75
BID  4.33  4.30  3.75  4.86
DBA  4.39  4.39  3.83  4.92
PD  4.26  4.30  3.73  4.81


 

Q2 - How would you rate the Speaker's presentation skills?  
Sample Mean Median Lowest Score Highest Score
Overall for 2009  4.39  4.50  N/A  N/A
AD  4.42  4.54  3.45  4.85
BIA  4.42  4.48  3.72  4.86
BID  4.42  4.44  3.40  5
DBA  4.42  4.46  3.40  4.98
PD  4.40  4.43  3.87  4.94


 

Q3 - How would you rate the Speaker's knowledge of the subject?  
Sample Mean Median Lowest Score Highest Score
Overall for 2009 4.69 4.74  N/A  N/A
AD  4.69  4.75  4  4.95
BIA  4.66  4.75  3.86  4.95
BID  4.65  4.60  4.35  5
DBA  4.68  4.76  4.11  5
PD  4.60  4.56  4.27  4.88


 

Q4 - How would you rate the accuracy of the session title, description, and experience level to the actual session?  
Sample Mean Median Lowest Score Highest Score
Overall for 2009 4.46 4.49  N/A  N/A
AD  4.43  4.53  3.71  4.89
BIA  4.41  4.44  3.52  4.82
BID  4.46  4.42  4.02  4.86
DBA  4.49  4.49  3.91  4.92
PD  4.49  4.58  3.96  4.84


 

Q5 - How would you rate the amount of time allocated to cover the topic/session?  
Sample Mean Median Lowest Score Highest Score
Overall for 2009 4.28 4.32  N/A  N/A
AD  4.26  4.35  3.45  4.66
BIA  4.22  4.31  3.45  4.66
BID  4.33  4.32  3.87  4.71
DBA  4.30  4.29  3.80  4.85
PD  4.26  4.29  3.81  4.56


 

Q6 - How would you rate the quality of the presentation materials?  
Sample Mean Median Lowest Score Highest Score
Overall for 2009 4.38 4.41  N/A  N/A
AD  4.37  4.44  3.70  4.78
BIA  4.34  4.41  3.48  4.82
BID  4.41  4.45  3.61  4.86
DBA  4.41  4.40  3.83  4.96
PD  4.26  4.26  3.90  4.75

Visuals

 Coming soon