Sacramento SQL Server User Group

Next Meeting

Tuesday,

September

11

September 11: Query Tuning Internals for the Advanced SQL Developer - Kevin Kline

  • Patrick Hays Learning Center (map)
  • 2700 Gateway Oaks Drive, Suite 2600
  • Sacramento, CA 95833
  • 6:00 PM to 8:00 PM
  • RSVP via Meetup

September 11: Query Tuning Internals for the Advanced SQL Developer - Kevin Kline
Sacramento SQL Server User Group
September 11, 2018, 6PM - 8PM

For September, we've got special guest speaker Kevin Kline!  Note the non-standard date for this meeting -- second Tuesday instead of first Wednesday of the month!

RSVP on Meetup!
https://www.meetup.com/Sacramento-SQL-Server-User-Group/events/253814270/

Learn the hidden internals of query processing and apply those lessons in your SQL applications, diving deep into the algebrizer and optimizer.

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.

Experience in writing and tuning SQL queries, as well as reading execution plans, will be beneficial to attendees of this 300-400 level session.

Kevin Kline is a database expert and Principal Program Manager at SentryOne. 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".  He contributes monthly to Database Trends & Applications magazine. He tweets at @kekline and blogs at https://blogs.sentryone.com/author/KevinKline/.

Sponsors:
TEKsystems
http://www.teksystems.com
SentryOne
http://www.sentryone.com

Sacramento SQL Server User Group
https://www.meetup.com/Sacramento-SQL-Server-User-Group
http://sac.pass.org
https://twitter.com/sacsqlug
https://www.linkedin.com/groups/2825448

Meeting Schedule and Structure

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most meetings will have a presentation, while others are open group sessions which allow attendees to discuss SQL Server questions, issues and news as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions

Our Sponsors

PASSChapterLogo100.jpg

 

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