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

This Log Buffer Edition marvels at the ease, simplicity, and power of the database bloggers as they go about their adventures in the realms of Oracle, SQL Server, and MySQL.

Oracle:

The new Oracle Database 12c’s “Implicit Result Sets” (IRS) feature allows query results to be returned from a stored PL/SQL procedure (or a PL/SQL anonymous block) without requiring a special PHP code.

Ranka has been spending a lot of time on big data and its application, architecture, and processes.

Kashif Manzoor tells us how to use the new Clone Log Parser utility in Oracle E-Business Suite.

Neil Chandler is killing a session OS style.

With the release of Oracle 12c, we get new functions/procedures and some updated ones for Oracle Data Miner, which is part of the Advanced Analytics option.

SQL Server:

SSRS has a default set of color combinations for charts. Let’s face it, they aren’t pretty. Jes Schultz Borland tells all.

Prashanth Jayaram is sharing a query to find data, log, Total Size, and other useful information on all databases.

Crash when inserting to a FileTable with a parallel plan.

Here is a post about resolving concurrency problems in SQL Server 2012.

What to do when you encounter DBCC CHECKDB … Terminated Abnormally Due to Error State 6.

MySQL:

Tony Darnell is creating and restoring database backups with mysqldump and MySQL Enterprise Backup.

Percona is glad to announce the release of Percona Monitoring Plugins 1.0.4. The components are designed to integrate seamlessly with widely deployed solutions, such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.

The MySQL Developer Tools team is pleased to announce the availability of the third beta release of MySQL Workbench 6.0. It is the new major update of the Development and Administration tool for MySQL.

Geoffrey Anderson has Innobackupex, schema migrations, and more!

pt-query-digest is the tool you use to generate a report of your slow query log (or some other supported sources) and is similar to, for example, the Query Analyzer in MySQL Enterprise Monitor.