(Giuseppe Maxia) A question that came up during the MySQL track at the UKOUG conference in Birmingham was “Can I exclude only a few databases from mysqldump? Let’s say that I have 50 databases, and I want to dump all of them, except a few.”

(Rob Gravelle) There has been much debate as to whether derived tables, views, or temporary tables are actually faster in terms of database performance. The fact is that there is no simple answer, as different queries require different optimizations.

(Giuseppe Maxia) There is much talk about MySQL forks and how they are going to replace MySQL, or take over MySQL user base, or become more powerful/profitable/popular/you-name-it than MySQL itself.

(Vadim) Working with customer, I faced pretty nasty bug, which is actually not rare situation , but in this particular there are some lessons I would like to share.

(Alexander Rubin) With the standard data warehousing queries we have a fact table and dimension tables and we join them.

(Leo Hsu and Regina Obe) In this article we’ll provide a summary of what PL/R is and how to get running with it. Since we don’t like repeating ourselves, we’ll refer you to an article we wrote a while ago which is still fairly relevant today called Up and Running with PL/R (PLR) in PostgreSQL: An al

(Giuseppe Maxia) There are three types of FUD: the first and more genuine is (#1) the intentional spreading of falsehood, mostly to gain some marketing advantage over a competing product. While I despise this practice, I understand it.

(Anders Karlsson) You may have read a previous post of mine, back in April this year, where I wrote about using the MySQL 5.5 Audit interface to SQL Statement monitoring. There was a bunch of comments and some ideas, but not much happened. Until now that is.

(Mark Callaghan) There have been interesting discussions in the PostgreSQL community about adding support for index only scans. On several occasions people were curious about how InnoDB supports this.

(ovais.tariq) The more I go through others SQL, there are some common mistakes that I see developers making over and over again, so I thought why not start a series of tips that can help developers optimize their queries and avoid common pitfalls.