SQL Server Point in Time Recovery
Oooooouch !!! I have deleted critical data in the ledger table !!! When we ran delete or drop Script on any database without double check ,...
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.
Backup and Restore in Same SQL Server RDS
Important Drawback and Solutions !!! https://blog.powerupcloud.com/backup-and-restore-in-same-sql-server-rds-3e667622f7ff
Read Full Database Guide
MongoDB 4.4.13 : Here to SRV you with easier replica set connections
We love MongoDB for extraordinary features as per business perspective Lets come to our Blog Discussion , Only in PaaS Environments we have...
Read Full Database Guide
Oracle REST Data Services (ORDS) : Upgrade ORDS from 5.1.4 to 19.4
We have upgraded Oracle Apex in the previous blog and next have to plan for below things Apex static images update for upgraded version O...
Read Full Database Guide
SQL Server Always On availability group cluster in the AWS Cloud
Microsoft gives HA features like a charm . Lower to higher deployment costs its giving many features as per business requirements . Replicat...
Read Full Database Guide
Redis to ElastiCache Migration in AWS
Comparing Redis , AWS ElastiCache giving multiple options to cache the data in cloud . Its enhanced with two ways of Access control opt...
Read Full Database Guide