March .NET and SQL Server User Group (Tech Park Edition)

The Baton Rouge User Groups are excited to welcome everyone back to our first IN-PERSON meeting since the start of the pandemic!

Location: Louisiana Tech Park

Agenda:
• 5:15 - 5:30: Introduction/Food and Drinks (Note our earlier start time!!)
• 5:30 - 7:15: Presentations
• 7:30 - Until: Open forum for questions

Sponsor: TekChix Staffing: https://thetekchix.com/

Presentations:

Using Execution Plans to Performance Tune SQL Server
​
This will be a Beginners session highlighting the starting point for using the execution plans from SQL Server to assist in query tuning. Briefly, we will look at the history to get an idea of how Microsoft has improved the display through Graphical Plans and Missing Index suggestion. What is the difference between a Table and Clustered Index Scan? What is a Lookup? How do you improve performance of Lookups? What are the different types of Loops? How to get more information from the Plan with the properties window? We might even look at the Query Store.
​

Presenters:

Thomas LeBlanc is a Data Warehouse and Business Intelligence Architect in Baton Rouge, LA and uses his decades of experience in IT to help develop OLAP database for end-to-end dimensional data marts with SSIS, SSAS, Power BI, and Excel. He also assists with OLTP systems designing and tuning normalized databases for high-performing T-SQL.

Our sponsor for this meeting is TekChix Staffing