DatabasesDBA support: in-house, outsourced or hybrid? A straightforward guide to deciding
In-house, outsourced or hybrid DBA: real costs, 24×7 coverage, what to demand in the contract and how to compare the…
DatabasesProtheus slow? Where to look for the cause: database, DBAccess and infrastructure
A no-nonsense guide to isolating Protheus slowness: database, DBAccess or infrastructure? Ready-to-run queries, the telltale signs of each layer and…
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…
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…
OracleHow to use hints in Oracle?
The super dictionary of Oracle hints When you work with Oracle, an important part of optimizing SQL query performance is…
OracleHow to create an Oracle 19c database in silent mode
Creating a single instance CDB database in silent mode After installing the database management system (DBMS), the next step is…
DatabasesThe CAP theorem
The CAP theorem (also known as Brewer’s theorem) is one of the key concepts in distributed systems. It was proposed…