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 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.
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/@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 GuideORA-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-inact...
Read Full Database Guide
How do I troubleshoot the AWS Glue error "VPC S3 endpoint validation failed for SubnetId"?
If you are newbie to AWS Glue its really difficult to run the Crawlers without these failures , Below are basic steps you need to make sure ...
Read Full Database Guide
Migrate and Sync RDS PostgreSQL to Amazon Redshift Serverless using AWS Glue
Always customer prefers cost less solutions to run the business . To help them their business and the requirements we also needs to provide ...
Read Full Database Guide