Quad Cities PASS Chapter

Welcome to the Quad Cities PASS User Group (QCPASS)

QCPASS is a SQL Server User Group in the Quad Cities area (Davenport & Bettendorf, IA and Rock Island & Moline, IL and the surrounding area).  We meet monthly, typically on the 2nd Wednesday of the month.  Meetings are always FREE and food will typically be provided.  Please come be a part of our local community! 

Time:           5:30 PM   Dinner
                  6:00 PM   Meeting
 
Location:     Please note location on each meeting below.
 

If you would like to be on our email list, please join our chapter by registering for a free PASS membership at http://www.pass.org and adding our chapter to your myChapters page.  Please also check back here at the website for details!

Speakers and sponsors please contact us from our "About Us" page.

Meetings

 
 

 

Wednesday, October 9, 2019 - On Site Speaker

Location:  Twin State Technical Services
                   3541 E Kimberly Road
                   Davenport, IA  52807
 

Kevin Kline

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at SentryOne. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.

Query Tuning Internals for the Advanced SQL Developer

Level: 300-400

Abstract: 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.   

Thank you to our sponsor!

                                

Click to RSVP


 

 

Announcements

 



 


EventDisplay

Sorry, there are no upcoming meetings. Please check back for updates.

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 













 












  

Curative Computers LLC

 


 

 

 

 

 


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