Manchester SQL Server User Group

Manchester (UK) SQL Server User Group

Network, learn, ask a question, meet fellow SQL Server Professionals and have some pizza - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience. Remember to tell your friends and the people you work with.

For details of all up and coming meetings and to register for events, please see our Eventbrite page here  https://manssug.eventbrite.co.uk

Follow us on  Twitter manssug or Facebook Manchester User Group

Next Meeting: Wed, Feb 11 2015

Manchester PASS Chapter

Register Here : None

Network, learn, ask a question, meet other folk, get fed - these are all things that happen at user group events. These events are a really great opportunity to socialise in an informal learning experience - if you want your own exposure then come and do a 1 - 5 minute nugget in front of your peers.



Remember to tell your friends and the people you work with; make sure you register as soon as you can.



17.30 – 18:00 Registration and networking

Meet and greet.



18:00 – 18:30 Round Table discussion and Nuggets - ALL


Take stock and get the latest news in the SQL Server field. This is also a great opportunity to ask any burning questions you have, may be a problem at work.



It's also a great opportunity to share your knowledge and gain exposure in the industry by giving a short 1 - 6 minute "nugget" demo/tip



18:30 - 19:30 Kimberly L. Tripp. Stored Procedure Optimization Techniques

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).

KIMBERLY L. TRIPP

SQLskills.com

President/Founder

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.



Email:
 Kimberly@SQLskills.com 

Website:
 http://www.SQLskills.com 

Full Bio: http://www.sqlskills.com/about/kimberly-l-tripp/

Blog:
 http://www.SQLskills.com/blogs/Kimberly 

Twitter:
 http://twitter.com/KimberlyLTripp 

SQL Server
 MVP since 2002





19:30 – 20:00 BREAK

Light refreshments



20:00 – 21:00 Session Two - TBC



21:00 - Close and down the pub

Featured Presentation

Stored Procedure Optimization Techniques

Speaker: Kimberly Tripp, Founder/President/Owner SQLskills.com

Summary: 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).

About Kimberly: Kimberly L. Tripp is the founder/co-owner (with her husband, Paul Randal) of SQLskills.com, a world-renowned training and consulting company. She worked for Microsoft University and on the SQL Server team in the early 1990s but left to consult in 1995. Since then, she has been training, consulting, and speaking on a number of SQL Server areas with performance tuning, VLDBs, and optimization her most common topics. Kimberly is an accomplished writer and presenter with numerous top-speaker awards over the years; she is also a SQL Server MVP. You can read more at SQLskills.com. In her free time, and with her husband, Paul Randal, she likes diving, searching for critters, and underwater photography!

Attachments

PASSChapterLogo.jpg

sql_micro_sm.gif

 rg-logo.png

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids