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…
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…
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…
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,…
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…
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…
- 1
- 2
- 3
- 4
- …
- 27
- Go to the next page