Log Buffer #198, A Carnival of the Vanities for DBAs
Posted by sdefilip on August 6, 2010
Welcome to Log Buffer, the weekly roundup of database industry news. I’m guest hosting this week’s edition, Log Buffer #198[S D1] [S2] , normally published by Pythian. If you want to host your own version of Log Buffer, reach out to the Log Buffer coordinator.
Lots of good “stuff” out there on the technical blogs this week so here are some interesting ones:
which contain sets of hints.
Scalability and the Oracle conflicts of interest that can be brought about by managing it are illustrated by
Jonathan Lewis on Oracle Scratchpad.
In a series of posts on the topic of the SQL Server 2008 Optimiser: Constructing a Plan, Part 1 & Part 2, on the “SQL Server Blogspot on the Web”, Paul White provides detail on how to get SQL code and queries to perform at their best.
Simon Sabin discusses Creating a Unique Constraint on a Column That Allows Nulls on “Simon’s SQL Blog”.
On the “MySQL Performance Blog”, Baron Shwartz cautions Why You Can’t Rely on a Replica for Disaster Recovery.