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

May 21, 2011 / By Fahd Mirza

Tags: , , ,

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 !!!

Oracle:

Martin is playing around with the Grid Infrastructure 11.2.0.2 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.

MySQL:

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.

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>