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

With the summer approaching in Australia and Winter making inroads in Canada, the contrasts are also vivid in the blog posts of Oracle, SQL Server and MySQL. Relishing this distinguished medley, Log Buffer Edition is blossoming with new blog posts in Log Buffer #286.

Oracle:

Julian Dontcheff throws some light on not-much discussed Bloom Filters.

Gokhan Atil is creating AWR reports and sending them via email.

Do you know you get database failure each time when you create a new database with DBCA? Kamran asks.

Some of us write every day … some of us only when motivated … and that day Morgan was motivated.

Maria Colgan cannot believe it’s time for OpenWorld again!

SQL Server:

Laurentiu Cristofor blogs about South Korea’s worst security breach so far.

Bob Dorr was looking at data from a customer, in a different time zone (UTC+1) from his, this week involving SQL Server AlwaysOn (HADRON) and found that lining up the timestamps in the various logs was challenging.

Converting hexadecimal values to varbinary and vice versa is now easier using the XQuery functionality available from SQL Server 2005.

gcmouli is writing about connection loss errors in the SSMS Query editor.

A common problem for some SQL Server applications are cases where data typically ascends. Ian Jose has more.

MySQL:

Oracle is the most powerful database system in the world. However………

A fine step by step blog by Mark Grennan about installing PostGIS 9.2 on RedHat 6.2 .

Kris Buytaert is giving Gentwerpen Devops meetup and conference season update.

Top 10 MySQL Tips and Mistakes for PHP Developers by Toney Darnell.

One of the MySQL bugs having birthday today is Bug #30994 which  Hartmut Holzgraefe filed five years ago.