Disclaimer:
I have the unfortunate luck of being hired on the same date that Tom Kyte started his blog. Honestly, I've been working on this a couple days so I'm posting it anyway, even if you think I am a copycat.

Six years ago today I started with my current company. This is the longest I've ever had the same title, although my responsibilities have changed over the years. It's also the most time I've spent at the same place.

It was the tail end of the dotCom boom and I had over 40 interviews with companies in the Tri-State area. Most of them didn't pan out, but when it came time to choose, I had three offers to consider. When I accepted this job, I took a chance because I liked the people but didn't think they had enough for me to do. I was the sole DBA for one production database that ran on an Ultra 2 (2 CPUs, 54G of …

Have you ever wondered how to update the status of an order to "Closed" when the whole ordered quantity has been received?
If you are on a database that supports triggers like me (I'm on MySQL 5.0.16 right now) you can have something like:

Table structure:

Orders table

1. DROP TABLE IF EXISTS `test`.`orders`;
2. CREATE TABLE `test`.`orders` (
3. `order_id` int( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT,
4. `order_date` datetime DEFAULT NULL,
5. `order_status` CHAR ( 1 ) NOT NULL DEFAULT '',
6. PRIMARY KEY ( `order_id` )
7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Order lines table

1. DROP TABLE IF EXISTS `test`.`order_lines`;
2. CREATE TABLE `test`.`order_lines` (
3. `order_id` int( 10 ) UNSIGNED NOT NULL DEFAULT '0',
…

Whow, seems like next couple of weeks will be extermely busy when looking at conferences, In the next couple of weeks there is the MySQL User Conference, Fisl is about to start and I`m going to miss all of them , them being at the other side of the ocean. I`m making my travel arrangements for LinuxTag where I`ll be helping out in the Grid and Virtualisiation track however. Not sure about my plans for the rest of the year.

Not going to all these conferences means that I`ll have lots more time to get some stuff done, such as upgrading some of my test platforms to a more recent CentOS version so that I don't have to build the MySQL Cluster binaries myselve but just use the ones provides by MySQL :)

As the weather plans on staying bad I`m also planning on more …

Here‘s a snapshot of my view out the office window…Yes, it‘s starting to look like springtime here in Chicago.

That also means it‘s that time of year where I start travelling for conferences. This year is shaping up to be light so far, but of course I will be at the MySQL Users' Conference next week in Santa Clara, CA.

Besides giving a tutorial, and two talks, I'm also looking forward to being part of the Java and MySQL community, hanging out at Gavin's talk about Hibernate and Seam, and participating in the …

Here's a snapshot of my view out the office window...Yes, it's starting to look like springtime here in Chicago.

That also means it's that time of year where I start travelling for conferences. This year is shaping up to be light so far, but of course I will be at the MySQL Users' Conference next week in Santa Clara, CA.

Besides giving a tutorial, and two talks, I'm also looking forward to being part of the Java and MySQL community, hanging out at Gavin's talk about Hibernate and Seam, and participating in the …

Here‘s a snapshot of my view out the office window…Yes, it‘s starting to look like springtime here in Chicago.

That also means it‘s that time of year where I start travelling for conferences. This year is shaping up to be light so far, but of course I will be at the MySQL Users' Conference next week in Santa Clara, CA.

Besides giving a tutorial, and two talks, I'm also looking forward to being part of the Java and MySQL community, hanging out at Gavin's talk about Hibernate and Seam, and participating in the …

Just in case the HypnoToad did not convince you to attend my sessions at next weeks’s conference, I’ll up the ante.

Thanks to Apress and O’Reilly I’ll be giving away several MySQL related books at each session.

There, now you have to come. And of course watch this space for session notes.

This morning I read some reports on the reaction to Sun's recent discussion on open source DRM.  The reaction from the Stallmanites was not surprisingly negative.  From what I gather, no DRM is the only solution that would be acceptable however this has left me somewhat confused.  Perhaps someone could leave me a comment and help me understand how this is supposed to work.

Here's what I've got so far.  Stallman cites four basic freedoms.  The freedoms to run the program you wish, to change said program, to distribute said program, and to distribute said changes.  These freedoms fit neatly into a software world but are being applied to the digial media and DRM argument.

Apparently, according to Stallman, I should have the right, as the consumer, to share with all my friends the music and movies I am listening to or watching.  This sounds like a great deal.  No more heading down to the music …

ZDNet (via slashdot) is running an article about MySQL and Solid working together to bring solidDB storage engine to MySQL in June. There's an announcement linked from the Solid homepage and a letter from the CEO in PDF format. I don't see anything at MySQL.com, but the announcement from Solid seems to indicate that details will be unveilded next week at the MySQL Users …