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

Dec 21, 2012 / By Fahd Mirza

Tags: , , ,

If you are reading this, it means that the world continues to move on and that somebody somewhere was wrong in predicting the end of it. The ageless Log Buffer presents some cool blog posts to you yet again just before the holiday season to top up your excitement. This edition is as sweet as the holidays and as sumptuous as an Aussie BBQ. Enjoy!

Oracle:

Gavin Soorma discusses  how to achieve high availability in an Oracle 11g GoldenGate environment using Oracle 11gR2 Grid Infrastructure Clusterware services.

Kamran Agayev is using scp with nohup command without providing a password.

Mario Alcaide is changing sys password in RAC databases.

Rafi is restoring a restore point in Oracle EBS database.

Tanel Poder has released Snapper v3.61, and the icing on cake is that more work on it is in progress.

SQL Server:

Allen Kinsel is giving us PASS Chapters Update Q4 2012.

Kate and Emil show how to use Union All Transformation.

SSMS Tools Pack 2.5.3 is out with bug fixes and improved licensing.

Basit has a good post about changes for the newest version of SQL Server 2012 security.

Kenneth Fisher is showing us red errors in the results pane.

MySQL:

You may build an application on top of a database schema using TRIGGERS. And it may work perfectly as long as the database is only accessed from the application. Webyog has more.

Greg Sabino Mullane worked on a Rails 3.2 project that used the sweet PLupload JavaScript/Flash upload tool to upload files to the web app.

Frederic Descamps says that SELinux is not always the culprit.

The Queen of Evil is back, and she wants your MySQL database skills!

Sergey Glukhov (Gluh) recently wrote an interesting blog about InnoDB secondary key improvements in MySQL 5.6.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>