Stéphane Faroult

Biography

Stéphane Faroult first discovered relational databases and the SQL language back in 1983. He joined Oracle France in their early days (after a brief spell with IBM and a bout of teaching at the University of Ottawa) and soon developed an interest in performance and tuning topics. After leaving Oracle in 1988, he briefly tried to reform and did a bit of operational research, but after one year, he succumbed again to relational databases. He has been continuously performing database consultancy since then, and founded RoughSea Ltd in 1998.

Books

The Art of SQL
by Stéphane Faroult, Peter Robson
March 2006
$44.99 USD

(Read Reviews)

Articles

You need to enable JavaScript to view more than 15 articles by this author.

Emulating Analytic (AKA Ranking) Functions with MySQL: Part 2
Publish Date: Apr. 13, 2007Oracle, DB2, and SQL Server all have analytic functions--ways to preserve the details in a record when you use an aggregate. MySQL lacks them, but you can emulate them if you want. Stephane Faroult continues his look at how to do this in the second part of his series. Emulating Analytic (AKA Ranking) Functions with MySQL
Publish Date: Mar. 29, 2007Oracle, DB2, and SQL Server all have analytic functions, ways to preserve the details in a record when you use an aggregate. MySQL lacks them, but you can emulate them if you want. Stephane Faroult shows some of the ways to go about this in the first of a two part series. How to Misuse SQL's FROM Clause
Publish Date: Sep. 30, 2004Many SQL queries misuse their FROM clauses. Misuse them? That's right. Stéphane Faroult explains this common mistake and demonstrates how two types of subqueries can improve performance and reliability.

Blog

Check your counters

May 11 2006

All right, in the natural vs surrogate key religious war, I rather feel on the natural key side (I have nothing against using a surrogate key as a shorthand for a complex primary key, but I have seen too many people adding to a table a system-incremented column and calling… read more

Denormalizing

May 09 2006

I have been recently involved in trying to improve the performance of an application that primarily handles messages (more and more of them). It is a kind of state machine. Three different types of entities are managed (one of the types happens to be sets of another type), and messages… read more

McDBA

May 09 2006

I am not sure that the soothing discourse of vendors about “easy administration” goes the right way. When I read in Oracle’s “2 Day DBA” guide Prior knowledge or experience with managing databases is not required. The only requirement is a basic knowledge of computers. I can just wonder. Everything would no… read more

Biography

Books

Articles

Blog

Buy Direct and Save

Bundle Your Order