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

The just gone-by recession (or is it still here?) taught companies to stop investing in new technology hastily and first look inwards to extract some more juice from the existing humming machines. Administrators across the database technologies find themselves at the center stage of that and they are sharing tips and tricks regarding that in their blogs. This Log Buffer Edition touches that and much more in Log Buffer #246.

Oracle:

Alexander Anokhin talks about the dynamic tracing of Oracle logical I/O.

Timur Akhmadeev wonders about 16K CR gets for UQ index scan?

Charles Hooper blogs about matching the expected output – Analytic RANK, ROW_NUMBER, DENSE_RANK, or Something Different?

Tim Hall shares a post about configuring VNC Server on Fedora 16.

Randolf Geist gives a nice example of what can happen if you attempt to use star transformation but your model obviously doesn’t really correspond to what Oracle expects.

SQL Server:

Mark Broadbent has released the compatibility Matric 1.2 because he thinks that the one provided by MSDN is really very poorly designed and difficult for the average Joe to understand.

SQL Server 2012 RC0 (Release Candidate 0), formerly known as SQL Server Denali, is now available for download.  SQL Server 2012 RC0 is the first release which is feature complete. James Serra announces.

John Pertell shares the step by step about using a variable to create and populate an Excel spreadsheet.

Jorge Segarra is talking about saving the bucks for the organizations through virtualization and how are the database administrators find themselves in the middle of that.

Denny Cherry‘s class is here to get you up to speed on Enterprise Class Storage and Virtualization so that you can get the best possible performance from your existing infrastructure.

MySQL:

Johannes Schlüter says that one of the great things about the HTTP protocol, besides status code 418, is that it’s stateless.

How do you know when to shard your database? Liran Zelkha tells.

Robert Hodges wonders as why so many proprietary rewrites of MySQL and InnoDB?

Ulf Wendel discloses that the catchy theme/motto of the PECL/mysqlnd_ms 1.2 release will be Global Transaction ID support, and also shares two features hidden behind the buzzword.

Pavan Venkatesh claims that SchoonerSQL is there to make the life of DBAs and Developers easy.