Monday, April 19, 2021

How to Enable SSH Equivalency Between EC2 Instances

 If you want to login to a Linux instance from other Linux instance without password or without mentioning the key, then ssh equivalency is the solution. 

Thursday, April 15, 2021

Where to Put PostgreSQL in AWS

When it comes to putting PostgreSQL database in AWS, you are spoiled for choice. There are 3 ways to do that:

1) Install and configure PostgreSQL on EC2 instance.

2) Amazon RDS for PostgreSQL

3) Amazon Aurora for PostgreSQL

You can watch the whole video here.

Wednesday, March 17, 2021

One Reason to Run Oracle on Google Cloud Platform

There is one reason to run Oracle on Google Cloud Platform, one solid and compelling reason. It has nothing to do with cost, and it has nothing to do with performance.

Saturday, March 13, 2021

Compartments in OCI

 One of my favorite concepts in Oracle Cloud Infrastructure (OCI) is compartments. If you have worked in AWS, at first they may seem redundant and cumbersome, but contrary to that, they are quite useful and make things less cluttered. 

Wednesday, February 24, 2021

Solution of Nuget Provider Issue with PowerShell and AWS Tools

 On a AWS EC2 Windows 2012 server, my goal was to write some data to S3 bucket. I was using a small Powershell Script to copy the file to the S3 bucket. For that I needed to Install AWS Tools for Powershell and I used following command at Powershell prompt running as administrator:

Sunday, February 21, 2021

Boto3 Dynamodb TypeError: Float types are not supported. Use Decimal types instead

 I was trying to ram data into AWS dynamodb via Boto3 and the streaming failed due to following error:

  File "C:\Program Files\Python37\lib\site-packages\boto3\dynamodb\", line 102, in serialize

    dynamodb_type = self._get_dynamodb_type(value)

  File "C:\Program Files\Python37\lib\site-packages\boto3\dynamodb\", line 115, in _get_dynamodb_type

    elif self._is_number(value):

  File "C:\Program Files\Python37\lib\site-packages\boto3\dynamodb\", line 160, in _is_number

    'Float types are not supported. Use Decimal types instead.')

TypeError: Float types are not supported. Use Decimal types instead.

Friday, February 19, 2021

Main SQL Window Functions for Data Engineers in Cloud

 To become a data engineer in cloud requires to have a good grasp of SQL among various other things. SQL is the premier tool for interacting with data sets. At first it seems daunting to see all those SQL analytics functions, but if you start with a tiny dataset like in the examples below and understand how these functions work, then it all becomes very easy for large datasets of any volume.

Thursday, January 28, 2021

Docker Behind Proxy on CentOS - Solution to Many Issues

If you running docker behind proxy on CentOS and receiving timeout or network errors, then use below steps to configure proxy settings on your CentOS box where docker is installed and you are trying to build docker image:

Tuesday, January 5, 2021

Most Underappreciated AWS Service and Why

Who wants to mention in their resume that one of their operation task is to tag the cloud resources? Well I did and mentioned that one of the tools I used for that purpose was Tag Editor. Interviewer was surprised to learn that there was such a thing in AWS which allowed tagging multiple resource at once. I got the job due to this most under-appreciated and largely unknown service.

Monday, October 19, 2020

From DBA to DBI

Recently Pradeep Parmer at AWS had a blog post about transitioning from DBA to DBI or in other words from database administrator to database innovator. I wonder what exactly is the difference here as any DBA worth his or her salt is an innovator in itself.