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

Posted in: Technical Track

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.

Interested in working with Fahd? Schedule a tech call.

About the Author

I am in love with Oracle blogging since 2007. The blogging coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies enabled me to get Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth, I have been expressing my love for Exadata. These days for the last some years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

1 Comment. Leave new

Log Buffers of July | Oracle Administrators Blog - by Aman Sood
January 27, 2012 11:34 am

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

Reply

Leave a Reply

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