PostgreSQL Table Partition on AWS RDS

If we grow bigger in the business , seamlessly our customer and transaction data also increases . In the meantime performance needs to consider as well So in this case of bigger tables indexes will not help us to achieve good performance on peak times . Alternatively we have partitioning to split...

Deep dive into Babelfish Compass

        Wow !!! If suppose on the migration projects we need to more stuffs and things to convert when coming to procedures , functions and other database objects But AWS is providing good things to migrate with easy steps , Ha Ha ... Don't overthink still you need...

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 activities and events. It provides a mechanism to track and monitor user activities, system events, and changes made to the database. User Logins: Recording user login attempts and authentication information. Database Activities: Logging SQL statements ...

How to Automate MongoDB Database Backups in Linux

We have setup of One Primary with Multiple SecondaryEven if we configured highly available setup and backups , native backup are so special to take it and keep it somewhere in the cloud using the below script we can easily schedule backup in Linux environments  https://github.com/selvackp/MongoNativeBackup-/blob/main/mongo_dump.shexport PATH=/bin:/usr/bin:/usr/local/bin #Decalre Today...

Restore and Point in time Restore with Percona Backup of MongoDB on another instance

Its easy to recover MongoDB Backup using Percona Backup for MongoDBhttps://medium.com/@datablogs/restore-and-point-in-time-restore-with-percona-backup-of-mongodb-on-another-instance-4766f4468...

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 atleast two months validate our approach is smooth Yes its all running good as expected performance on the ETL loads and Processes Here are the major things...