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 " ...

Oracle GoldenGate microservices architecture - first try.

Three or four months ago Oracle released a new 12.3 version of the Oracle GoldenGate (OGG) software. The release did ...

Oracle 12.2 ASM filter driver installation

Recently I needed to install Oracle 12.2 with the ASM Filter Driver for some research on an upcoming presentation. With ...

Updating Elasticsearch indexes with Spark

With the extensive adoption of Elasticsearch as a search and analytics engine, more often we build data pipelines that ...

MySQL 5.7 Multi-threads replication operation tips

With support of multi-threads replication starting from MySQL 5.7, the operations on slave are slightly different from ...

Using Kerberos configuration manager to resolve Microsoft SQL server SPN issues

Identifying SPN registration and authentication failures It’s not uncommon to have authentication issues with Microsoft ...

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 ...

SQL Server on Linux – Configuration (Ubuntu)

Following on from my previous post where we installed SQL Server with the default configuration this article goes into ...

MySQL log rotation

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

Oracle’s Database Security Assessment Tool (DBSAT) Version 2 (2.0.1)

Background Oracle recently released a new version of their Database Security Assessment Tool (DBSAT) - version 2.0.1. ...

gh-ost with Amazon RDS / Aurora

Doing online schema changes in a managed database environment is not as straight-forward as one may think. Using gh-ost ...

Improve Oracle performance with ASM filter driver

Context Sometimes the results found in performance testing can be a bit of a surprise. I have recently been preparing ...

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 ...

The data platform in the age of serverless architecture

“The transformation of the superstructure, which takes place far more slowly than that of the substructure, has taken ...

Exporting custom metrics to influxdb

In the TICK stack (Telegraf, InfluxDB, Chronograf, Kapacitor) from InfluxData, Telegraf serves as the crucial "T"—the ...

Cleaning up PID files when Oracle GRID/RAC upgrades and patches fail

Introduction: Unfortunately is it not all that unusual for a patch or upgrade to Oracle Grid or RAC to fail, requiring ...

CPU utilization is not a useful metric

Once upon a time CPU utilization was quite a useful metric. Following are the output of several tools that provide CPU ...

How to display database statistics for all objects used in a SQL statement

When my current task is to optimize a particular SQL statement, I find it quite useful if I can determine if the ...

Cosmos DB indexing fundamentals – SQL on the edge episode 15

As Microsoft's premier NoSQL cloud offering, Cosmos DB offers some interesting design decisions and trade-offs that are ...

Log rotation for Oracle database

Most of you may already know how to configure the log rotation for your database alert log or the listener log etc,. As ...

How Linux Hugepages work to improve Oracle performance

This post is not intended to be an in-depth discussion of how Linux Hugepages work, but rather just a cursory ...

Backup and data streaming with xbstream, tar, socat, and netcat

Comparing Xtrabackup Streaming Methods: XBSTREAM vs. TAR On April 4th 2012 Xtrabackup 2.0 was released in to GA by ...

Database migration using Apache NiFi

Introduction Apache NiFi is a powerful tool for data migration. It provides an easy to use interface to connect to a ...

A look at current "Infrastructure as Code" Trends

Unless you have been hiding under a rock, you have probably heard the term “Infrastructure as a Code” thrown around. ...

How to immediately kill ALL processes for a Unix user

Context On occasion I have found it necessary to immediately kill all processes for a particular user on a Linux or ...

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. ...