Using LetsEncrypt Certs with Oracle E-Business suite

Oracle Database 18c schema only accounts

One nice new feature of Oracle Database 18c is that schemas can be created without a password. These are called " ...

Using AI for database administration automation - extracting useful information from log files

When talking about automation for Oracle Database Administration, besides automation of software installation and ...

Why column stores?

Introduction I’ve been working with data in many forms for my entire career. During this time, I have occasionally ...

SQL Server and Azure - hybrid partitioning - a low-cost solution to retain your data

It's already a fact: cloud is here to stay. As time goes by, we have a better understanding of how it really works as ...

Using Oracle Wallets and SEPS with Perl, JDBC, and ODBC

A few years ago I wrote a couple of popular blog articles on using Secure External Password Stores (SEPS) and ...

MySQL log rotation

Overview I find far too often that MySQL error and slow query logs are unaccounted for. Setting up log rotation helps ...

The case against auto increment in MySQL

Introduction In my travels to visit many customers over the last few years, I often see my customers creating many or ...

Lightweight transactions in Cassandra

Cassandra support for transactions Unlike commonly used relational database platforms, Cassandra does not support ACID ...

Cassandra use cases: when to use and when not to use Cassandra

Introduction I have a database server that has these features: High available by design. Can be globally distributed. ...