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

Posted in: Technical Track

Another medley of database blogs under the famous banner of Log Buffer is in your virtual hands. This edition of Log Buffer, the Log Buffer #221 puts spotlight on the fresh and cool blogs from Oracle, MySQL and SQL Server arena.

Enjoy !!!


Martin is playing around with the Grid Infrastructure PSU 2 and found an interesting note on My Oracle Support regarding the Patch Set Update.

Jonathan Lewis has found another gem as an answer to a question posted on OTN forums regarding the ASSM.

Doug Burns blogs about a fun day this week as Graham Wood, Tom Kyte and Andrew Holdsworth visited London for the latest Real World Performance Day.

Martin Widlake is playing with the missing information in the SQL*Plus as he prefers to work against the database using SQL*Plus.

Niall Litchfield mentions that Oracle Corporation has published the following interested note; How to Perform a Database Health Check. (Note 122669.1).

SQL Server:

Pinal Dave blogs about Running SSIS Package From Command Line in response to a reader’s question.

Dont forget about PASS Summit session preferencing, Allen Kinsel reminds us.

Bob Pusateri savors the pleasure of attending the SQLskills Immersion Event on Internals and Performance taught by Paul Randal and Kimberly L. Tripp.

Michelle Ufford add to a growing list a handy little script which parses a string and returns the results as a table.

Thomas LaRock writes about the process for electing the next slate of officers (President, VP Finance, and VP Marketing) for the upcoming two-year terms for PASS Executive Board Election.

You’ve detected, analyzed and understood blocked processes that have happened on your machine. What can you do to avoid this blocking in the future? Michael Swart shares the takeaway.


We all know that Kurt von Finck is going to give a talk at Percona Live NYC happening May 26 2011. If you want to attend Monty Program Group Blog have got three tickets to give away.

Matt Reid discuss the basics of setting up Heartbeat (LVS) + DRBD (block replication between active/passive master servers) + MySQL.

Partha Datta was bored and so started experimenting with the performance impact of changing the innodb page size was.

Dave Stokes looks at creating a simple benchmark using a common tool to determine which option file to use in MySQL.

InnoDB compression is getting some traction, and Vadim Tkachenko see quite contradictory opinions. Someone has successful deployments in productions, and someone says that compression in current implementation is useless.



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.

No comments

Leave a Reply

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