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

This Log Buffer Edition collects blog posts fromOracle, SQL Server and MySQL.

Oracle:

Over the past 12 months there has been an increase in the number of Machine Learning notebooks becoming available.

Gitora helps PL/SQL developers manage their source code in Git easily. It helps them lock database objects to prevent edits from other users regardless of the editor they use.

One of the little myths of Oracle appeared on the Oracle-L list server a few days ago – the one that says: “you don’t need a histogram on a single column unique/primary key”.

How to Calculate the Mean, Median, and Mode in Oracle

Oracle Enterprise Manager Cloud Control: Write Powerful Scripts with EMCLI

SQL Server:

PowerShell Solutions – Several tips for daily tasks

Bones of SQL – Grouping By User-Defined Calendar Periods

On Being Economical with the Truth

How to Start Big Data with Apache Spark

Memory/Storage Technology Hierarchy and SQL Server

MySQL:

MySQL removes the FRM (7 years after Drizzle did)

SHOW WARNINGS can stall your MySQL server if compressed protocol is used

MySQL 8.0: Making User Management DDLs Atomic

Database Security – MySQL Upgrade Instructions for Zero-day Exploit

Showing the hidden tables in MySQL 8 data dictionary