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

Posted in: Log Buffer, Technical Track

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

email

Author

Interested in working with Fahd? Schedule a tech call.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *