OracleOracle data block recovery
Recovering corrupted data blocks in Oracle Database is an essential technique to preserve data integrity without having to restore the…
SQL ServerSQL Server: PowerShell export and import with BCP
Hey hey folks, how about some SQL Server today? 👀 Like every good DBA, we often run into the need…
MySQLTransportable Tablespace in MySQL: the definitive guide
Hey folks, everything cool, everything smooth, all good? I hope so. Today, one more article about that darn dolphin database.…
MySQLTablespaces in MySQL 🐬
Hey folks, everything good? I hope so. Today I want to cover a simple, practical topic that, just like in…
MySQLMySQL InnoDB Cluster, explained
Heyyyy folks, everybody good? Ready to talk a little more about the dolphin database? ⚠️ CONTAINS TEXT IMPROVED BY AI,…
MySQLInnoDB Cluster in one command
In this post I want to share something I found pretty cool: building an automagic process to deploy a MySQL…
OracleOracle DBMS_SCHEDULER vs DBMS_JOB: a single package to manage, pause, and monitor jobs
Introduction Many Oracle environments run two scheduling mechanisms side by side: DBMS_SCHEDULER (modern) and DBMS_JOB (legacy). Each has its own…
OracleOracle storage structures
How does Oracle store data? The Oracle Database storage structure is designed to be highly efficient and flexible, allowing large…
OracleOracle Database startup/shutdown phases
Starting the Oracle database instance Before users can connect to a database instance, a database administrator must start the database…
OracleViews in Oracle
Views are a very useful resource in relational databases: they let you create logical representations of the data stored in…