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...

Update 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/@yogitha.o/backup-and-restore-in-same-sql-server-rds-3e667622f7ffBut now you can able to restore without any issues from recent releases of SQL Server RDS&nb...

Cross region RDS replication with customized parameter group

Replicate with customized parameter group ..https://medium.com/@datablogs/cross-region-rds-replication-with-customized-parameter-group-fc29bf991...

ORA-01940 cannot drop a user that is currently connected

Its Easy to achieve it in easy method ,https://datablogs.medium.com/ora-01940-cannot-drop-a-user-that-is-currently-connected-and-kill-inactive-sessions-in-oracle-c009fbbbc...