Optimizing CPU cores and threads for Oracle on AWS

A Smarter Way to Scale: Custom CPU Options on AWS About a couple of weeks ago, AWS introduced a new option to manage ...

Sending email from Oracle with utl_smtp via Amazon Simple Email Service (SES)

Note: This article was updated following Symantec Trust issues earlier in 2018.

MySQL on AWS: RDS vs EC2

When moving your MySQL instances to AWS, you would probably have to deal with this decision. This article will ...

Ansible and AWS automation

Overview The goal was to create and manage a MySQL RDS instance and learn how to control AWS resources by using ...

How to Read Oracle Traces from SQL*Plus

Situation Let's say you need to read trace files from Amazon Relational Database Service (RDS). How do you do it?

Locating most current record using ROW_NUMBER() vs. Index Full Scan (Min/Max)

Very often when reading data, we need to locate the most current record for a set of conditions. One typical example is ...

Migrate Postgres Database from EC2 instance to RDS using AWS DMS (Data Migration Services)

In this post, we will explore one approach to Migrate PostgreSQL DB on EC2 instance to RDS instance using AWS Data ...

AWS DMS tips for Oracle migrations

Investigating IO performance on Amazon EC2

I published a blog post called " Investigating IO Performance on Amazon RDS for Oracle" recently, and soon after ...

Backup Oracle databases to AWS S3

There are different options for backing up Oracle databases to Cloud, but using Oracle Secure Backup module to take ...

Data modeling for cloud DW

Intro In this blog post, I would like to share some options that you can consider to model your cloud DW for better ...

Enable X11 forwarding after Sudo SSH session for AWS EC2 Linux instance

Challenges Working with a secure environment presents some challenges and this post will demonstrate how to overcome ...

AWS's Top 5 Commands: ALTER SYSTEM and Managing SYS Objects in RDS

Essential administrative commands for Amazon RDS for Oracle Navigating administrative limitations in RDS We often ...

Airflow Scheduler: the very basics

Apache Airflow is a great tool for scheduling jobs. It has a nice UI out of the box. It allows you to create a directed ...

Examining the lifecycle of tombstones in Apache Cassandra

This post is the first part of a series of blog posts regarding the lifecycle and management of tombstones. Deleting ...

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