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

Posted in: Technical Track

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.

email

Author

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

3 Comments. Leave new

Amardeep Sidhu
May 12, 2012 4:22 am

Wondering how many people understood the meaning of “ustaad” ? :)

Reply

Amardeep jee, Thanks for your comment. I am sure Ustaads have already googled it and know what it is :) , and I am also sure you know what it is. :)

It’s an Urdu word which means Master or Teacher.

Reply
Amardeep Sidhu
May 15, 2012 1:02 pm

I obviously know :)

Reply

Leave a Reply

Your email address will not be published. Required fields are marked *