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

Jan 6, 2012 / By Fahd Mirza

Tags: , , ,

A very very Happy New Year 2012 to all of you. These are the festive and jubilant times when people look back on previous years and make plans for their new year and beyond. Well, this Log Buffer Edition is no different. This week covers the new year posts of the bloggers across the database arena in Log Buffer #253.


Oracle:

Tom Kyte says Another year, another list of ‘resolutions’.  Welcome to twenty-twelve :)

Rene Kundersma heralds that 11.2.0.3 is now available for the Oracle Exadata Database Machine.

Richard Foote discusses a curious case Of The Ever Increasing Index Solution.

What is the Meaning of the %CPU Column in an Explain Plan? Charles Hooper answers.

What is the performance overhead of datafile autoextend events? Niall Litchfield answers.

SQL Server:

Jason Strate has decided to bundle up all of the posts into a single document, and now distributing it.

There’s beauty everywhere – even in SQL Server. Brent Ozar is struck by the art of the execution plan.

Jack Vamvas blogs about SQL Server Disable Indexes and Rebuild Indexes dynamically.

Vishal shares as how to identifying default data directory for multiple instances through registry.

Michael Swart is looking back and up.

MySQL:

Looking for RAID Controller without Battery Learning problems? Peter Zaitsev helps.

A a new tracing capability has been added to the MySQL optimizer with 5.6.3. Optimizer Tracing goes beyond EXPLAIN EXTENDED to show how the optimizer treats queries. Dave Stokes has more.

Ronald Bradford tells us about the most important MySQL Reference Manual page.

Mahmud Ahsan is rewinding 2011 and saying happy new year for 2012.

Jay Lyman declares 2012 to be year of Linux domination.

2 Responses to “Log Buffer #253, A Carnival of the Vanities for DBAs”

  • Peter says:

    Why is it that you completely ignore PostgreSQL in this blog?

    • Gwen Shapira says:

      @Peter

      Pythian doesn’t support PostgreSQL, so we tend not to read blogs about it. We can only highlight blog posts that we actually read.

      PostgreSQL is a fine database, we have nothing against it, its just out of scope for us. We don’t cover DB2 and MongoDB either.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>