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

Posted in: Technical Track

Welcome to Log Buffer, the weekly news blog about blogs in the datasphere… As we kick off Log Buffer #206, our own Gwen Shapira shares a few of her weekly favorites:

Oracle:

Arup Nanda posted an excellent script on how to summarize backup information from the rman catalog. He also posted a tool for automatically purging time-based partitions.

Pythian’s resident Exadata expert, Marc Fielding posted links to the latest recording of his Exadata webinars.

Gary Mayers, on Sydney Oracle Lab explains Oracle user security model.

Riyaj Shamsudeen shows what really happens when you update a query with the same values it already had.

Jonathan Lewis explains how he tests list partitions, a post which gives an excellent review on how one should go about testing new features in general.

MySQL:

At MySQL Performance Blog, Aurimas posts a war story about a very unusual data recovery. Test your backups, or you may have to go through the same ordeal.

In same blog, Morgan Tucker gives another reason why you shouldn’t use mysqldump to take backups.

SQL Server:
MVP Edwin Sarmiento is blogging live from SQL PASS 2010 in Seattle.

Aaron Bertrand introduces a feature in SQL Server 2011, called SEQUENCE that most Oracle DBAs would recognize too.

And lastly a few general posts. One from Michael Lopp, who, on the “Rands in Repose” blog, explains how people follow conversations, with some amusing examples.

And the second from Singer Wang who reports that RedHat 6 is finally out after 4 years.

A big shout out to this week’s contributors wraps up this issue. Don’t forget, if you’re interested in hosting your own issue of Log Buffer – send an email to the Log Buffer Coordinator.

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!

No comments

Leave a Reply

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