SQL / Databases
SQL Server, MySQL, MariaDB and PostgreSQL administration and troubleshooting: connections, performance, blocking, backups, logs and storage
SQL / Databases Center
SQL Server, MySQL and PostgreSQL diagnostics for connections, authentication, blocking, performance, backups, logs and storage.
ResourceWordPress Center
WordPress diagnostic: critical error, 500, database, permalinks, SMTP, cron, plugins, Scriptor,194, SSL and performance
Knowledge hubHome
Free tools, procedures, diagnostics, scripts, dictionary and practical resources for IT technicians, system administrators and SMEs
IT dictionarySQL Server Always On Availability Groups
SQL Server Always On availability groups replicate databases across instances for high availability and disaster recovery.
IT dictionarySQL Server Failover Cluster Instance
A SQL Server failover cluster instance provides instance-level availability using Windows clustering and shared storage.
IT dictionaryVector Database
A vector database stores numerical embeddings and supports similarity searches for semantic retrieval and AI applications.
IT dictionaryVector Database AI
A vector database indexes numerical embeddings to retrieve content by semantic similarity.
IT dictionaryKnown Error Database (KEDB)
A Known Error Database records documented problems, their symptoms, and available workarounds for use during incident resolution.
IT dictionaryVSS
The Windows mechanism that allows to create consistent shots while applications continue to work.
ResourceHow to diagnose MySQL error 1213 deadlocks
This BOAI guide provides a structured method for diagnosing mysql 1213-2
ResourceMySQL 1213 — Deadlock found
Transactions are blocking each other and one has to be cancelled
ResourceMySQL 1045 — Access denied for user
MySQL or MariaDB refuses l, authentication of, user
ResourceMySQL 2002 — Can’t connect to local server
The client cannot reach the local MySQL server
ResourceMySQL 1205 — Lock wait timeout exceeded
One transaction is waiting too long for a lock held by another transaction
ResourceBDD Connection Facility — Error when establishing the connection to the database
WordPress no longer manages to connect to MySQL or MariaDB
ResourceWordPress — Error establishing a database connection
WordPress does not manage to connect to its database
ProcedureDiagnose a VSS backup error
Control the writers, services, snapshots space and events before restarting Acronis or Veeam
ProcedureSecure a compromised WordPress site
Keep it up, incident, preserve the evidence, clean the files and prevent a new Emma
ProcedureChange the password of a Windows service account
Controlled rotation procedure of an account used by several services or tasks
ProcedureOrganize a backup restore test
Test a real backup restore in an isolated target, validate the application and compare recovery time and recovered data with RTO and RPO.
ProcedureEnable DHCP Snooping on a switch
Controlled procedure to activate dhcp snooping on an switch
ProcedureDiagnose an inaccessible TCP port
Check the network path, l, service listening and firewalls when an application does not join a server
ResourceNetwork ports — memo form
Common TCP and UDP ports, their services and practical checks for network administration.
Knowledge hubWindows Server
Windows Server diagnostic and administration: services, RDP, storage, VSS, Event ID, Power Shell, certificates and updates
Knowledge hubLinux
Linux commands, diagnostics and resources for Debian, Ubuntu, Bash, systemd, SSH, files, network, logs and backups
Knowledge hubBackup & Disaster Recovery
Backup, restoration and resumption of activity: Veeam, Acronis, VSS, RPO, RTO, immutability, replication and restoration tests.
Knowledge hubStorage / NAS / SAN
Company storage: Rsid, SMART, NAS, SMB/NFS, iSCSI, MPIO, LUN, SAN, ZFS, LVM, PORTOS, capacity and performance