OC SQL Data Platform

Welcome

Orange County Data Platform Community

We have found a NEW HOME!  Again!
Special thanks goes to Michellea David for hosting us at her new building at 220 Commerce in Irvine, CA.

  • 6:30 > Networking and pizza
  • 7:00 > Presentations
  • 8:30 > Drinks at a nearby watering hole for additional networking and shop talk

Mechanics Bank
220 Commerce
Irvine, CA 92602

Do you have any events to share? If you do, send them to Ted Stathakis.

 


 



Next Meeting

Wednesday,

September

19

Monthly Meeting

  • In-Person @ 6256 Greenwich Dr. San Diego, California, United States (map)
  • 18:30 - 20:30 Pacific Daylight Time
  • Language: English

Kevin Kline will be presenting Query Tuning Surprises for the Advanced SQL Developer in person at our new meeting space in Irvine!  There will be pizza and beverages with drinks at a nearby watering hole afterwards.

Featured Presentation:

Query Tuning Surprises for the Advanced SQL Developer

Kevin Kline, Principal Program Manager SentryOne

Skilled SQL developers know that the SQL Server query optimizer uses a multi-step process to produce execution plans. But what about deeper components like the parser, the binder, the algebrizer, as well as the optimizer itself? This session will teach you advanced techniques for query tuning as well as surprising behaviors of the query optimization process that can have a dramatic impact on performance, with special attention paid to the processes controlled by the algebrizer, including associative, commutative, and transitive transformations. We will examine a variety of everyday queries whose performance can be greatly improved by apply a deeper understanding of these internal behaviors. Lots of examples and demos! • Goal 1: Learn advanced and undocumented methods to see the steps of parsing, binding, algebrizing, and query optimization. • Goal 2: Explore the SQL Server internal memo structure to see how SQL Server uses the heuristics of the algebrizer and query optimizer. • Goal 3: Walk through several examples of SQL queries whose behavior can be greatly improved when you apply what you’ve learned about the algebrizer and query optimizer. Prerequisites: Attendees must know how to write and tune SQL queries, as well as how to read execution plans. Summary: Learn the hidden internals of query processing and apply those lessons in your SQL applications, diving deep into the algebrizer and optimizer. Level: 300 - 400

About Kevin:
Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends & Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.

We are always looking for speakers to present at our monthly meetings.  We are sure you have done some really cool stuff in your role and would like to hear from friends in the trenches.  It's not hard and there are many of us happy to coach you.

 

PASSChapterLogo.jpg


Sponsors



 

sql_micro_sm.gif

 

 

 

 

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