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

Posted in: Log Buffer, Technical Track

This Log Buffer Edition covers Cloud, Oracle, PostgreSQL, and MySQL.

Cloud:

New – Amazon CloudWatch Agent with AWS Systems Manager Integration – Unified Metrics & Log Collection for Linux & Windows

AWS Contributes to Milestone 1.0 Release and Adds Model Serving Capability for Apache MXNet

Well-Architected Lens: Focus on Specific Workload Types

On Architecture and the State of the Art

What is OCR? and How can a Beginner Implement it using Azure Cognitive Services?

Oracle:

asmcmd “connected to an idle instance” – not

oratop with TFA 12.2.1.3.0

FREE, Trial access to Oracle Licensing training portal?

Order of Predicate Execution #2

Oracle Traffic Director 12.2.1.3.0 in Docker

PostgreSQL:

Thanks to Jeremy Schneider.

First of all, two “seasonal” articles.

Robert Treat published an article on Dec 6 for the SysAdvent blog called “sysadmins – the evolution of a role amidst revolutionary hype.” For anyone who’s been following the “DBA 2.0” discussion in the Oracle community, this article reveals that the discussion is not limited to databases.

Redpill Linpro is doing their own SysAdvent series of blog posts too and Knut Ingvald Dietzel published an articled on Dec 8 called “Reduce disk bloat in PostgreSQL”. It gives a nice overview of the pg_repack utility, although I wish they’d discussed “freeze max age” instead of just the sweeping blanket indictment that VACUUM is not sufficient.

Second, two articles that will remind you about why you love SQL.

Markus Winand published an article on Dec 5 about an under-appreciated feature of the SQL language standard. The article is called “NULL-Aware Comparison: is [not] distinct from”

Alex Yeskov published an article on Dec 7 called “SQL Window Functions Tutorial for Business Analysis” and it’s a really great step-by-step
practical introduction to another under-appreciated and extraordinary feature of SQL!

Third, two articles that people were talking about. Both by the same author… I guess Matt Asay knows how to make a splash!

On Dec 6 at TechRepublic Matt published “There’s one big reason that Postgres can’t kill Oracle, and it’s not the technology”

On Dec 7 at InfoWorld Matt published “Why old-school PostgreSQL is so hip again”

And regarding that second article, Matt also got a good twitter discussion going.

MySQL:

The Tarantool SQL Alpha

Percona Server for MySQL 5.7.20-18 Is Now Available

Demystifying Sequence Numbers (seqno) in Percona XtraDB Cluster

Analytical Replication Performance from MySQL to Vertica on MemCloud

Slack & Pagerduty Integration with Monyog v8.4.0

Atomic compound statements

email

Author

Want to talk with an expert? Schedule a call with our team to get the conversation started.

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 *