Pages

▼
Thursday, November 30, 2006

The hidden risks of SQL MODE

›
MySQL 5.0 introduces improved SQL modes , which can fine tune the way your server behaves. If you are a long term MySQL user, you may be fam...
2 comments:
Monday, November 13, 2006

MySQL testing techniques: comparing tables

›
This is the first tutorial of a series dedicated to testing techniques. Soon all this material will find a home in a more appropriate place....
5 comments:
Sunday, October 29, 2006

Speaking at the Open Source Database Conference 2006

›
I will be a speaker at the Open Source Database Conference , which is held in Frankfurt from 6 th to 8 th November 2006, parallel to the I...
Thursday, October 19, 2006

Contributing to MySQL QA - Ideas wanted

›
MySQL has recently started a campaign of open contribution , inviting the community to participate to the MySQL project in many ways. The ne...
1 comment:
Tuesday, October 03, 2006

Take the MySQL Certification in five steps

›
I recently took two certification MySQL 5 exams . At that time, I was on vacation, but now that I am back I would like to share with the com...
5 comments:
Monday, October 02, 2006

Are logins before download any good?

›
If you are used to open source products, chances are you have gone through this routine more than once. Search for what you need, find a sui...
Friday, September 29, 2006

Log Buffer #12: a Carnival of the Vanities for DBAs

›
I fell for it. I commented on the Log Buffer and shortly after that I was offered to host an issue. Here we go, then. Welcome to Log Buffer...
1 comment:
Thursday, September 28, 2006

Working in a virtual company

›
A few days in the job for MySQL and still, even though I can't say I have mastered the tasks at hand (too much to get used to!) I tasted...
Monday, September 25, 2006

Riding the Dolphin

›
I have been a consultant for long time. It is an interesting job, which has given me much satisfaction. The coolest part of the job is the i...
4 comments:
Thursday, September 14, 2006

A fruitful vacation - MySQL 5 certification

›
Near the end of a two weeks vacation in southern Italy, I combined pleasure and business and took the 4 to 5 upgrade exams , which I passed,...
1 comment:
Thursday, August 31, 2006

MySQL Sandbox tutorial reprinted by (IN)SECURE magazine

›
The latest issue of (IN)SECURE magazine , a freely available digital security magazine discussing some of the hottest information security t...
Friday, August 11, 2006

MySQL Federated Engine: the missing manual

›
If you have used the MySQL Federated engine, you may share my opinion that it's perhaps the most amazing feature introduced in recent ve...
Monday, July 31, 2006

MySQL Sandbox tutorial translated in Portuguese

›
A while ago I wrote a tutorial on the MySQL Sandbox . Wallace Reis asked me permission to translate it, and I happily agreed. And now ther...
Friday, July 28, 2006

An ugly query should be a warning bell

›
A recent question in a newsgroup was Given this table in MySQL 4.0, how can I run a single query to sort the records by the number of pipes ...
1 comment:
Monday, July 17, 2006

Obscure settings

›
I remember when MySQL was spreading rapidly, mostly due to its ease of use. That was long time ago, apparently. Now we are entering the dark...
Thursday, July 06, 2006

Measuring MySQL resources consumption on Linux

›
If you have ever felt the need of measuring how much of your resources a MySQL process is eating up, you're welcome to share my experie...
Wednesday, July 05, 2006

A first taste of logs on demand

›
From time to time I install MySQL from the development tree, to see what's new, and in the latest one I found a pleasant surprise: Welco...
Tuesday, June 20, 2006

Talking at FrOSCon 2006

›
I will be at FrOSCon 2006 on June 24, with a talk about Pivot tables in MySQL 5 . I will arrive in Sankt Augustin on June 23, flying from A...
Friday, June 02, 2006

Filling test tables quickly

›
Let's say that you are building a new application, and you need to test it against a large set of data. You would need either to borrow ...
3 comments:
Wednesday, May 24, 2006

Tutorial for a more powerful MySQL Sandbox

›
The MySQL Sandbox has been enhanced, with a new express installer, capable of setting up a sandbox in just a few seconds, and an interactiv...