Over the last month, ACEs from around the globe shared insights and knowledge on their blog posts or podcasts and videos. Out of over 300 blogs, podcasts and videos we have selected some of them for you to enjoy – so we invite you to browse the list below and discover more on APEX, Database, MySQL / SQL, OCI and more.
APEX
Alli Pierre Yotti 
: As an #orclapex developer, it’s important to stay connected with the community
Amod Joshi 
: How to build a custom Reset Password feature in Oracle APEX
Eddie Molina : Por qué no se actualizan los cambios?
Louis Moreaux: How to implement a dynamic Authorization Scheme in Oracle APEX?
Paulo Künzel : What can you do with APEX_COLLECTION
Rodrigo Mesquita : Customize APEX app colors
Database
Amy Simpson-Grange : Oracle Integration: Connecting to Autonomous Database OOTB using Adapters
Bobby Curtis : Identifying Predefined Administrative Accounts in Autonomous Database or any other Oracle database
Dilli Maharjan : How to change ASMSNMP user password in Oracle RAC Database
Himanshu Singh : Deploy a Oracle Database in OCI from OCI Market Place
Lisandro Fernigrini : Long Term Backups en Autonomous Database
Marcin Przepiorowski : Source and deployment control with Oracle databases — part 1 and part 2
Noriyoshi Shinoda :長時間実行される処理の完了時間を予測する（Oracle Database 19c）
Richard Foote 
: Migrated Rows In Oracle Data Warehouse Autonomous Databases (“Sit Down. Stand Up.”)
OCI
Luc Demanche : OCI Observability & Management using Database Management — Part 1
Lucas Jellema : Extending Steampipe OCI Plugin with an OCI resource type table
Mahmoud Rabie : Moving a VM from one OCI region to another
Marc Wagner : Zero Downtime Migration (ZDM) to Oracle Cloud Infrastructure (OCI)
Timo Herwix : How to create a Clone of your Always Free ADB using OCI REST APIs
Tércio Costa : Alterando o hostname na OCI
MySQL / SQL
Clarisa Maman Orfali : ¿Conoces la herramienta Quick SQL?
Christian Pfundtner : Performance by Example (für DBAs): SQL Patch(ing)
David Kurtz : Performance Tuning with the PL/SQL Performance Profilers
Deepak Vohra : How to Keep SQL Queries Agile
Kazuhiro Takahashi : SQLプロファイルによるリテラルSQLのチューニング [オプティマイザ]
Hao Xu: MySQL8.0.28命中[ERROR][MY-013183]报错案例分析
Jan Květina : SQL Developer tips 1/3
Piet de Visser: A few tips, as you dive into SQL
Ronald Francisco Vargas Quesada : Cómo hacer un despliegue de SQL SERVER en el OCI
Sean Stuber : Finding dates of holidays using PL/SQL
Yong Jing : MySQL 5.7 InnoDB Tablespace Encryption
EPM
Andrew Laferla : Profitability Patch Release – March 2023 (23.03)
Paul Lewis: Using Auto Predict with Inconsistent History
ERP
Dirk Blaurock : Journey into Cloud ERP am Beispiel Oracle Cloud ERP
Prateek Parasar : Oracle Cloud ERP and HCM FSM CSV Import for loading setup data
MORE
Amod Joshi : Extend EBS workflows using Oracle Business Event System
Amy Simpson-Grange & Jim Czuprynski : CSI: Birmingham: Amy Simpson-Grange on IT Forensic Investigations
Christina Moore : The Soul of an Internet Machine | Print That!
David Kurtz : In the Cloud, Performance is Instrumented as Cost
Daniel Ekberg : Query JSON Data – With Simple Dot-Notation
Emmanuel Guzmán Rojas : Instalación de Oracle forms builder 12c paso a paso completa!
Fahd Mirza : How to Become an Oracle ACE
Gurpreet Singh : Importing AP Invoices using FBDI process in Oracle Fusion
Hassan Abd Elrahman : API to Create User-Defined Table UDT in Oracle APPS R12
Ilmar Kerm : Monitoring Data Guard Fast-Start Failover setup
Jiawei Shi : 基于oracle linux的 DBI/DBD
Joel Acha and Žiga Vaupot : Using Parameters in Oracle Analytics
Julian Dontcheff : 15 important things DBAs need to know about Oracle Zero Downtime Migration (ZDM)
Mario Barduchi : Creating a new Oracle DEV environment with Appsync
Mark Ramsay : Automatic Indexing
Ron Ekins : Portworx Cloud Drive Support for Oracle Container Engine for Kubernetes (OKE)
Sara Beth Good : Oracle Cloud Customer Connect Podcast with Al Marciante
Srinivasarao Ravulapalli : How to create compartments and VCN in OCI
Sivananda Koya : Oracle PeopleSoft Data Mover vs Data Migration Workbench
Sultan Khan : Oracle Datafile movement for ASM and Non ASM
Thomas Simkiss : Allocations in the Oracle Cloud
Timothy Hall : Using new tech stuff, and why you will fail…
Venkanna Mittakanti : Oracle Fusion Order Mgmt Cloud – SQL Script to get the Sales Orders export
Ying Yifeng : Oracle 21c 的自动索引功简单介绍及简单模拟
Yuan Yao : 大型表会让MySQL变慢吗?（译自Percona）
Similar articles:
- ACE Blog Posts and Podcasts February 16 – February 23, 2023: APEX, Database, ERP, Kubernetes and More
- ACE Blog Posts and Podcasts February 9 – February 15, 2023: OCI, Database, APEX and More
- ACE Blog Posts January 27 – February 8, 2023: APEX, OCI, Linux, and More
- Winter ACE Blogs + Bonus ACE Podcasts & Videos
- Recent Books by Oracle ACEs
- Autumn blogs recommendations from Oracle ACEs
- Check out some of the amazing videos and podcasts created by Oracle ACEs
- August 2022 for ACEs – articles, blog posts, podcasts and more
- ACEs Blog Posts – Oldies, but goodies (part 2, July 2022)
- ACEs Blog Posts – Oldies, but goodies (part 1, June 2022)