SQL Server High CPU Issue Caused by Implicit Conversion (nvarchar vs varchar)
Problem Overview Recently, we encountered a high CPU utilization issue on a SQL Server instance — even though only one small SELECT quer...
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.
How to upgrade MySQL from 8.0 to 8.4 ?
Dear all my DBA Friends its time to upgrade to 8.4 . Yes We are getting notification from all the cloud partners as well on the customer sid...
Read Full Database Guide
Oracle Standard Edition Log Shipping in Windows
In today’s always-on world, database downtime can cost businesses a fortune. Setting up a reliable Disaster Recovery (DR) solution ensures ...
Read Full Database GuideMySQL ERROR 1146 (42S02): Table 'datablogs.tbl_followup' doesn't exist
Had a some conversation with friend he is facing this issue for long back and unable to solve it . But i had an thought why we cant replicat...
Read Full Database GuideActive active replication in PostgreSQL
Lets deep into active active high availability solution on PostgreSQL Detailed Session on the Live Recording Session https://www.youtube.c...
Read Full Database Guide
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 consi...
Read Full Database Guide