Paul Randal has recently proposed that SQLSkills could give sessions on the user groups meetings. I emailed him immediately and – making the long story short – the PLSSUG (Polish SQL Server Users Group) will be hosting Kimberly Tripp on 29 th January at 6PM local time. Please visit the community webpage
Here are some details:
Stored Procedure Optimization
Presenter: Kimberly L. Tripp
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.
I hope that this is great news.
And I promise – this will not be the only meeting :).
More details will follow on the community webpage (as well as information how to participate in that meeting) – http://plssug.org.pl/