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

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Oracle:

Compiling views: When the FORCE Fails You

Goldengate 12c Troubleshooting XAGENABLE

A performance Deep Dive into Tablespace Encryption

EBS Release 12 Certified with Safari 10 and MacOS Sierra 10.12

Oracle Database 12c (12.2.0.1.0) on VirtualBox

SQL Server:

A Single-Parameter Date Range in SQL Server Reporting Services

Generating Plots Automatically From PowerShell and SQL Server Using Gnuplot

Justify the Remote Access Requirement for Biztalk Log Shipping

Building Better Entity Framework Applications

Performing a Right and Comprehensive Age Calculation

MySQL:

Basics of MySQL Administration and Best Practices

Bonanza Cuts Load in Half with VividCortex

Experiments with MySQL 5.7’s Online Buffer Pool Resize

MySQL 8.0 Collations: The Devil is in the Details.

How to Encrypt MySQL Backups on S3