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 SQLDiagReadTraceOSTRESSSQLNexusSQLProfiler, 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 SSISReporting Services 2005 Performance and ScalabilityIntegrating Reporting Services and SharePointSupporting 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:45pmSupporting SQL 2005 on Windows 2003 Server ClusteringShon Hauck, MicrosoftKorbel 2C
DBA-501-M - 3:30-4:45pmDebugging the Toughest Microsoft SQL Server ProblemsBob Ward, MicrosoftKorbel 2A/2B
Friday, September 21, 2007
BI-321-M - 1:00-2:15pmImplementing and Troubleshooting Database Mirroring with 2008 UpdatesMike Zawadski, Microsoft707
AD-409-M - 4:00-5:15pmTroubleshooting SQL Server 2005 Connectivity ErrorsWasifulla Hussain (SYED), Microsoft107/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 jobTroubleshooting with BID TraceTroubleshooting General Network ErrorAnalysis Services Query PerformanceTroubleshoot a failed cluster SetupTroubleshoot why Mirroring is falling behindTroubleshooting Latch waitsTroubleshooting 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 WardMicrosoft