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

This week’s Log Buffer #296 focuses on Oracle, SQL, and MySQL weblogs from across the planet. Log Buffer Editions are the manifestation of the fact that nerd bloggers from databases are not only growing but they are also producing immense volume of quality ramblings. Enjoy.

Oracle:

Stelios Charalambides book on SQLTXPLAIN is now announced, Carlos Sierra informs.

Geertjan is showing around things like Oracle DB, Oracle ADF, GlassFish, JDeveloper, NetBeans IDE.

Paul Wright is asking; Good news and  bad news – which would you like first?

MacLochlainns is blogging about reset sequence start with.

Glynn Foster is sharing a simple deployment example using Oracle Solaris 11.

Gwen Shapira has written an excellent and concrete advice for abstract writers.

SQL Server:

Jason Strate has compared the compatibility view sysperfinfo with the dynamic management view sys.dm_os_performance_counters.

SQL Server 2012 introduces the CHOOSE function which allows to return an item based upon its 1-based index value. David Dye gives an example.

Denny Cherry is fixing a table that has overflowed its primary key.

It didn’t get much attention at the time (maybe because it was done at the Sharepoint Conference, and not at PASS… why?)  Chris Webb asks.

Jen McCown has written a good piece of advice for beginners in blogging.

MySQL:

Bill Karwin blogs about his favorite tool as he asks for some query logs.

Anders Karlsson talks all about Character sets, Collations, UTF-8 and all that.

Ulf Wendal is supercharging PHP MySQL applications using the best API.

Ronald Bradford is working on an evaluation project about schema design in open source applications, and seeks community help.

In his MySQL 101 Cedric Peintre is having a go at Numeric type attributes and maximum value.