A practical SQL Server SUSPECT database recovery case involving error 926, EMERGENCY mode, DBCC CHECKDB repair, transaction log rebuild, and recovery to ONLINE MULTI_USER state.
Overview This article documents a Microsoft Access database design for a small academic management system. The goal is to manage departments, majors, classes, students, teachers, courses, course selections,…
A practical MySQL 8.0 database migration case from CentOS Docker to Ubuntu, covering mysqldump export, scp transfer, character set validation, and import verification.
A practical MySQL 8.0 production deployment case on Linux, covering binary installation, my.cnf configuration, primary-replica replication, Keepalived VIP failover, and mysqldump backup restore.
A practical SQL Server 2022 cross-network database synchronization case using transactional replication and push subscription, covering Publisher, Distributor, Subscriber setup, agent configuration, and validation.
Overview This article documents a troubleshooting case for SQL Server Express remote connection and login failures. The environment involved SQL Server Express, SQL Server Management Studio, a C#…
Overview This article documents a troubleshooting case for a MariaDB 10.2 instance installed under a custom path on Linux. The database service had startup and access problems. One…
Overview This article documents a troubleshooting case for Oracle listener connection errors on Windows Server 2008 R2. The environment involved Oracle 9i, PL/SQL Developer, and a BSEAP 5.0…
Overview This article documents a practical Oracle Database 11g import case on Windows. The goal was to import a database dump file named YONBIPV3-1028.DMP into a local Oracle…
Troubleshooting a DBeaver SQL Syntax Error Near UNION When Querying SAP Tables Overview This article documents a troubleshooting case where a SQL query against SAP-related tables failed in…