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

May 11, 2012 / By Fahd Mirza

Tags: , , ,

They say that “April showers bring May flowers”.  Basically, nature brings different things in different colors aimed at improvement. That is also true for the blogging world. This Log Buffer Edition brings out different blog posts to improve the Oracle, SQL Server, and MySQL worlds, so enjoy!


Oracle:

One of the world’s leading Oracle Ustaad, Alex Gorbachev writes an insightful post about Storage Replication for Oracle Database and Licensing.

Back in the (really) old days, systemstate dumps had to be used for diagnosing hangs and finding blockers of hung databases. Another of Oracle’s premier Ustaad, Tanel Poder, has more.

Mark W. Farnham makes an entry in blogosphere with Very Large DataBases VLDB of the Oracle.

Celebrated Oracle Ustaad Thomas Kyte shares his favorite debugging story.

John Piwowar produces a gem of a post, and the title itself rhymes.

SQL Server:

What is your return on experience (ROE)? Thomas LaRock asks.

Conferences are awesome. They are full of people and sessions. Almost TOO many sessions. How on Earth do you get in the “right” ones? Jen McCown wonders.

How can you compare two files and report on differences using Powershell? Jack Vamvas answers.

In some database designs, you may encounter SQL Server columns with a TIMESTAMP or ROWVERSION data type.  What are these, and how do you deal with them in SQL Server Integration Services? Todd McDermid has the answer to both questions.

Why is my SSAS Query Log Table Empty? Melissa Coates blogs.

MySQL:

Pythian’s own Danil Zburivsky writes an interesting post after seeing Collaborate 2012 through the eyes of a MySQL DBA.

Jay Lyman blogs about the great war over IP and offers his insights.

Vadim Tkachenko talks about the new distribution of random generators for sysbench – Zipf.

Momentum for MySQL Utilities continues to build, claims Chuck Bell.

How to back up MySQL Databases with mylvmbackup on Debian Squeeze?

MySQL 5.0 can deadlock when flush logs, show processlist, and a slave connection happen at the same time, according to Eric Bergen.

Marco Tusa shares MySQL news.

3 Responses to “Log Buffer #271, A Carnival of the Vanities for DBAs”

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>