Log Buffer #206, A Carnival of the Vanities for DBAs
Nov 15, 2010 / By Vanessa Simmons
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.
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.
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.
Aaron Bertrand introduces a feature in SQL Server 2011, called SEQUENCE that most Oracle DBAs would recognize too.
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.
Leave a Reply