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.
Andrey Goryunov’s top picks:
Dion Cho, the Oracle Performance Storyteller, provides an explanation of parallel DML execution plan.
Christian Antognini, recently updated his Edition-Based Redefinition paper about new feature of 18.104.22.168 to specify a default edition at the service level.
Tanel Poder, on Core IT for Geeks and Pros, shares a description and his understanding of ‘asynch descriptor resize’ wait event in Oracle 11gR2.
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.
Jonathan Lewis hates ANSI style joins and tells you why. Gwen is ashamed to admit that she find ANSI joins far more readable, but after reading Jonathan’s post, she’ll stay away from them.
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.
Kevin Closson writes about “enable NUMA support” initialization parameter.
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 22.214.171.124 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.
What is production data? Yes, we speak this word hundreds of time weekly at our jobs, but have we ever thought about it? Well, Data and Technology blog slices and dices this question.
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!