Log Buffer #279, A Carnival of the Vanities for DBAs

In a typical organization, all work together to bring out a common good for the outside world. It’s interesting to see how all of these entities blog about technology, and there is more and more interest shown by managerial technologists about databases. This Log Buffer Edition appeases their appetites. Enjoy!

Oracle:

Tim Hall was using Grid Control to do a DB recovery test yesterday, and something rather unusual happened.

Kerry Osborne started on an interesting mad scientist kind of project a couple of days ago. The title of blog post is very enticing: Exadoop.

Frits Hoogland blogs about using udev on RHEL 6 / OL 6 to change disk permissions for ASM.

Charles Hooper reviews yet another performance tuning book.

David Kurtz is looking at gathering aggregated Cost-Based Optimiser statistics on partitioned objects.

SQL Server:

Microsoft SQL Server team is very excited to announce that SQL Server 2008 R2 SP2 is now available, according to Colin Stasiuk.

Jen McCown has a quick guide about expanding instant file initialization (IFI) and database files.

Kevin Kline directs towards white papers about common high-availability and disaster-recovery architectures deployed by customers.

In this blog post, Michael Swart recommends that you use composite primary keys for child tables in composite relationships.

Maintaining service uptime is the holy grail for Production DBAs. Jack Vamvas discusses a DBA’s daily routine.

MySQL:

Aaron Brown has a gem of a post about the performance of MySQL Semi-Synchronous replication over high latency connections.

Why is there no index for CSV files? Indexes are very simple. Mark Grennan has more.

Bill Karwin does a followup to the SQL injection questions.

This blog title has both MySQL and Hadoop in it, so it is bound to be interesting.

That eternal quandary again by Taneli Otalia: to be or not to be.