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

Dec 23, 2011 / By Fahd Mirza

Tags: , , ,

New Year is the time to bid farewell to the old year and welcome the coming year. It is the time to remember the golden olden blog posts. It is the time for new beginnings and new starts in life, and of course for new blog posts. Bloggers in the database arena are also enjoying the festivities with full zeal and zest and this Log Buffer Edition, which is Log Buffer #251 covers just that. Happy Holidays.

Oracle:

Randolf Geist has got a Oracle related Christmas present for you at his blog.

In case you didn’t know, Jonathan Lewis’es new Oracle Core: Essential Internals for DBAs and Developers book is out (for a few weeks already) and Tanel Poder was the technical reviewer for that book.

Tim Hall has got some updated information about the DNS config w.r.t to the RAC SCAN.

One of the easiest ways to understand something is to see a visualization. Looking at Active Session History (ASH) data is no exception and Greg Rahn dives into it.

Jonathan Lewis is demonstrating a correlation oddity in a friendly way.

SQL Server:

Pinal Dave shares a quick script for Point in Time Recovery – Back Up and Restore.

Luckily even when it seems as though cell security is the only option, in at least some scenarios with a bit of extra cube modelling work dimension security can still do the job. Chris Webb tells how.

Yes, what a difference can a year make, as put by Wes Brown.

Michael Swart, like almost all the bloggers, dishes out a simple message, and i.e: Merry Christmas.

Colin Stasiuk is hoping that the best of your todays are the worst of your tomorrows!

MySQL:

Stewart Smith talks about optimizing InnoDB for creating 30,000 tables (and nothing else).

When using the replication slave stream, or mysql command line client and mysqlbinlog output from a binary/relay log, all statements are executed in a single thread as quickly as possible, a blog by Ronald Bradford.

When Oracle acquired MySQL there was some concern about what would happen with the world’s most popular open-source database.  It’s clear now that not only is Oracle very serious about continuing the great database but it is expanding the teams working on it and it’s related technologies. Reggie Burnet introduces more.

How to log all MySQL queries in Drupal? Ilan Hazan answers.

Patrick Crews rightly points out that one of the best things that can happen to a piece of software is for people to actually use it.

Happy Holidays !!!!

One Response to “Log Buffer #251, A Carnival of the Vanities for DBAs”

  • Gary says:

    Any chance that, as a Christmas present to us old fogeys, you could make the font a bit bigger on this blog. 12px is unreadable for me.
    Recommended practice is to use “em” rather than “px” or “pt”. The “px” doesn’t get rescaled by the user’s choice of text size in IE (which, like it or not, is the standard SOE browser in many companies). It’s not great for mobile devices either.
    http://www.w3.org/WAI/GL/css2em.htm

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>