Log Buffer #187, A Carnival of the Vanities for DBAs
Apr 30, 2010 / By Vanessa Simmons
Welcome to Log Buffer. This week’s issue #187 was another group effort. Thanks to all our contributors – you rock!
Suggested by Pythian’s Bradd Piontek, is a post he really liked because he used to write pipelined functions for Dynamic Search queries, – Tom Kyte’s something new I learned about estimated cardinalities. He’s also highlighted something new Tom learned about sqlplus. And the fact that Richard Foote announced the Oak Table’s new website. Bradd’s last note highlights tips and tricks from Christian Antognini on analysing a SQL Trace File with SQL Statements on his blog Striving for Optimal Performance.
Contributing from Chris Presley on the SQL Server side of things is Kimberly L Trip’s post about single use plans in the procedure cache, or Glenn Berry’s SQL Server Performance blog – A DWV a Day – Day 29, sys.dm_exec_connections. Chris also suggests these cool restore myths debunked from Paul Randal’s blog In Recovery.
Raj Thukral suggests a well captured post by Gwen Shapira which conveys the complexity of a database migration even to technical people.
Finally escaped from Denmark, and home safe and sound this week from Miracle OpenWorld, Alex Gorbachev suggested great video recording of the Oracle APEX introduction session – for everyone who is interested in understanding how Oracle Application Express works by creating a simple application without using any wizards. Read more in – Part 1 & Part 2.
As a last addition, here are Gwen Shapira’s picks for this week:
Francisco Munoz Alvarez from New-Zealand who gives us few useful tips on how to use datapump to accomplish common tasks that as first glance don’t seem much related to export and import. Version for example.
Greg Rahn updated his Structured Data blog with the best practices of data loading. In additional to few usefull tips, he also shows off the amazing data loading capacity of the Exadata. How fast can *you* load a 1T into a table?
Tanel Poder shows that you can learn interesting things by running EXPLAIN on index creation commands.
Jay Kreps gives a presentation with an excellent overview of Project Voldermort, a distributed key-value system. He talks about the architecture, and also how it is used by Linked-In.
Simmon Willison shares his Redis tutorial. Great content and even better design makes this an enjoyable way to learn how to use a NoSQL database in just few hours.
Google licensed Hadoop to use its patented Map-Reduce technology. Very good news to the open-source Hadoop community.
And a big shout out to all you DBAs out there. It’s time to hear from someone else. Log Buffer is looking for volunteer editors for the next few issues. 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.)