Premier Sponsors
 
http://www.sqlpass.org 
 
http://www.crescentsolutions.net 
 
http://www.pyramidinc.com/ 
 
http://reduxio.com/ 
 
http://kubisys.com/ 
 
http://www.infragistics.com/ 
 
http://oreilly.com/ 
 
http://pyramidanalytics.com/ 
 
http://www.sqlpower.com/ 
 
http://www.idera.com/ 
 
http://www.telerik.com/ 
 
http://pluralsight.com/training 
 
SQL PASS Community News: View
Download the latest ebook from Microsoft Press: Data Science with Microsoft SQL Server 2016
Los Angeles SQL Server Professionals Group Presents ....
Thursday, July 20, 2017
Part 1: Introduction to SQL Server on Linux (30 mins)
Part 2: Understanding Parameter Sniffing (1 hour)
Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.
Speaker: Benjamin Nevarez
Benjamin Nevarez is a database professional based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of three books, "High Performance SQL Server", "SQL Server 2014 Query Tuning & Optimization" and "Inside the SQL Server Query Optimizer" and has also coauthored other books including "SQL Server 2012 Internals". Benjamin has also been a speaker at many SQL Server conferences and events around the world including the PASS Summit, SQL Server Connections and SQLBits. His blog can be found at http://www.benjaminnevarez.com and he can also be reached on twitter at @BenjaminNevarez.
6:30 PM, Registration and Refreshments
7:00 PM to 9:00 PM, Presentations
Our New Meeting Location:
Microsoft Store at Westfield Century City
10250 Santa Monica Blvd. Space #1045
Los Angeles, CA 90067
This meeting is generously sponsored by:
Pyramid Technology Solutions, Inc.
http://www.pyramidinc.com
Pyramid Technology Solutions, Inc. (PTS) is a global IT Services provider of innovative technology solutions, support services and outsourcing services. We began our operations in 1998 with a customer-centric approach and built our core competencies based on our customer experiences in each Industry. Our Industry areas of focus include; Insurance, Healthcare, Pharmaceutical, Supply Chain/Manufacturing and Government (State, County, City).
FREE Parking: Please park anywhere on the lot or on the first floor (valet) area of the structure.
If you park in the parking structure, please take the elevator up to the lobby then to the 2nd floor.

FREE Admission