How to perform groupby using Python Itertools
Itertools is a powerful module and is part of python standard library. It provides a set of fast and memory efficient functions. You can learn more about them by referring…
Read Full RecipeAuthor: Amit Bansal
Experienced professional with 16 years of expertise in database technologies. In-depth knowledge of designing and implementation of Disaster Recovery / HA solutions, Database Migrations , performance tuning and creating technical solutions.
Skills: Oracle,MySQL, PostgreSQL, Aurora, AWS, Redshift, Hadoop (Cloudera) , Elasticsearch, Python
Using SSL to securely connect to Amazon Redshift Cluster
Amazon Redshift is fully managed Cloud Datawarehouse from AWS for running analytic workloads. Lot of customers have requirements to encrypt data in transit as part of security guidelines. Redshift provides…
Read Full Recipe
AWS Glue Python shell job timeout with custom Libraries
This is short post on Timeout errors faced using custom libraries with AWS Glue Python shell job. I referred the steps listed in AWS docs to create a custom library…
Read Full Recipe
Identifying PostgreSQL Bloat and fixing it without downtime
MVCC (Multi-Version Concurrency Control) feature allows databases to provide concurrent access to data. This allows each SQL statement to see a snapshot of data as it was some time ago,…
Read Full Recipe
Speeding up Initial data load for Oracle to PostgreSQL using Goldengate and copy command
Oracle Goldengate supports Oracle to PostgreSQL migrations by supporting PostgreSQL as a target database, though reverse migration i.e PostgreSQL to Oracle is not supported. One of the key aspect of…
Read Full Recipe
Saving AWS RDS and Redshift Billing Costs using Reserved Instances
In this post, we would understand what are reserved instances, when do you need them and various ways to monitor them in your environment. As more enterprises are embracing…
Read Full Recipe