Building a Lakehouse on a Budget: Apache Iceberg + AWS Glue + EMR Serverless
If you've ever looked at your AWS bill and wondered whether "Iceberg" was some expensive managed service you forgot to turn of...
Read Full Database GuideDatabase, Cloud and Migration Guides
Practical database guides, cloud migration notes and data engineering fixes for Oracle, SQL Server, MySQL, PostgreSQL, MongoDB, Percona, AWS, Azure, GCP, DigitalOcean and on-premises platforms.
Database OpsBackup, restore, HA/DR, security, monitoring, tuning and troubleshooting for production systems.
Cloud PlatformsHands-on notes for RDS, DMS, Glue, Azure SQL, Synapse, Data Factory and managed data services.
Migration GuidesPlanning, validation, replication, zero-downtime cutovers and post-migration checks.
SQL Server on Linux in AWS EC2 – Installation, Password Configuration, Cost Benefits, and Limitations
Introduction As part of a learning and testing initiative, I explored deploying Microsoft SQL Server 2022 on Ubuntu Linux in AWS EC2 . The...
Read Full Database Guide
MongoDB Relational Migrator - Simplifying PostgreSQL to MongoDB Migration
Introduction Migrating from relational databases to NoSQL databases has traditionally been a challenging task. Unlike relational databases...
Read Full Database Guide