Oracle RDS Audit log enable
Oracle Audit Log : Oracle Audit Log refers to the feature in Oracle Database that records and stores information about various database act...
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.
How to Automate MongoDB Database Backups in Linux
We have setup of One Primary with Multiple Secondary Even if we configured highly available setup and backups , native backup are so specia...
Read Full Database GuideRestore and Point in time Restore with Percona Backup of MongoDB on another instance
Its easy to recover MongoDB Backup using Percona Backup for MongoDB https://medium.com/@datablogs/restore-and-point-in-time-restore-with-per...
Read Full Database Guide
How to tune long running Queries on Azure Synapse DW (Dedicated Pool) - Part 2
Its took little long time to derive our approach tunning on azure data factory with Azure Synapse why because we need to run the system atle...
Read Full Database GuideUpdate Backup and Restore in Same SQL Server RDS
Update of Previous post , As mentioned in below blog , past years we cant restore database into same SQL Server RDS https://medium.com/@yog...
Read Full Database GuideCross region RDS replication with customized parameter group
Replicate with customized parameter group .. https://medium.com/@datablogs/cross-region-rds-replication-with-customized-parameter-group-fc29...
Read Full Database Guide