When: Wednesday, 06/12/2019
Agenda:
• 5:30 - 5:45: Introduction/Food and Drinks <-- Note our earlier start time!
• 5:45 - 7:30: Presentations
• 7:30 - Until: Open forum for questions
Location: Louisiana Technology Park- location info here
Main Presentation:
Execution Plans in SQL Server 2017
After our Modern
Migration Tour special event at 3pm (see below!) stay for more SQL Server
insights! Performance Tuning starts with looking at a plan SQL Server
internally uses to execute T-SQL. There are many parts to the plan as well as
additional options for performance tuning. This session will provide real-world
examples of T-SQL that can cause execution plans to not be optimal. The plan
might also expose additions in the form of new indexes that can be added to
improve performance. There are many paths to reading these plans that need to
be discussed and probably you will hear 'it depends' in this session.
Explanations of why it depends will be used with examples. Plus a look at Query
Store in 2017.
Main Speaker: Thomas LeBlanc
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data
Warehouse Architect in Baton Rouge, and uses his 30+ years in IT to develop
OLTP systems with normalized databases for high-performing T-SQL and
dimensional data marts. Development is done in SSIS, SSAS, SSRS, Power BI, and
Excel. As a PASS volunteer, he is past chair of Excel BI and Data Arch VCs and
is active in the Baton Rouge Analytics and SQL Server User groups as well as SQLSaturday
in Baton Rouge. Blog - TheSmilingDBA.BlogSpot.com and Thomas-LeBlanc.com