Fraud Blocker

Oracle LTRIM function.

The Oracle/PLSQL LTRIM function removes all specified characters from the left side of the string….

Continue Reading

NOTIFY/LISTEN: POSTGRESQL AUTOMATIC CLIENT NOTIFICATION 

Users can listen in on database activity using the LISTEN/NOTIFY capability. It is still one of PostgreSQL’s most used features despite being one of t…

Continue Reading

Why are my postgresql update times getting less timely?

A customer recently questioned me about why a bulk load into a PostgreSQL table continued slowing down over time. They saw that the trigger on the tab…

Continue Reading

Oracle RTRIM function.

The Oracle/PLSQL RTRIM function removes all specified characters from the right side of the string….

Continue Reading

Oracle SUBSTR function.

The Oracle/PLSQL SUBSTR function allows extracting a substring from a string….

Continue Reading

🎉 Thank you for subscribing!

You're now on the list for database FinOps strategies and performance insights.