Dhiraj Bhamare·Jun 26Migrating from Redshift Python UDFs to Lambda UDFs: What Changes, What Breaks, and What to Do About…Amazon Redshift users who relied on Python UDFs are now being pushed toward Lambda UDFs as the long-term replacement. On paper, that sounds…
Dhiraj Bhamare·May 29Create Aurora PostgreSQL Serverless in Seconds with Express ConfigurationAmazon Aurora PostgreSQL now offers a Create with express configuration experience that lets you provision a serverless database in just a…
Dhiraj Bhamare·May 27Troubleshooting a Redshift DROP USER Failure Caused by Datashare PrivilegesAmazon Redshift user cleanup is usually straightforward — until it is not. A particularly confusing scenario arises when a user appears to…
Dhiraj Bhamare·May 27Understanding AWS DMS “cdcPosition = null” During CDC Task ResumeAWS Database Migration Service (DMS) logs can sometimes surface messages that appear more alarming than they actually are. One such example…
Dhiraj Bhamare·Mar 19Building a Cost‑Efficient Aurora Cluster: Provisioned Writer + Serverless v2 Reader PatternBalancing consistent performance with cost efficiency remains one of the toughest challenges in modern cloud database design. Many systems…
Dhiraj Bhamare·Mar 12Understanding Unexpected Aurora SnapshotExportToS3 Charges — Zero-ETL IntegrationUnexpected AWS charges can be difficult to trace, especially when the billing usage does not directly correspond to visible console…
Dhiraj Bhamare·Jan 21When an Aurora PostgreSQL Major Upgrade Fails: A Lesson from a Hidden ViewRecently, I attempted an in-place major version upgrade of an Amazon Aurora PostgreSQL cluster from 15.x to 17.x. The upgrade initially…
Dhiraj Bhamare·Nov 25, 2025Have You Noticed the New “Upgrade Rollout Order” in the RDS Console?If you work with Amazon RDS or Aurora, you may have spotted a new option in the console called Upgrade rollout order. It showed up quietly…
Dhiraj Bhamare·Oct 27, 2025Impact of Reducing idle_in_transaction_session_timeout on RDS/Aurora PostgreSQL when using AWS DMSGoal: Reduce idle_in_transaction_session_timeout from the default (24 hours) to a shorter value. For example, 1 hour or less.
Dhiraj Bhamare·Jul 22, 2025Linked Servers on Amazon RDS for SQL Server: What’s New, What’s Supported, and What’s NotAmazon recently announced the addition of support for AWS RDS SQL Server with linked servers using Oracle OLEDB Driver version 21.16. This…