Log Buffer #518: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers from various blogs covering the technologies and news of Oracle, SQL Server and MySQL.

Oracle:

Storage Server: datasets, snapshots and performance

A Different Cause for enq: TM – contention

ODA X6-2M – How to create your own ACFS file system

Oracle New Version Numbering

KBHS-00600: Internal Error, Arguments [1] [kbhshtCreateDataBucket] Error During Backup To Oracle Cloud

SQL Server:

Using Database Master Keys in SQL Server

SQL Server Management Studio Tips

Sqlcmd is not just a script execution tool. It gives us access to internal variables and commands that we can use to automate code execution.

Additional SERVERPROPERTY properties in SQL Server

Simple SQL: Random Thoughts

My SQL:

The danger of no Primary Key when replicating in RBR (and a partial protection with MariaDB 10.1)

What’s New With MySQL Replication in MySQL 8.0

Docker Secrets and MySQL Password Management

More Details about InnoDB Compression Levels (innodb_compression_level)

Extending the Power of MariaDB ColumnStore with User Defined Functions

Interested in working with Fahd? Schedule a tech call.