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

This Log Buffer Editions rounds up, yet again, some cool blog posts from across the planet. Sit back, relax and enjoy.

Oracle:

Marc has completed review of enhancement of SQL regarding RMAN in the 12c.

This weekend we have finalized latest update for our ADF runtime performance audit tool – Red Samurai Performance Audit Tool v 2.4.

This isn’t a SQL Developer post per-se, however if you are using the Oracle Developer Day VirtualBox 12c image, you will find this useful.

aud$ and ASSM – a good combination.

Why You Don’t Want to Code Validation in Before Commit?

SQL Server:

Basit A. Farooq talks about Different approaches of counting number of rows in a table.

The Top 5 SQL Server Features You Aren’t Using And Why.

A CLR Application: Deleting Three Billion Rows.

The simple query to find the database backup status The select statment consists of ServerName dbname BackupStartDate BackupFinishDate BackupAge Size status Type The query will only run from sql 2005 and later version.

Characters you should never ever use in an object or schema name!

MySQL:

Migration of MTR suites to use InnoDB.

50 tips to boost MySQL Performance Webinar follow up .

MySQL Workbench is a great tool when someone asks you to look at their schemas.

MySQL for Excel Main Features Video.

Many-table joins in MySQL 5.6.