Monday, July 6, 2020

ORA-1652

If you are wondering what might be the reasons to have ORA-1652, then you can use the following query to get the idea:

Wednesday, June 17, 2020

FiveTran Auth Error in Connecting Oracle RDS Database

Fivetran toolpromises to reduce technical debt with scalable connectors managed from source to destination. Model your business logic in any destination using SQL, the industry standard. Change data capture delivers incremental updates for all your sources. Built with analysts in mind, our connectors allow data teams to concentrate on asking the right questions.

Friday, May 22, 2020

SSIS in AWS RDS

Whenever migrating a SQL Server database from on-prem to AWS Cloud, my first preference is always to move it to AWS RDS, the managed database service. So whenever a client asks me to migrate an on-prem SQL Server database, my first question is:

Thursday, May 7, 2020

Cloud Vanity: A Weekly Carnival of AWS, GCP and Azure - Edition 1

This is the first edition of this weekly collection about what is happening in the rapidly evolving cloud sphere. This will mainly focus on news, blogs, articles, tidbits, and views from AWS, Azure and GCP but will also include other Cloud providers from time to time. Enjoy Reading!!!


Thursday, April 16, 2020

Converged Oracle

Its very interesting to note down that where some database providers especially in the cloud are going about diverging the database offering for various use cases, whereas Oracle is talking about converged or unified databases for various on-prem and Cloud use-cases.

Thursday, April 9, 2020

Kubernetes Taints/Tolerations and Node Affinity for Dummies


In order to guarantee which pod goes to which node in a Kubernetes cluster, the concept of Taints/Tolerations and Node Affinity is used. With Taints/Tolerations, we taint a node with a specific label, and then add those labels as toleration in the pod manifest to ensure that if a pod doesn't have that toleration, it won't be scheduled on that tainted node. In order to ensure that, this tolerated pod only goes to tainted node, we also add an affinity within the pod manifest.

Wednesday, April 8, 2020

BigQuery Materialized Views and Oracle Materialized Views

One of the common ways of one-to-many replication setups in Oracle databases involve, on high level, having one master transaction database which holds the transactions, then a mview log is created on that table.

Tuesday, March 31, 2020

How To: Reduce Cloud Bill in Half for Any Cloud Provider

“But you said, we would be only paying what we use then how come my Cloud bill is way more than my on-prem cost?”
Managements are now asking above question from Cloud Operations team all across the globe as recession looms, revenues drop, businesses almost to a standstill, budgets shrunk and economic outlook becoming grimmer by the day.

Friday, March 27, 2020

Basic DynamoDB Data Modelling




The key differentiator between a NoSQL database like AWS Dynamodb and a relational database like Oracle is of the way data is modelled. In a relational model; data is normalized, de-duplicated and relationships are established between entities. In a NoSQL database like Dynamodb, data can be duplicated and entities can be fused together. This is done to facilitate scalability which is hallmark of today's hyper-scale cloud based applications.

Saturday, March 14, 2020

Why on Earth Would You Manage Your Own Kubernetes Control Plane?

The word Kubernetes comes from the Greek word 'Helmsman'. A helmsman is the person who navigates the ship ensuring the steady and desired course. Whether the seas are turbulent or not, or if some component of ship fails, or the load of containers on ship needs to be re-balanced; its the job of Helmsman or Kubernetes to make sure ship maintains its desired state until it reaches its destination.