One of the most well-known personalities in the SQL Server world, Kimberly L. Tripp, is going to be our guest during all-PLSSUG online meeting. This event will happen on January 29th, 2015 and we will use Microsoft Lync or similar software to host it (more details to come).
Subject: Stored Procedure Optimization Techniques
Abstract: Kimberly will discuss stored procedure caching and the potential for performance problems due to a problem known as parameter sniffing. There are some common solutions and while they can drastically improve performance, they can also cause other problems. Sometimes a hybrid solution is needs, from this session, you’ll know the best way to write procedures so that stable requests are cached and unstable requests are not (giving you the most optimal performance without wasting resources).
Bio: Kimberly L. Tripp, President / Founder, SQLskills.com
Kimberly has been a Microsoft SQL Server MVP and a Microsoft Regional Director for over 10 years; she’s an author, consultant, and top-rated speaker having spoken at PASS, TechEd, SQLintersection, and numerous other events around the world. She has over 20 years of experience designing and tuning SQL Server solutions with a focus on optimizing procedural code, indexing strategies, statistics, and partitioning. When she’s not tuning SQL servers, she’s diving and photographing all sorts of underwater critters such as frogfish with her husband, Paul S. Randal.
//EDIT by Leszek : This meeting is going to be virtual, but PLSSUG Warsaw will meet on PLSSUG Extra Meeting in Microsoft Poland HQ (http://www.meetup.com/PLSSUG/events/219019054/).
// EDIT2 by Leszek : Other Cities will also join this online meeting. Cracow, Lodz, Wroclaw will have a meeting in regular places.