MemPASS / Power BI Meetup: SQL Server Performance Tuning 101 for Developers

This is a past event

21 people went

Every 2nd Thursday of the month

FedEx Institute of Technology(FIT)

365 Innovation Dr · Memphis, TN

How to find us

Please join us in Room 225. Note: the parking garage is $3/hr. Street parking is free. Food (provided by SolidQ, https://www.solidq.com/ ) and networking at 5:30

Location image of event venue

Details

PLEASE NOTE: The August meeting is being held on the third Thursday, 8/15 instead of the second Thursday, 8/8.

SQL Server Performance Tuning 101 for Developers

Abstract:

In enterprise environments, SQL Server is ever-present and resources are finite. Whether deployed on-premises or through one of the many Azure offerings, knowing how to tune and optimize queries is crucial towards effectively using the platform. We’ll cover the basics of execution plans, indexing, T-SQL anti-patterns and best practices. Attendees will gain the fundamental knowledge needed to understand and minimize the impact that their queries have in production and will leave armed with resources to further maximize the performance of their SQL Server backed applications.

Speaker:

David Hiltenbrand is a Database Engineer working in the Microsoft Data Platform over the last 7+ years. He lives in Memphis, TN and helps Green Mountain Technology manage and scale their SQL Server solutions for the high-volume parcel industry. He is heavily involved in the PASS community where he organizes SQLSaturday Memphis and currently serves as President of MemPASS, as well as speaking and volunteering at surrounding SQLSaturday events.