I passed the MySQL 5.0 DBA I and II certification tests today with very nice results. Just figured I’d post that so it’s verifiable that I’m not entirely spewing nonsense and general rabble. Today is a good day, and I will celebrate with the finest wines, and choicest of meats.

Exam Date: Monday, January 28, 2008 at 9:00 AM
Candidate: Matthew Reid
Candidate ID: MYSQL005372
Registration #: xxxxx2740
Exam Series: 005-002
Exam: Certified MySQL 5.0 DBA Part I
Validation #: xxxxx5662
Grade: pass

Exam Date: Monday, January 28, 2008 at 10:30 AM
Candidate: Matthew Reid
Candidate ID: MYSQL005372
Registration #: xxxxx7164
Exam Series: 006-002
Exam: Certified MySQL 5.0 DBA Part II
Validation #: xxxxxx5956
Grade: pass

Just a few hours ago, Fotolog crossed the 400,000,000 photos milestone. Considering that free members can only upload one photo a day, that's a lot of dedication by 14.5 million members (and growing).

What they need the most in the short term is someone who could do customer support between 3am and 11am, London time, so someone in Australia would be perfect

Do you happen to know anyone who might be interested in the job?

Ideally it would be someone who’s familiar with web technologies (web, DNS, e-mail servers), linux and maybe some web frameworks (Django, Rails,. ..).

The candidate would be doing customer support (answering tickets) but if they’re interested they could also do sysadmin work or even development work.

see the webfaction job page for more details

Great news! Monty released Maria, the new transactional storage engine for MySQL. This is fantastic news! I can't wait to try it out. I remember when it was in the planning stage. Now it's here!

http://monty-says.blogspot.com/2008/01/maria-engine-is-released.html

First saw this off of Planet MySQL:

 New Vendor Neutral Database Certification (Dave's Stuff)

Following the link to the CIW site, there are six domains that are being tested:

1. Relational Database Fundamentals
2. Relational Database Design and Application
3. Normalization and Database Design
4. Structured Query Language (SQL)
   
5. Relational Algebra and Databases
6. Transactions, Concurrency Control and Security

I wonder how much traction this independent certification will get, given the flavors each of the various database platforms use of SQL and …

A friend asked for this, so I thought it’d be helpful: All tables with no primary key:

use INFORMATION_SCHEMA; select CONCAT(t.table_name,".",t.table_schema) as tbl, from TABLES AS t LEFT JOIN KEY_COLUMN_USAGE AS c ON (t.TABLE_NAME=c.TABLE_NAME AND c.CONSTRAINT_SCHEMA=t.TABLE_SCHEMA AND constraint_name='PRIMARY') WHERE t.table_schema!="information_schema" AND constraint_name IS NULL;

All tables and their primary keys, if exist:

use INFORMATION_SCHEMA; select CONCAT(t.table_name,".",t.table_schema) as tbl, c.column_name,c.constraint_name from TABLES AS t LEFT JOIN [...]

Lefred pointed us to O'Reilly Maker

This one really is my preferred one

It's sad, but so true.

This Nokia rant makes me wonder where the Mac version is.

Didn't Scott Adams already write this one ?

That's Wally right ? :)

And even the IT Crowd also has it's own manual already.

Dave wrote about new vendor neutral database certification, or as I like to call it "Jack-of-all-trades-but-master-of-none certification "

This post is mostly off topic, but I do no know there are quite a few runners in the open source world. We have a modest-sized running club at MySQL with many marathoners, and there's also guys like Marc Fleury, Matt Asay who have also run marathons. (The SugarCRM guys seem to be avid cyclists, and once in a while I ride with them in the hills around Cupertino, but for me it's not the same thrill as running a marathon. Call me weird.) At any rate, I went to see the movie "Spirit of the Marathon" the other night.... READ MORE

This is all my personal rant based on my little investigation as I have been very upset.

If you're the one who I am targeting this post to: please don't take it personally. You have no one but yourself to blame for this backlash.

==start rant==
So, Looking at the sites of one-who-shall-not-be-named-or-linked-to-any-more or aka wolf in sheep's clothing, I am coming to an opinion. To me, it seems like he is basically using his sites to benefit his current and/or future clients. He also seems to be a DMOZ editor or very closely associate with it, something that really hurts his credibility in my eyes. DMoz should be shredded by now as it has absolutely no value other than to lame SEOs who still either beg editors to get their site listed or enjoy being begged to. Even the parent company of DMoz has no interest in it. I mean come on. If you are 1% serious in your "database research" business you wouldn't spend time …