Since 2003, Microsoft PSS engineers have been speaking and meeting customers at the PASS Summit. 2007 will be no different. In fact, this year ten of our top PSS engineers are coming into the conference to speak, host labs, and meet customers. I thought I would briefly outline how we will be involved in the summit this year:

Pre-Conference Seminars:

Monday, September 17, 2007 - The Performance Toolset Workshop

Joseph Pilov and myself will be presenting tools and techniques used by the Microsoft PSS team to analyze and resolve SQL Server Query Performance Problems. This talk will include live demonstrations involving practical situations with tools such as:

Performance Dashboard Reports
SQLDiag
ReadTrace
OSTRESS
SQLNexus
SQLProfiler, Clone Database, and Database Tuning Advisor

We will also discuss new features in SQL Server 2008 specifically designed to attach query performance issues.

Tuesday, September 18, 2007 - Supporting SQL Server BI

In past years, the involvement of the PSS team has mainly focused on the database engine. This year, I'm very excited that three of our top PSS engineers who support our BI products will come and talk about their support experience. Jason Howell, John Sirmon, and Wayne Robertson will be covering the following topics:

Top Issues in SSIS
Reporting Services 2005 Performance and Scalability
Integrating Reporting Services and SharePoint
Supporting Analysis Services

Conference Main Talks

We are presenting the following four talks during the main conference:

Thursday, September 20, 2007

DBA-417-M - 1:30-2:45pm
Supporting SQL 2005 on Windows 2003 Server Clustering
Shon Hauck, Microsoft
Korbel 2C

DBA-501-M - 3:30-4:45pm
Debugging the Toughest Microsoft SQL Server Problems
Bob Ward, Microsoft
Korbel 2A/2B

Friday, September 21, 2007

BI-321-M - 1:00-2:15pm
Implementing and Troubleshooting Database Mirroring with 2008 Updates
Mike Zawadski, Microsoft
707

AD-409-M - 4:00-5:15pm
Troubleshooting SQL Server 2005 Connectivity Errors
Wasifulla Hussain (SYED), Microsoft
107/109

The PSS Service Center

Ken Henderson coined this term back in 2003 and we are keeping this tradition going. Fany Vargas, Lakshmi Jonnakuti, and the rest of our team (when we are not speaking) will be in room 708 with our infamous self-paced troubleshooting labs. If you want some opportunities for real-world hands-on labs with SQL Server 2005, then come to room 708 and check them out.

Let me give you a flavor of some of the lab topics we plan on letting you try out:

Troubleshooting a failing SSIS package job
Troubleshooting with BID Trace
Troubleshooting General Network Error
Analysis Services Query Performance
Troubleshoot a failed cluster Setup
Troubleshoot why Mirroring is falling behind
Troubleshooting Latch waits
Troubleshooting SQL Engine Query Performance

The Service Center though has always been more than just hands-on self-paced troubleshooting labs. We want to meet you. Bring one of your current toughest issues with SQL Server to discuss with our team. This is a great opportunity for our PSS team to meet customers face to face. Although we love solving a tough problem, it is really a great chance for us to also hear about the success stories with SQL Server.

This is now my sixth PASS Summit to attend and speak and I'm just as excited the first time Ken Henderson invited me to the Seattle 2003 Summit. Please look me up at the conference at the Service Center or after my talk on Thursday. See you in Denver.

Bob Ward
Microsoft