This Log Buffer Edition collects blog posts fromOracle, SQL Server and MySQL.
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
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 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