www.sqlpass.org

 



Register Now
 
ROI Justification



Sponsors

Questions?

 

PASS Facebook PASS LinkedIn PASS Twitter

  

Premier Sponsor:

 

Platinum Sponsors:

    



 

Minimize

Community Experts Picks

These must-see session lists were put together for this year's Summit by these well-respected members of the SQL Server community: Adam Machanic, Davide Mauri, Grant Fritchey, Brent Ozar, Rob Farley & Jessica Moss

Adam Machanic's "So You Want to Be a SQL Badass" PASS Summit Schedule

Tuesday, November 9

Identify and Fixing Performance Problems using Execution Plans (AD-371-S)
Grant Fritchey

Session on SQL developer tools (DBA-371-M)
Don Box

Best Practices for Data Warehousing with SQL Server 2008 and 2008 R2 (DBA-362-M)
Eric Hanson

Si Se Puede! Achieving Separation of Duties with SQL Server (DBA-448-M)
Il-Sung Lee & Lara Rubbelke

What Happened? Auditing, Tracking, and Change Monitoring Technologies in SQL Server 2008 (DBA-386-S)
Adam Machanic
 
Wednesday, November 10

CSS Update Queries - Under the Hood (90min) (DBA-588-C)
Conor Cunningham

The Incredible Shrinking Execution Plan (AD-311)
Rob Farley

High Performance Batch Processing in SQL (AD-313)
Simon Sabin

Inside SQL Server Latches (90 mins) (DBA-599-C)
Bob Ward
 
Thursday, November 11

Query tuning Tips (AD-475-S)
Itzik Ben-Gan

Expert Query Performance Troubleshooting (DBA-449-M)
Boris Baryshnikov

What's new in T-SQL in the Next Release of SQL Server (DBA-346-M)
Tobias Ternstrom

Seeking SQL Server Secrets (DBA-284-S)
Kalen Delaney
 
Friday, November 12

A Day of Doing Many Things at Once: Multitasking, Parallelism, and Process Distribution (AD-311-P)
Adam Machanic

Davide Mauri

Tuesday, November 9

SQLCAT: Designing scalable and complex Analysis Service Cubes: Lessons learned from the Field (90 mins) (BIA-499-A)
Denny Lee

Comparing PowerPivot with Analysis Services (BIA-412)
Chris Webb

Avoid Slow SSAS Queries: MDX Query Troubleshooting (BIA-413)
Craig Utley

Best Practices for Data Warehousing with SQL Server 2008 and 2008 R2 (DBA-362-M)
Eric Hanson
 
SQLCAT: Optimizing application workload & performance by leveraging  AppFabric Cache along with SQL Server (AD-386-A)
Rama Ramani

Tracking Waits with Extended Events in SQL Server 2008 (DBA-492-S)
Andrew Kelly

Wednesday, November 10

CSS Update Queries – Under the Hood (90 min) (DBA-588-C)
Conor Cunningham

Business Intelligence and the Cloud (75R1) (BIA-379-M)
Russ Humphries & Vasile Paraschiv 

Realizing ROI for Business Intelligence Projects (BIA-203)
Douglas McDowell

Kerberos, SQL and You (DBA-499-C)
Adam Saxton

Scaling OLTP Application: My app doesn’t scale, you wonder why? (AD-390-M)
Kevin Cox

Building NextGen Scalable & Highly Available Architectures with Microsoft SQL Server 2008 R2 (DBA-461)
Rajinder Gill

What’s coming next in SSIS (BIA-380-M)
Matt Masson

Inside SQL Server Latches (90 min) (DBA-599-C)
Bob Ward

SQLCAT: Administering SQL Azure and new challenges for DBAs (DBA-358-A)
George Varghese

Managing system performance with the Data Collector and Management Data Warehouse with Reporting Services (DBA-450-M)
Bill Ramos

Thursday, November 11

Query Tuning Tips (AD-475-S)
Itzik Ben-Gan

Enterprise SQL IO optimization best practices (DBA-359-M)
Kevin Farlee

