How to tune long running Queries on Azure Synapse DW (Dedicated Pool) - Part 1
Three hours of long running pipeline is reduced to run in 35 Minutes when we given right kind of top bottom optimization like our Body !!! ...
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 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 GuideBackup 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