About Show #195
Richard flies solo to talk to Pam Lahoud about SQL Server performance. Not just fighting slow queries, but planning in advance for poor performance behavior. The conversation digs into techniques to anticipate where performance problems will occur. Pam provides a list of great tools to use for understanding your performance problem in SQL Server, including SQL Nexus (http://sqlnexus.codeplex.com/) and PAL (http://pal.codeplex.com/).
Pam has been with Microsoft for 5 years specializing in SQL Server Performance Tuning and optimization in the New York City area. She is a SQL 2008 Microsoft Certified Master with over 12 years of experience working with SQL Server. She started her career as a consultant for Digital Equipment Corporation, and just prior to her time at Microsoft, spent 3 years as the primary SQL Server DBA and ASP.NET developer with a small startup company in Manhattan. Pam's background as a .NET application developer and database administrator gives her a broad range of experience which she is passionate about sharing with customers in the field through reactive troubleshooting, proactive services and teaching workshops.