Expert Query Performance Troubleshooting (DBA449-M)
Boris Baryshnikov & Conor Cunningham

Implementing a Data Cleansing Component for SSIS (BIA-414)
John Welch

Consolidating data collection with SQLDIAG and analysing it all with SQLNexus (DBA-378)
Christian Bolton

What's new in T-SQL in the Next Release of SQL Server (DBA-346-M)
Tobias Ternstrom  

SQLCAT: Next Generation Real Time Data Processing using StreamInsight (AD-485-A)
Mark Simms

Migrating & Authoring Applications to Microsoft SQL Azure (AD-391-M)
Cihan Biykoglu

Grant Fritchey's Must See Sessions:

Tuesday, November 9

The “Numbers” or “Tally” Table: What it is and how it replaces a loop (AD-204)
Jeff Moden

Thursday, November 11

Query Tuning Tips (AD-475-S)
Itzik Ben-Gan

Seeking SQL Server Secrets (DBA284-S)
Kalen Delany

Database Testing Overview ((AD-314)
Buck Woody

Heaps of Trouble, Clusters of Glory (DBA-248)
Michelle Ufford

Brent Ozar

Tuesday, November 9

Identifying and Fixing Performance Problems using Execution Plans (AD-371-S)
Grant Fritchey 

Introduction to SQL Server Statistics (DBA-238)
Andy Warren

Wednesday, November 10

CSS Update Queries – Under the Hood (DBA-588-C)
Conor Cunningham

The Incredible Shrinking Execution Plan (AD-311)
Rob Farley

The Art of Indexing (DBA-253)
Ken Simmons

Tales from the Trenches: GUIDs - Use, Abuse, and How to Move Forward (AD-372-S)
Kimberly Tripp

Thursday, November 11

DBA Mythbusters (DBA-285-S)
Paul Randal

Expert Query Performance Troubleshooting (DBA-449-M)
Boris Baryshnikov & Conor Cunningham

High Performance Functions (AD-312)
Simon Sabin

Consolidating data collection with SQLDIAG and analysing it all with SQLNexus (DBA-378)
Christian Bolton

Heaps of Trouble, Clusters of Glory - A Look at Index Internals (DBA-248)
Michelle Ufford

Performance Tuning with the Plan Cache (DBA-246)
Jonathan Kehayias

Database Design Fundamentals (AD-270-S)
Louis Davidson

Rob Farley

Tuesday, November 9

Comparing PowerPivot with Analysis Services (BIA-412)
Chris Webb 

Avoid Slow SSAS Queries: MDX Query Troubleshooting (BIA-413)
Craig Utley

Demystifying MDX in Reporting Services (BID-218)
Stacia Misner

Thursday, November 11

Real World Analysis Services Stored Procedures (BIA-206)
Stacia Misner

Debugging Performance Problems in Analysis Services (BIA-311)
Tim Peterson

Jessica M Moss

Tuesday, November 9

Top SSRS session - Ad Hoc Reporting Revisited (BID-274-M)
Carolyn Chau & Thierry D'Hers

Top Real World SSAS Session - SQLCAT: Designing scalable and complex Analysis Service
Cubes: Lessons learned from the Field (90 mins)
(BIA-499-A)
Denny Lee & Thomas Kejser

Best Session for a Summit BI First Timer - Business Intelligence Power Hour (BID-275-M)
Carlson Quick

Most Forward Thinking BI Session - Comparing PowerPivot with Analysis Services (BIA-412)
Chris Webb 

Wednesday, November 10

Crowd Favorite BI Session - Business Intelligence – end-to-end (BIA-299-M)
Donald Farmer, Pej Javaheri & Russ Humphries

Jessica's "Won't Miss" BI Session - What’s coming next in SSIS (BIA-380-M)
Matt Masson

Thursday, November 11

Most Unique SSIS Session - Implementing a Data Cleansing Component for SSIS (BIA-414)
John Welch


Gold Sponsors

     
     

 

Copyright 2010 by PASS | Terms of Use | Privacy Policy | Login | Register