Log Buffer #396, a carnival of the vanities for DBAs

This Log Buffer Edition lists down some of valuable blog posts from across the arenas of Oracle, SQL Server, and MySQL.

Oracle:

OOW Recap: Industrial Innovation with IoT, enabled by Oracle Fusion Middleware and JD Edwards.

PeopleSoft HCM 9.2 Update Image 9 is Now Available! – Simple and Intuitive User Interface on Multiple Devices.

API Catalog (OAC) allows organizations to easily build a catalog of their APIs to provide visibility to those APIs for application development.

Oracle Announces Oracle API Catalog to Simplify API Management.

Tools For Generating Consistent Loads.

SQL Server:

Is Database Mirroring Causing The Transaction Log To Fill Up?

Free SQL in the City Seminar Washington DC – Dec 5, 2014.

Stop Relying on Cloud File Stores as a Backup Strategy.

Stairway to SQL Server Indexes: Level 1, Introduction to Indexes.

SSRS – Report for Stored Procedure with Parameters.

MySQL:

Can you use the binary logs to undo a DELETE? Maybe, if you’re using ROW format logging. The difference between a delete and an insert event could be just one byte – the one that maps it as a DELETE_ROWS_EVENT or a WRITE_ROWS_EVENT.

Ubuntu 14.10 LAMP server tutorial with Apache 2, PHP 5 and MySQL (MariaDB).

Resizing the InnoDB Buffer Pool Online.

Inside Distributed Architectures: Seeing In-Flight Requests And Blockers in Realtime.

Stopping a Runaway Rollback due to Failing Mass Import or ALTER TABLE.