Thanks to Leonardo Villamil Gamba, there are new Spanish translations of Article Four and Article Five in the popular VB.NET/MySQL article series.

See all the Spanish translations at http://www.vbmysql.com/articles/espanol/.

Google Translated:

Los gracias al espicanardo de Leonardo Villamil, allí son nuevas traducciones españolas del Article Four de Article Five. Ver todas las traducciones españolas en el …

This common complaint uttered fairly frequently on the forums and some similar related issues appears to stem from some basic misunderstandings of the MySQL account structure. The most common culprit is the "anonymous guest" account set up by default coupled with an initial lack of knowledge of how to connect to MySQL. Personally I have no use for such accounts and remove them when I find them. Presumably the intent is to allow anonymous users minimal access to MySQL, where they are limited to using the `test` database which is also set up by default. Compounding this issue is the Command Line Interface start-menu shortcut created by the installer versions of the Windows packages, which connects users as 'root' automatically and oftentimes unbeknownst to them. Then when the user goes to connect via some other means and presents incorrect credentials out of ignorance, then there is a chance that this guest account may be inadvertantly invoked.
…

I'm still reading through BusinessWeek's interview with Steve Ballmer, and still fascinated. Love him or hate him, Ballmer is a smart guy.

Ballmer refused to call the YouTube valuation ($1.65B) overvalued. He rightly said that it depends on a lot of factors (factors, incidentally, that I don't personally think add up, but I'm willing to be wrong):

You're clear as a bell on the YouTube valuation…
No. I'm not saying it is overvalued. I'm not trying to say that. It depends on a set of factors. I'm not saying I wouldn't write a check for that amount of money. I might.

Really, even though there's no identifiable business model?
It is one of those things where you have to think. You can't punt either way. If you're asking me if I would …

Some interesting things happened today…

We released a new MySQL server a few days ago, and that consequently means we’ve got a new Connector/PHP available for download. Go get ext/mysqli and ext/mysql against 5.0.26 while its hot.

And while we do support ext/mysql, we’d rather you (and your applications) used ext/mysqli. After all, wouldn’t you like to be able to use the new, much touted features that came post MySQL 4.1, like Views, Stored Procedures, Triggers, Precision Math, and so on?

So to make it a complete no brainer, we released a MySQLi Converter Tool. Its also available via subversion. The tool is branched off Revision 11 (in …

In today’s vote on its patent policy resolution, the European Parliament approved the compromise text I had previously reported on, but it also voted in favor of a few amendments.

The most notable amendment was number 7. It inserted the subclause “which address concerns about democratic control, judicial independence and litigation costs” into article 1. Two of those three concerns (judicial independence and litigation costs) had been mentioned by commissioner McCreevy in his speech in the EP on September 28. But it was a good idea for the EP to reinforce those points.

Dutch …

The comments on my article how to find duplicate rows with SQL made me realize I was simplifying things too much. In particular, I really glossed over the "how to delete duplicate rows" section, which I should have explained in more detail. I hope this article will remedy the omissions.

I hate to start the blog post with the same "I've been really busy excuse" but honestly that's the truth. Ever since I wrote the last post, one important thing happened to me. My dentist prescribed me a mouth wash and it turned out that I was severely allergic to it. My upper lip became extremely swollen and remained like that for couple of days until I got a shot of steroid. Ughh, it was really painful. Anyways, time has just been flying by and I have a lot of catching up to do.

This is the part 4 of MySQL Benchmarking series. In the last post I showed you how you can compile Sysbench on Solaris 10. In this post, I will be showing you how you can compile Super-Smack on Solaris 10.

MySQL Super Smack was originally developed by Sasha Pachev (sasha at surveypro dot com), a former MySQL employee. After Sasha, Jeremy Zawodny of Yahoo! took over the maintenance of …

Warp Networks has been selected by MySQL AB to become an Authorized MySQL Training Center (AMEC) in Spain, offering certified MySQL education in Zaragoza. Courses will be offered on MySQL 5.0, the latest version of the world?s most popular open source database.

When people discuss query optimization on MySQL, or say a query doesn’t perform well, they usually mention execution time. Execution time is important, but it’s not the only metric to use (or even the best). There are many other ways to measure the work a query requires. This article explains how to really profile a query – what to measure, how to do it as accurately as possible, and what it means.

People frequently ask if they can do fancy things in triggers, such as writing to the filesystem, sending an email, or notifying other applications of data changes.I always recommend against doing things like this. Calling an external processes from a trigger or UDF is very difficult to get right, and it is very easy to cause serious problems with your application.Say for instance that you want