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

This Log Buffer Edition gathers Oracle, SQL Server and MySQL blog posts for the week.

Oracle:

Tracefile Automation – Simplify Your Troubleshooting Tasks

Options For Pre-EM13c Target Software and Non-Supported OS in EM13c

BI Publisher will not start (using emctl oms start and emctl oms start -bip_only)

Why you might want to think twice about using INSERT ALL.

SQL Server:

Checkpoint process for memory-optimized tables in SQL 2016 and implications on the log

Getting Started with the Query Store Feature in SQL Server 2016

Diagnosing parallelism-related latching

How to deploy and execute an SSIS package from the SSISDB catalog

Paul White discusses the internals of SQL Server’s WITH ENCRYPTION clause, and explains why it is not as safe as you might think.

MySQL:

Understanding MySQL Fabric Faulty Server Detection

This blog post  analyzed the behavior of different solutions using synchronous replication in AWS environment.

Planets9s – ClusterControl 1.3 webinar replay, Polyglot Persistence Meetups, and more!

Why Use Slow Query Logs When There’s VividCortex?

Why you should take care of MySQL data types