Association of Information Technology Professionals, Appleton Chapter

On Wednesday, November 16th, I gave an hour long presentation to the the Appleton area chapter of the Association of Information Technology Professionals. The slides from the presentation are attached below

Essential Database Performance for IT Professionals

Twin Cities Code Camp

I am presenting at Twin Cities Code Camp on October 8, 2011 in Minneapolis, MN. The presentation is similar to the one Paul and I did for Fox Valley .NET User's Group a few months ago, save that there will be just one monotone voice this time rather than two. The talk is entitled "Essential Database Performance for Developers". A link to the slides is below.

Slides for Twin Cities Code Camp

Fox Valley .NET User's Group

These are the slides we will be presenting at the Fox Valley .NET User's Group on August 10, 2011.

Performance Tuning SQL Server for Developers

Performance Tuning Oracle for Developers - Summary Sheet

While our presentation mostly focuses on SQL Server, many of the concepts are applicable to all databases. In addition, we realize many developers work in an Oracle environment or a mixed environment. Therefore, we have created a version of our summary sheet for Oracle. This sheet mirrors much of the information in the SQL Server summary sheet, but adapted for use in Oracle.

Performance Tuning Oracle for Developers - Summary Sheet

Performance Tuning SQL Server for Developers Summary Sheet

This summary sheet summarizes some of the most important database performance tuning concepts for SQL Server developers. It contains all of the DMV queries that we show during our presentation plus a few additional ones. Feel free to distribute a copy of the PDF to your teammates at work.

Performance Tuning SQL Server For Developers - Summary Sheet

Welcome to Effective Database Design

Greetings,

This blog is being created by David Berry and Paul Beilke in support of the August 2011 presentation to the Fox Valley .NET users's group on maximizing database performance for developers. We'll be posting the slides for the presentation as well as our handouts on this site as the data of the presentation draws closer.

In addition, we may post other useful information on database design, data access layers and performance tuning as we come across it.