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

Tackling time troubles - how to use dates correctly in Oracle

For the Oracle Code series of events I have delivered an older but still relevant talk called "Tackling Time Troubles." ...

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

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

Oracle parallel query hints - part 3: PX_JOIN_FILTER

In part one of this series on Oracle Parallel Query Hints, I looked at PQ_DISTRIBUTE, and part two was about ...

Why column stores?

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

Spark UDF memoization

Memoization is a powerful technique that allows you to improve performance of repeatable computations. Although it ...

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

Oracle 18c Non-CDB databases in the Oracle Database Cloud Service (ODBCS)

Oracle is implementing a cloud first approach and hence the newest releases such as Oracle Database 18c first appear in ...

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 parallel query hints. A reference series part 2: PQ_REPLICATE

The Mechanics of PQ_REPLICATE in Oracle 12.2 In part 1 of this series, we talked about the basic mechanics of the ...

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

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

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

Debugging CBQT OR expansion with 10053 trace

I had been working with a client to add a little bit of functionality to an analytical view that we had been running ...

Google Cloud Platform quick tip: Cloud Shell boost mode for Docker development

I explained in an earlier post how I am using GCP's Cloud Shell for all of my command-line needs all the time. Whenever ...

Lightweight transactions in Cassandra

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

Graceful master switchover with ProxySQL and Orchestrator

Introduction One of the things I like about Continuent Tungsten is how Tungsten Connector can hold traffic while a ...

Azure Cloud Shell - cloud what?

What is Azure's Cloud Shell? Azure Cloud Shell is a browser-based, interactive shell that comes in two flavors: ...

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

Infographic: five ways to make analytics for everyone

It’s not a stretch to say that data is taking over the world. You can see the signs everywhere, from news stories ...