Welcome to Log Buffer. The weekly review of DBA industry news. Enjoy Log Buffer #199.
Remember if you find a link or interesting blog post that you think Log Buffer should mention, send a note to the editor at Log Buffer and be sure to include the link, and a short note outlining why you think that particular post would be of value to other DBAs, or what you learned from reading it.
And, for inquiries about hosting or editing a future edition of Log Buffer on your own blog, send your query to the Log Buffer coordinator. (Please include the words “Log Buffer” in the subject.)
Kicking off this week are posts recommended by Gwen Shapira who also took a few minutes to share her production advice for developers.
Not strictly Oracle related, but fun story of how Catherine the Python-Oracle geek got hacked during her own presentation.
Dominic Brooks looked for upgrade tips and got some excellent advice.
Jonathan Lewis started a series about joins. Jonathan is the master of building clear and excellent test cases, and this post is a good example of this.
Pythian’s Singer Wang points out a post from Greg Baker, highlighting an announcement of proof that P is not equal to NP.
Baron Schwartz, on MySQL Performance Blog, shares sound advice on why you can’t rely on a replica for disaster recovery.
Ronald Bradford makes the case against using rpm packaging for MySQL.
Kerry Osborne is stunned by Exadata’s storage indexes as he does a little testing.
Willie Favero talks about parallelism improvements in DB2.
Leo Hsu and Regina Obe, on Postgres Journal, talk about starting PostgreSQL in windows without install.
In SQL Server news Linchea Shea says for performance impact, forget about sets and focus on loops.
And to close things off a last minute entry by Christo Kutrovsky – designing for Exadata, maximizing storage indexes use.
I particularly enjoyed Kerry Osborne’s stunning experience with storage indexes of Exadata.