ADOP edition cleanup

Oracle e-Business Suite administrators have access to pretty extensive documentation regarding Patching procedures. In Oracle EBS 12.2 Oracle introduced ADOP patching method along with Oracle Database EBR (edition-based redefinition) feature that allows minimizing downtimes for patching activities. As with everything…

Read More >

How to deploy a Cockroach DB Cluster in GCP – Part I

CockroachDB is a distributed SQL Database that has been gaining popularity in the last years because of its features. It is easy to deploy, with strong consistency, designed for the cloud, it has distributed transactions and easy to scale. Not…

Read More >

Creating your Lean Canvas

In our previous post we discussed creating a data strategy storyboard. This first asset is important to align our executive and working teams on the measures and work tracks of our data strategy. Next, we explore the Lean Canvas (LC)…

Read More >

Amazon EFS Top-Talkers

Recently, I was helping a client with their AWS Elastic File Service (EFS), which is a managed NFSv4.1 service, with some additional connectivity and authentication capabilities. I was new to this client, so had little prior knowledge of their NFS…

Read More >

pt-online -schema corner case: When you don’t want to replicate your alter activities across the whole cluster.

Intro When we want to perform a heavy ALTER TABLE against  a several gigabytes table the options are quite a few but the one I tend to use the most is pt-online-schema-change (pt-osc). This tool is very mature and solid…

Read More >

Oracle DBMS_CLOUD package with AWS S3

The package DBMS_CLOUD was first introduced in the Autonomous Database to provide a simple way to interact with an object store from the database. It is now available for on-premise databases starting with 19.9c and 21c. It works with OCI,…

Read More >

MongoDB Backups and Point In Time Recovery – part 3

This is the third and final post in the series of blog posts for MongoDB replica set backups with Point In Time Recovery (PITR). This will be focused on restores, particularly details on PITR using the full and incremental backups….

Read More >

Interesting variations in outcome when cloning a CDB with a subset of PDBs in Oracle

Recently I was working on a client request where a CDB along with a subset of its PDBs had to be cloned to a new server for testing purposes. This post illustrates that in certain circumstances the outcome of this…

Read More >

Creating your Strategy Storyboard

In our previous post we explored how to inventory existing data assets as a baseline for understanding what assets we have available to influence our data strategy and accelerate its execution. This baseline allows us to quickly identify immediate use…

Read More >

Identifying Data to Accelerate our Data Strategy

We previously discussed the successful formula for creating and executing an organization’s data strategy. The process of developing a data strategy should be led by executives focused on transformation, go-to-market or data. While the technology teams should be part of…

Read More >
Page 1 of 39412345...10...Last Page »