Use Liquibase to Manage Changes in Snowflake

Top Three Use Cases for Google Cloud Spanner

Since its launch in 2017, Google Cloud Spanner has built a reputation that’s very different from traditional databases. ...

My Top 10 to Tune In To at Google Cloud Next 21

Are you a developer wanting to integrate gamification for your colleagues’ reward strategy? Or a CEO focused on better ...

Statspack vs. AWR: Wrong number of SQL Executions

This post is about a Statspack anomaly I discovered while analyzing execution trends of a particular SQL on one of our ...

Making the Always On Availability Groups More Resilient to Transient Network Issues

More and more companies are adopting the Always On Availability Groups as their HA/DR architecture for the SQL Server ...

Python: Using Dataclasses to Model Your Data

Here at Pythian, we love our data. Our code is no exception (pun sort of intended), so I’ll be covering dataclasses in ...

RAC – Clusterware Intermittently Fails to Start

While working on a new Grid Infrastructure installation on Red Hat V8.4, we had some issues testing a new cluster: The ...

Part Five: Deploying High Availability Applications in Oracle Cloud Infrastructure— SSL Certificates and Load Balancer Setup

This is the fifth in a series of blog posts that covers setting up the load balancer for a high available setup of ...

Orchestrating dbt Pipelines With Google Cloud: Part 1

In my previous post I showed you how to use dbt to expedite data preparation tasks on Google BigQuery. This time, I’ll ...

Restoring a Dropped Oracle PDB Without a CDB Backup

Background I ran into a situation where we needed to restore just one dropped (and recreated) pluggable database (PDB) ...

How to Use DockerSlim to Reduce Image Sizes

Learn how to test the capabilities of docker-slim on Java and Python images and containerized Spring and Flask apps. If ...

Database Upgrade Fails With “unexpected error in validate_credentials”

This is a blog post about an issue that can occur during a database upgrade and produces a misleading error message. If ...

SQL server distributed availability group with forwarder in Microsoft Azure

Architecture diagram To create a distributed availability group, you need two availability groups (AG) each with its ...

SQL Server AlwaysOn Availability Groups on Google Kubernetes Engine

This tutorial shows you how to configure SQL Server AlwaysOn availability groups (AG) using DH2i DxEnterprise and ...

Oracle Scheduler Job is Not Running as Expected After Bouncing Databases

Background One of our clients had issues with their scheduler jobs in DEV and PROD databases and all scheduler jobs ...

Monitoring Azure Data Factory, Self Hosted IR and Pipelines

Architecture diagram For effective monitoring of ADF pipelines, we are going to use Log Analytics, Azure Monitor and ...

How to Send Custom Emails and Notifications In Azure Data Factory

If you’ve used Azure Data Factory (ADF), you’ve probably sent email alerts. But these don’t provide any clarity or ...

Migration and Upgrade from EC2 to RDS Using DBMS_FILE_TRANSFER

Performing a simple manual migration and upgrade from EC2 to RDS without using S3 Object Storage: Here I will give a ...

How to Resize Exadata Grid Disks Without an Outage

As you might know, each Exadata cell contains 12 physical disks with a fixed size. If you want to increase the ASM disk ...

Adding DML Parallelization to Oracle Jobs

Intro When investigating why an Oracle job is taking a long time to execute, normally the DBA will identify the DML ...

Five Vital Questions to Ask Before Planning an SAP Migration

Last year, SAP announced another extension to its support deadline for legacy systems, pushing it from 2025 to the end ...

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

This is the third in a series that covers the details to deploy a high-available setup of Oracle Enterprise Manager ...

EBS: Access the PDF Outputs After the Migration to AWS

During the Oracle E-Business Suite migrations from on-premise to AWS Cloud (similar to any cloning exercise), you may ...

Part Four: Deploying High Availability Applications in OCI—OEM 13.5 Setup

This is the fourth in a series of blog posts that covers the details to deploy a high available set up of Oracle ...