Log Buffer #481: a carnival of the vanities for DBAs

This log buffer edition covers Oracle, SQL Server and MySQL blog posts.

Oracle:

Believe it or Not: Converting an Inner Join to an Outer Join to improve performance

How Companies Are Using Big Data

Leveraging Oracle Developer Cloud Service for APEX & Oracle DB Lifecycle Management

We have an OEM job that we run after each system-wide Unix password change to verify success on all hosts.

googleVis R package for creating google charts in R

SQL Server:

Execute a data-driven SSRS subscription from SSIS to archive a report

The Bleeding Edge Versus N Minus One

Could you help with some research for Redgate‘s website?

SQL Server Integration Services (SSIS) is a fast and reliable way of importing and exporting data, but it can be tricky to learn, initially.

Simulating SQL Server Disaster Recovery Drills

MySQL:

Column Level Privileges in MySQL

Rescuing a crashed pt-online-schema-change with pt-archiver

Docker presents new levels of portability and ease of use when it comes to deploying systems.

Planets9s – MySQL on Docker: Building the Container Images, Monitoring MongoDB and more

MySQL Password Security Changes for PHP Developers