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

Blogs are not just yet another piece of writing. They are the manifestation of passion, perfection and purity of love towards the community. Bloggers take immense pride in sharing what they know or want to know in their blog posts, and that enables the community to respond by learning or by teaching. Log Buffer is a way to appreciate this passion, and Log Buffer #229 is yet another example of that.

Oracle:

Kyle Hailey discusses yet another Rule of Thumb about the log file syncs time.

Many questions Jonathan Lewis see on the internet could be resolved by the simple expedient of looking at the information that’s in front of you.

Martin Widlake shares the story of fastest Oracle server for a grand.

Martin Bach solves an interesting problem, i.e. Using Connection Manager to protect a database.

SQL Server:

Schema Changes History Report produces the list of changes done using DDL. It pulls this information from the Default Trace. Vishal has more detail.

John Pertell does a quick post about an issue he ran across which deals with renaming the SQL instance.

In a simple yet comprehensive blog post, Ryan Adams helps in learning as how to move a TempDB database.

Thomas LaRock shares his troubles regarding the models.

Microsoft has released the final build of SQL Server 2008 R2 SP1. It includes fixes from SQL Server 2008 R2 RTM Cumulative Updates 1 through 6, and some new features introduced since those cumulative updates. James Serra‘s blog has more details.

Are you considering making a change to your view or stored procedure? Or possibly you are considering moving your database to another server and you want to know how the move would impact your SQL Server, asks Brian McDonald.

MySQL:

If you have two or more database servers containing the same data, how do you know if the objects are identical. Furthermore, how can you be sure the data is the same on all of the servers? Chuck Bell expounds.

Vadim Tkachenko passionately follows Galera replication development, and right now he is evaluating how it performs in his benchmarks.

Like all of us, Mark Grennan loves short and consise install instructions and he describes a GIS library.

The latest (GA) version of MySQL Cluster Manager is available through Oracle’s E-Delivery site. You can download the software and try it out for yourselves.

The getopts command simplifies the task of validating and parsing command line options and  arguments for your shell scripts. Nav describes.