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

Nothing pleases the technology bloggers more than the moment when somebody thank them for a helpful blog entry. That is one of the many awesome advantages of the technology blogs. In database arena, the developers, DBAs and evangelists are sharing their tips and tricks through their blogs and this Log Buffer Edition is projecting them all in Log Buffer #260.

Oracle:

Jonathan Lewis is taking a look at recent developments in the “fix control” list, and the “optimizer environment” parameters.

Directly Executing a Query is Slower than Returning a REFCURSOR from a PL/SQL Procedure – What is Wrong with this Quote? Charles Hooper explains.

The Hotsos Symposium is probably the best performance oriented Oracle conferences in the world. Kerry Osborne is happy to present there like some of other chosen ones.

Oracle has released the Oracle R Distribution, an Oracle-supported distribution of open source R.

Kamran Agayev shares his take on Getting “ORA-00959: tablespace ‘TBS01? does not exist” during Data Pump import.

SQLServer:

Jack Vamvas says that working with Powershell and Active Directory simplifies some complex tasks for the DBA.

James Serra is excited about the new version of PowerPivot and shares his top 5 features.

Ryan Adams informs about his speaking engagement at PASS DBA Virtual Chapter on February 22nd, 2012, and his title is about Mirroring.

As part of troubleshooting Kerberos authentication for SQL Server Chad Miller had to verify SPNs so he thought he’d blog about the process he went through.

If you think certification is unneccessary, then read the Shaun Stuart’s path to certification.

MySQL:

Mats Kindahl demonstrates about Pythonic Database API now with Launchpad.

How to recover deleted rows from an InnoDB Tablespace? Niguel Angel Nieto answers.

If the database has 1 ibdata file that is using autoextend but also has a max value set, will it start a new file once the max value is reached? Keith Larson replies.

Mark Callaghan discusses the benefit of keeping the InnoDB transaction log in cache.

Does Anders Karlsson really want to get rid of SQL_MODE?