Inspired by a great talk I attended today by Ryan Sims I've been swoting up on the Dreyfus model which defines a model for new skill acquisition. Thinking about this model while acquiring new skills allows you to focus on what you need to do to get to the next level (eventually Expert), rather than just simply spending time with a new technology/subject which I all too often do. Its about 'learning smartly'.
What! What?
Wal McConnell
27 Oct 2009
innotop is a fantastic tool to investigating what's going on live inside your MySQL server. Use it to spot locks, deadlocks, long running queries, buffer sizes, replication status
26 Oct 2009
I've been using the HAVING clause to simplify my SQL queries. It allows you to specify a condition for an aggregate function used in the SELECT list (doing so in the WHERE clause is illegal).
So to find the politicians who are receiving a total of more than $50,000 of expenses
SELECT politician, SUM(payment)
FROM expences
GROUP BY politician
HAVING SUM(payment) > 50000;
Nice!