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

Posted in: Technical Track

It feels like blogs appeared just yesterday. Over the years, they have proved to be of much value for the technical and not-so-technical masses. The big boom in this social media outlet has enabled an unprecedented sharing of ideas for database professionals. The nature of databases and blogging is to always change, but Log Buffers are here to stay.


Oracle:

Richard Foote says that one of the nice features of an IOT Secondary Index is that it contains the mandatory Primary Key of the IOT, which is always maintained and can be used to access the necessary rows of the IOT regardless of  row movement within the IOT itself.

Tanel Poder answers a question in the Twitter sphere about Exadata Smart Scan predicate offloading and sequence.NEXTVAL.

Martin blogs about a long-overdue issue about a failure to load library.

Jonathan Lewis just discovered a critical weakness in one of the implementation details of 11g extended stats that could lead to some surprising instability in execution plans.

Reproducing a Canned Report using a Single SQL Statement is described in another good post by Charles Hooper.

SQL Server:

Chad Miller wants to show how to use table-valued parameters available in SQL Server 2008 and higher and uses examples of the Table-Valued Parameter.

SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, James Serra blogs.

Sometimes you find a tool that is so cool that you can’t believe no-one else has picked up on it before. This is one of those times: A few months or so ago, Chris Webb came across a new tool called as Layerscape.

Pinal Dave talks about social networking sites and professional profiles.

Have you ever found yourself wanting to make a major shift – in skills, roles, or relationships? Kevin Kline asks.

MySQL:

Raj Thukral of Pythian shares his presentation from Percona Live MySQL Conference Presentation.

Pythian’s Marco Tusa shares an interesting account of MySQL conference 2012 in Santa Clara proceedings.

As with any open source software, anyone can download MySQL sources, build binaries for some platforms, and distribute their own packages, says Maciej Dobrzanski.

Julian Hyde shares Data-oriented programming for the rest of us.

James Russell and team give an overview of what they have changed and what are the various configuration variables they have introduced to fine tune the flushing algorithm in InnoDB.

Checkpointing, which involves periodically writing out dirty pages from memory, is central to the design of crash recovery for both TokuDB and InnoDB. Martin Farach-Colton has more.

The story with Adaptive Flushing is long, and Dimitri Kravtchuk shares it.

Interested in working with Fahd? Schedule a tech call.

About the Author

I am in love with Oracle blogging since 2007. The blogging coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies enabled me to get Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth, I have been expressing my love for Exadata. These days for the last some years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

3 Comments. Leave new

Why is this blog constantly ignoring PostgreSQL?

Reply

@Peter, it’s a carnival of the vanities.

You can submit the posts you would like covered and they should be covered. If you’ve been submitting PostgreSQL posts and they have not been covered, send me a note and let me know, although what I suspect is going on is simply that you have not been submitting posts.

The posts included are the ones submitted or the ones the host (in this case Fahd, an Oracle guy) would otherwise have been reading.

Another option is to simply host a log buffer yourself. In that case, you will include whatever you like (but of course also including the posts submitted to you).

You can find out more about how Log Buffer (and in fact every carnival of the vanities) works at the about post, linked above … or just click http://www.pythian.com/news/about-log-buffer/

Reply

Thanks Peter for your feedback. The upcoming Log Buffer would also cover PostgreSQL along with DB2.

Your are very much welcome to send any posts you like to be included or host the log buffer yourself.

Thank you.

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *