Just a quick reminder that I’ll be speaking at the Richmond Code Camp this upcoming weekend. I’ll be giving two talks… here they are:
Indexes and Other Free Performance Boosts
Time & Location
October 4, 2009 at Richmond Code Camp.
Abstract
The database is often viewed as a major performance bottleneck. There are a number of quick, easy, painless techniques that can increase the performance of an application not just by a small amount, but by orders of magnitude. These techniques includes simple indexing techniques, T-SQL techniques, and general database application design patterns that give great gains in performance. In this session, you will learn how to look at a database to identify these problem areas and how to resolve common issues that you will encounter.
From Tables to Objects: Making Your Database Work With You
Time & Location
October 4, 2009 at Richmond Code Camp.
Abstract
A database is far more than a persistent object store for your application; it is capable of data validation en masse, aggregations, and creating different projections of data. By working with your database, rather than against it, it is possible to leverage all of the capabilities of a relational database to provide rich, high performance interaction with your application through an ORM. This presentation will discuss the finer points of building a full-featured data access layer using an ORM and the features of a relational database.
Goals
- Teach attendees about database features that make development easier – including views, sparsely populated tables, and user-defined functions and types.
- Empower the audience to solve object relational impedance mismatch using data modeling techniques and database features.
- Demonstrate how to integrate the database and object oriented software using a custom designed data access layer.
