On July 7th, David Berry will step out of our purely .NET traditional talks with a great follow-up to last month’s talk on Entity Framework. David’s going to help you work through your performance challenges, with everything application developers need to know about SQL / database performance. Let’s keep our great attendance going through the summer as we welcome David to our podium for the first (though not his first) time.
Topic: Database Performance for Application Developers
Just about every significant application in use today uses a database for backend storage, yet database performance tuning remains a black box for many developers. In this presentation, we’ll cover the essentials you need to know from a developers perspective of how to understand what you database is doing, what makes a SQL statement run fast or slow and how to fix common performance issues. Topics will include:
- How to read and understand an execution plan
- How to use SQL Servers Dynamic Management Views (DMV’s) to find your worst performing statements
- How to create database indexes that are efficient and actually get used
- How to use SQL Server’s Profiler utility to capture activity in the database
- How to recognize and avoid common performance pitfalls that occur in application development
David Berry is an Application Team Lead with United Fire Group with over 15 years of application development experience. After starting as a Java developer, he switched to Microsoft .NET in 2003 and has used every version of .NET since 1.0. He also has extensive experience working with both Microsoft SQL Server and Oracle. He has provided technical leadership on projects in a broad range of industries including insurance, financial services, government and manufacturing. David is a Pluralsight author and has published articles on Reg Gate’s simple-talk.com website.
If you plan on attending our meeting on July 7th, please RSVP.