Conferences

Video: Starring Sakila: Data Warehousing Explained, Illustrated, and Subtitled

The video for the 2009 MySQL Conference presentation:

Starring Sakila: Data Warehousing Explained, Illustrated, and Subtitled
Roland Bouman (XCDSQL Solutions / Strukton Rail), Matt Casters (Pentaho Corp.)

Official description

Slides are at http://forge.mysql.com/wiki/Starring_Sakila_-_A_Data_Warehouse_Mini-Tutorial

Video: Using the Event Scheduler

Video for the presentation at the 2009 MySQL Conference:

Using the Event Scheduler: The Friendly Behind-the-Scenes Helper
Giuseppe Maxia (Sun Microsystems Inc), Andrey Hristov (SUN Microsystems)

The official conference page is at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7115

Download the PDF slides

Video: Understanding How MySQL Works by Understanding Metadata, part 2

Part 2 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.

The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.

From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:

We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.

Video: Understanding How MySQL Works by Understanding Metadata, part 1

Part 1 of "Understanding How MySQL Works by Understanding Metadata", presented by Sheeri K. Cabral (The Pythian Group) and Patrick Galbraith (Lycos Inc.). This was a 3-hour tutorial.

The PDF of the slides can be found at http://technocation.org/files/doc/2009_04_Understanding.pdf.

From the official abstract at http://www.mysqlconf.com/mysql2009/public/schedule/detail/5682:

We have spent countless hours researching over 1,000 pieces of metadata. In the process, we have learned a lot about how MySQL works, and realized that it was a pretty good learning method.

Video: What the MySQL Is This, Anyway?

Giuseppe Maxia and I are in the exact middle of our leg of the MySQL Campus Tour. Yesterday's session is was recorded -- A PDF of the slides can be downloaded at http://technocation.org/files/doc/2009_04_Tour.pdf (21 Mb).

The video is below:

OpenSQLCamp Video: How SQL Database Engines Work

Dr. Richard Hipp, creator of SQLite, presents "How SQL Database Engines Work" at OpenSQLCamp 2008.

The description:
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.

http://www.yo

Moving Application Logic Into the Database by Bruce Momjian

Bruce Momjian talks about general strategies for moving application logic into databases, mostly why to do it and why to not do it. This talk is mostly DB agnostic. Note that the slides have a title of "Processing Data Inside PostgreSQL". The slides can be found at http://www.slideshare.net/EnterpriseDB/data-processing-inside-postgresql.

How to Stop Hating MySQL

At LISA 2008, I gave a presentation entitled "How to Stop Hating MySQL: Fixing Common Mistakes and Myths".

The presentation slides can be downloaded as a PDF at:

http://technocation.org/files/doc/stophatingmysql.pdf

View the video online at http://www.youtube.com/watch?v=DylLYQlzuKo (or watch it at the bottom of this page).

Here are some notes and links I referred to:

Technocation, Inc containing free videos, a MySQL podcast (currently on hiatus) and blog posts about MySQL.

The State of Open Source Databases: OpenSQL Camp Keynote Featuring Brian Aker

Brian Aker delivers the keynote speech at OpenSQL Camp: State of the Open Source Databases.

The presentation begins with:
"There is no way I'm going to tell you exactly where the future of databases go. We have way too many egos in the room to ever even begin a discussion..."

and ends with Aker saying,
"What the hell does that mean?"

My summary: open source databases are already ubiquitous, we need to make them better/faster/consume fewer resources.

Brian's summary: What part of my keynote surprised people? How ubiquitous bot nets are, and how they act as a big decentralized data store.

Load Testing Using Perl

Homer Hummel of the Computer Sciences Corporation gives a presentation on Load Testing Using Perl. A must-view!

Stream directly online at http://technocation.org/node/615/play or download the 247 Mb .wmv file at http://technocation.org/node/615/download.

Pages


Fatal error: Class 'CToolsCssCache' not found in /home/sheeri/technocation/includes/cache.inc on line 32