Matheus OliveirainNAZAR[ SQL Performance Killers] — Individual inserts vs. Bulk inserts.An important part of my daily work is to help developers, database administrators, devops, sysadmins and project managers to identify…Nov 7, 2023Nov 7, 2023
Matheus OliveirainNAZARAzure Database for PostgreSQL Single Server intermittent restart and recovery due to undocumented…If you are experiencing Azure Database for PostgreSQL intermittent restart and recovery, it may be due to internal Log file reaching 1 GB.Jul 13, 2020Jul 13, 2020
Matheus OliveirainNAZARMigrating from Oracle RAC to AWS RDS with 15 minutes downtime.A few days ago, we were challenged to reduce the database downtime for an Oracle RAC (on-premisses) migration to AWS RDS. Other teams had…Oct 28, 2019Oct 28, 2019
Matheus OliveirainNAZAROracle RDS Read Replica with DMS CDC.Even though Read Replica (RR) feature is not natively available for Amazon RDS for Oracle, you can implement it using Database Migration…Jan 23, 2019Jan 23, 2019
Matheus OliveirainNAZAR[ SQL performance Killers ] — STALE STATISTICSAn important part of my daily work is to help developers, database administrators, devops, sysadmins and project managers to identify…Aug 21, 2018Aug 21, 2018
Matheus OliveirainNAZAR[ SQL performance Killers ] — VIEWSAn important part of my daily work is to help developers, database administrators, devops, sysadmins and project managers to identify…Jul 30, 2018Jul 30, 2018
Matheus OliveirainNAZAR[ SQL performance Killers ] — Implicit ConversionsAn important part of my daily work is to help developers, database administrators, devops, sysadmins and project managers to identify…Jul 23, 2018Jul 23, 2018
Matheus OliveirainNAZAR[ SQL performance Killers ] — IN vs EXISTSAn important part of my daily work is to help developers, database administrators, devops, sysadmins and project managers to identify…Jul 13, 2018Jul 13, 2018
Matheus OliveirainNAZAR[ SQL performance Killers ] - Functions to column dataAn important part of my daily work is to help developers, database administrators, devops, sysadmins and project managers to identify…Jul 3, 2018Jul 3, 2018