July 7th Meeting Information

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

Speaker Bio:

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.

[customcontact form=1]

This entry was posted in Meetings. Bookmark the permalink.

One Response to July 7th Meeting Information

  1. Greg Sohl says:

    A great presentation by David last night.

    Here is the SQL Server Summary Sheet he referenced: http://buildingbettersoftware.blogspot.com/2014/07/sql-server-summary-sheet-for-tonights.html

    The Red Gate Software eBooks mentioned can be found here: http://www.red-gate.com/community/books/

Leave a Reply

Your email address will not be published. Required fields are marked *