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

It’s always sunny in the database arena, even if the data is engulfed in the clouds. Innovation rays keep databases illuminating and bloggers make hay in this sunshine and this Log Buffer Edition sift through all those blog post and brings you Log Buffer #298.

Oracle:

When Michael Abbey writes it, it stays written. His account of this year’s fascinating UKOUG conference is simply awesome. Pythian’s Paul Vallee, Vanessa Simmons, Luke Davies, Paul Logan, Alex Gorbachev and many other presenters were there to set the stage on fire.

Jonathan Lewis is sharing a funny little glitch – typical of the sort of oddity that creeps into the data dictionary from time to time.

Thing of adding disks to VMware Workstation 8 on the fly on RHEL 6? Martin Bach has a post.

Enqueue – is it a PK, FK or Bitmap Index problem? Kyle asks.

Profiling PL/SQL is an Oracle feature since Oracle 9i (2001) and yet Frits Hoogland hasn’t seen anyone actually use the profiler.

Whether to use BIGFILE temporary tablespaces in an Exadata system? Marc Fielding answers.

SQL SERVER:

Free SQL training is happening right now, Jen McCown informs.

James Serra is giving SQL Server Data Tools (SSDT) – November 2012 update.

Jason Strate is talking about Deprecated System Tables – syslockinfo.

Why Corporate BI and Self-Service BI Are Both Necessary. Chris Webb answers.

Valentino Vranken is wasting some time because of a silly bug.  This time it was due to the OLE DB Source component and the way it works with parameters.

MySQL:

Tungsten Replicator is a popular replacement for MySQL replication. It has now become a mature and robust product, with an easy-to-use installer. Petri Virsunen has more.

Martin Farach-Colton is doing review of fractal tree indexing and answers questions about how Fractal Tree indexes work. It’s a write-optimized index with fast queries.

Tony Darnell is using using the MySQL Script mysqlfailover for Automatic Failover with MySQL 5.6 GTID Replication.

Gerrit is telling about the differences between SQLite and MySQL and in which cases it is better to use the first or the latter one.

Jay Janssen is giving a tip about quuickly finding unused indexes and estimating their sizes.