I’ve been offline (mostly) for the past week while at Tracker School and over the next few days I’ll be catching up on what happened while I was out. You guys were busy. As I pulled into my garage after a long drive this song came on shuffle and I wanted to share it with you guys — Nina Simone’s Feeling Good:

Last month at the Boston MySQL User Group, I went through the meanings of INNER, LEFT/RIGHT OUTER, CROSS, NATURAL joins, how to do a FULL OUTER JOIN in MySQL, and what STRAIGHT_JOIN means. I also explained how to recognize when you want those types of joins, and best practices for the semantics of writing joins and design patterns. Subqueries were explained in this session, and some examples of how to think differently so that you end up writing JOINs instead of subqueries. The slides (slightly different from the slides in the video — due to error correction) can be found at http://technocation.org/files/doc/2010_01MySQLJoins.pdf.

Here’s the video:

Another video from the recent OpenSQLCamp in Portland, Oregon….Earlier today I uploaded the Lightning Talk Videos. Due to the holiday I am unsure when the rest of the videos will be ready. When they are, I will do one blog post featuring them all.

However, I have had several requests for this specific video, so here is Brian Aker speaking about Drizzle.

The slides are up at http://www.slideshare.net/brianaker/drizzle-opensql-camp, and here’s the video:

(Note, I will not do a post for each video…..but since this one is up and ready, I figured I’d do it before I leave for the holiday).

OpenSQLCamp was a huge success! Not many folks have blogged about what they learned there….if you missed it, all is not lost. We did take videos of most of the sessions (we only had 3 video cameras, and 4 rooms, and 2 sessions were not recorded).

All the videos have been processed, and I am working on uploading them to YouTube and filling in details for the video descriptions. Not all the videos are up right now….right now all the lightning talks are up.

• 
  
• All the lightning talks belowin one continuous video (just over 54 minutes total)
  
• The Graph Engine (Antony Curtis)
  
• …

Last night at the Boston MySQL User Group I presented on how to get a consistent snapshot to build a slave, how to use mk-table-checksum to check for differences between masters and slaves on an ongoing basis, and how to use tools such as mk-table-sync and mysqldump to sync the data if there are any discrepancies.

The slides are online at http://technocation.org/files/doc/slave_sync.pdf.

The video can be watched on youtube at http://www.youtube.com/watch?v=Un0wqYKmbWY or directly in your browser with the embedded player below:

The attendees were not satisfied with the first answer RMS gave to Brian, that Harish Pillay (Chief Technical Architect, Red Hat Singapore), chose to ask RMS what more he had to say, with regards to the letter he’d written. He answered quite candidly in this video, which Brian chimed in for as well.

The back channel for all this was Twitter… Don’t hesitate to follow @harishpillay, @brianaker, @piawaugh or even @webmink …

At foss.my 2009, Brian Aker asked Richard Stallman at his keynote, about the Oracle/Sun acquisition (with a focus on MySQL), with regards to the parallel licensing approach used by MySQL. Brian was referring to:

As only the original rights holder can sell commercial licenses, no new forked version of the code will have the ability to practice the parallel licensing approach, and will not easily generate the resources to support continued development of the MySQL platform.

from Richard’s Letter to the EC opposing Oracle’s acquisition of MySQL. Listen to the discussion between Brian and Richard.

…

One of my all-time favorite services, Animoto, has teamed up with SmugMug to make truly epic professional quality videos from both your stills and your video clips.  I’ve wanted this partnership since 2007, but Animoto’s had their hands full dealing with explosive growth, so it took us a little longer to sit in that tree together than we thought.

We had my good friend, Robert Scoble, over last night to demo for him, and you can see the video below (or click here to view it on blip.tv):

The really great thing about this is that it’s totally full-circle and tightly integrated.  Find your favorite photos on SmugMug, send them over to Animoto right from SmugMug’s interface (look in the ‘Buy’ …

Wow, Pulitzer-Prize winning photographer Vincent Laforet has done it again! This time with Canon’s brand-new 1D Mark IV and a film shot at ISO6400. And SmugMug’s got it in all it’s full 1080p hi-def glory, of course.

UPDATE: Canon, whom I love, has requested that Vincent take the video down.  As a courtesy to both Vincent and Canon, we have done so, but hope to put it back up again as soon as they give us the green light.  Read more about it over on Vincent’s blog.  Sorry for the inconvenience.

Related posts:

• Amazing Canon 5D MkII HD video footage! …

http://blog.envylabs.com/2009/08/5-days-of-oscon-day-2/

I'm at 5:13