Welcome to Log Buffer, the weekly news update of happenings in the database world.
A big shout out to Pythian team members Andrey, Gwen, Fahd, and Don for their submissions. We have lots of news and recommended reading this week so let’s get going with Log Buffer #209.
Christian Antognini, recently updated his Edition-Based Redefinition paper about new feature of 22.214.171.124 to specify a default edition at the service level.
Gwen Shapira’s faves:
Michael Dinh describes how he solved a tricky grid control issue.
Uwe Hesse, The Oracle Instructor, instructs us about real-time automatic block media recovery with Data Guard in 11gR2. Uwe’s blog is the latest addition to Gwen’s blog roll, as she finds everything he writes is interesting and well explained.
Peter Zaitsev asks you to STOP optimizing your innodb tables, he has a much better way of rearranging them.
Seth Godin doesn’t write about Oracle, but Gwen thinks we all want to know who is the world’s worst boss.
Bruce Schneier, the security expert wrote a moving article about the wrong ways to handle big security issues. Not specific to databases at all, but worth reading.
Pythian’s Edwin Sarmiento did an excellent job explaining the basic concepts and terms for disaster recovery planning. Edwin is our resident MSSQL expert, but this post will interest any IT professional.
Marcus Monning wrote to us about Mumbai – his home-made database browser/performance analyzer. Its a pretty impressive tool, especially for a hobby project and Gwen encourages you to check it out. It is difficult to teach an old dog new tricks and at the end of the day, she’s still using SQL*PLUS.
Don Seiler humbly suggests his own blog post from this week on the Oracle 126.96.36.199 upgrade bug. Could be a big time-saver for a lot of folks out there. Post a comment if you agree.
And lastly, we have DB2 news from Fahd Mirza:
Matthias Nicola finds a gem about XML capabilities of DB2, and touches upon DB2 pureXML.
SECADM authority is a huge step forward taken by DB2, appreciated by Dave Beulke.
Henrik Loeser uploads an enlightening video about how long it takes to build workload optimized systems.
Neal Fishman discusses the implication of changing a data structure.
That’s it for this week. Thanks for reading!