At the January 2009 Boston User Group I presented a session on the new partitioning feature in MySQL 5.1. I go through how to define partitions, how partitioning makes queries faster, the different types of partitioning and when to use each type, and the restrictions and limitations of partitioning.
Dr. Richard Hipp, creator of SQLite, presents "How SQL Database Engines Work" at OpenSQLCamp 2008.
To many programmers, SQL RDBMSes are a magical black box. A talk can help clear up a lot of the mystery. SQL users tend to make better use of the language once they have a rough idea of what is going on beneath the covers.
Database scale-out architectures promise tremendous capacity increases simply by adding hardware. There are, however, significant differences depending on the scale-out approach you choose. This talk presents a new set of open source benchmarking tools called Bristlecone (http://bristlecone.continuent.org) that allow any user with access to Java to set up and start to run performance benchmarks in a few minutes.