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

Posted in: Technical Track

Welcome to Log Buffer. The weekly review of DBA industry news. Enjoy Log Buffer #199.

Remember if you find a link or interesting blog post that you think Log Buffer should mention, send a note to the editor at Log Buffer and be sure to include the link, and a short note outlining why you think that particular post would be of value to other DBAs, or what you learned from reading it.

And, for inquiries about hosting or editing a future edition of Log Buffer on your own blog, send your query to the Log Buffer coordinator. (Please include the words “Log Buffer” in the subject.)

Kicking off this week are posts recommended by Gwen Shapira who also took a few minutes to share her production advice for developers.

Not strictly Oracle related, but fun story of how Catherine the Python-Oracle geek got hacked during her own presentation.

Dominic Brooks looked for upgrade tips and got some excellent advice.

Jonathan Lewis started a series about joins. Jonathan is the master of building clear and excellent test cases, and this post is a good example of this.

Pythian’s Singer Wang points out a post from Greg Baker, highlighting an announcement of proof that P is not equal to NP.

Baron Schwartz, on MySQL Performance Blog, shares sound advice on why you can’t rely on a replica for disaster recovery.

Ronald Bradford makes the case against using rpm packaging for MySQL.

Kerry Osborne is stunned by Exadata’s storage indexes as he does a little testing.

Willie Favero talks about parallelism improvements in DB2.

Leo Hsu and Regina Obe, on Postgres Journal, talk about starting PostgreSQL in windows without install.

In SQL Server news Linchea Shea says for performance impact, forget about sets and focus on loops.

And to close things off a last minute entry by Christo Kutrovskydesigning for Exadata, maximizing storage indexes use.

Interested in working with Vanessa? Schedule a tech call.

About the Author

Vanessa is an experienced business development professional with over 15 years’ experience in all aspects of the business development and marketing disciplines. She brings endless energy, drive, and a results-oriented approach to creating Pythian’s strategic partnerships and business initiatives. In her spare time, Vanessa pursues her passion for great food, wine, and artisan cheeses as an accredited Cheese Sommelier and Cordon Bleu-trained chef. Her weekly Friday afternoon cheese tastings at Pythian’s Ottawa office aren’t to be missed!

1 Comment. Leave new

I particularly enjoyed Kerry Osborne’s stunning experience with storage indexes of Exadata.


Leave a Reply

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