Part Three: Deploying High Available Applications in Oracle Cloud Infrastructure – Instance Clone and Linux Storage Appliance

person climbing into clouds

This is the third in a series that covers the details to deploy a high-available setup of Oracle Enterprise Manager 13.5 using Oracle Cloud Infrastructure’s resources. Recap This series demonstrates how to deploy a high-available installation of OEM 13.5 using…

Read More >

SQL Server Distributed Availability Group with Forwarder in Microsoft Azure

mysql queries

Architecture diagram Register the application with the name terraform. Leave all options as default. Add a secret that will be used as a password to authenticate terraform. Provide a description and expiry period for the secret. Copy the Secret ID…

Read More >

Monitoring Azure Data Factory, Self Hosted IR and Pipelines


Architecture diagram Azure Data Factory Analytics solution For monitoring and analyzing data factory pipelines, I recommend installing the Azure Data Factory Analytics solution from Azure Marketplace. This solution provides you a summary of the overall health of your Data Factory,…

Read More >

Methodology for Snowflake Role-Based Access Control

Justification Snowflake offers role-based access control (RBAC) as the mechanism to handle authorization of security principals (users, services, etc.) and grant or deny them access to different database objects and operations. A key piece of a successful Snowflake implementation is…

Read More >

Migration and Upgrade from EC2 to RDS Using DBMS_FILE_TRANSFER

code laptop

Performing a simple manual migration and upgrade from EC2 to RDS without using S3 Object Storage: Here I will give a brief example of how to import data from Oracle Database on-premises or VM in EC2 into an RDS instance…

Read More >

Caching Alternatives in Google Dataflow: Avoiding Quota Limits and Improving Performance

The problem When building data pipelines, it’s very common to require an external API call to enrich, validate or obfuscate data using external services. This might happen with streaming or batch pipeline. The situation is the same: call external services…

Read More >

Part Two: Deploying High Available Applications in Oracle Cloud Infrastructure: Application Machine

oracle cloud infrastructure

This is the second in a series of blog posts that covers the details to deploy a high available setup of Oracle Enterprise Manager 13.5 using Oracle Cloud Infrastructure’s resources. Recap This series will demonstrate how to deploy a high…

Read More >

Looking Back to Look Forward: Experts Share Cloud Service Trends for 2021

You’ve heard it before: The pandemic accelerated digital transformation. And indeed, organizations stood up temporary technology solutions and expanded cloud services virtually overnight. Organizations took extraordinary measures to ensure necessary employee support, uninterrupted services to customers, and that business kept…

Read More >

Automatic Generation of Daily AWR Report

I have recently received a requirement to provide a daily automatic AWR report, and it should be delivered to the DBA team’s inbox. It looks like an interesting requirement, so I completed this using my test database first, having the…

Read More >

DataOps – Liquibase to Manage Changes in Snowflake

What is this about? Well, as the title implies, I will show how to set up Liquibase to manage changes in Snowflake as part of a DataOps practice. Why? Because I am going deep-dive into DataOps around Snowflake and I’ve…

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