SUMMARY: Database administrators can proactively prevent or quickly resolve the ORA-00059 error, which occurs when creating or cloning PDBs without sufficient allocation for the DB_FILES parameter, by verifying current usage and executing a system alteration that...
Welcome to our blog, which is more than just a record of our experiences. It’s a resource.
Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
Master to Master Replication in MySQL: Configuration Setup
SUMMARY: Senior database administrators implement MySQL Master-to-Master replication (bidirectional replication) to achieve high availability and load balancing by enabling read/write operations on two servers, a configuration that requires careful setup using Global...
Unlocking Infrastructure Potential with Terraform
SUMMARY: Terraform, an open-source Infrastructure as Code (IaC) tool from HashiCorp, empowers businesses to automate, provision, and manage consistent multi-cloud environments across platforms like Azure, AWS, and Google Cloud, effectively eliminating reliance on...
Where Is On-Premise Oracle 23ai?
SUMMARY: Oracle has indefinitely delayed the general on-premises release of Oracle Database 23ai, signaling a strategic "Cloud-First, Developer-First" pivot that prioritizes cloud availability and requires extensive testing for performance parity across diverse server...
Query Store: SQL Server’s Built-In Time Machine
SUMMARY: Since its debut in 2016, SQL Server Query Store has gained critical features such as wait statistics and automatic plan correction, evolving from a simple logging tool into an adaptive performance tuning partner that minimizes rogue query performance issues...
Securing Your Data: The Critical Role of CIS Benchmarks for Database Security
SUMMARY: Implementing Center for Internet Security (CIS) Benchmarks is the most effective proactive strategy for organizations to harden critical database management systems, such as SQL Server and Oracle, and minimize the risk of catastrophic data breaches,...
Eliminate Cloud Vulnerabilities: The Critical Importance of CIS Benchmarks for AWS, Azure, and GCP
SUMMARY: CIS Benchmarks are essential configuration guidelines published by the Center for Internet Security (CIS) that enable cloud users to fulfill their shared responsibility for security by addressing misconfigurations and hardening environments across AWS, Azure,...
Is Your IT Castle Built on Sand? How CIS Benchmarks and XTIVIA Can Help
SUMMARY: XTIVIA helps organizations secure their complex IT environments by meticulously comparing system configurations—including operating systems, cloud platforms, and databases—against the detailed, expert-crafted CIS Benchmarks. CIS Benchmarks are meticulously...
Creating and Sizing the Oracle Fast Recovery Area
When creating the fast recovery area, place it on a separate disk from the database binaries and data files. For this example, I am using the C drive because this is on a VM, which is what is available. The size of your fast recovery will also depend on several...
Azure Retiring Azure Database for MariaDB
SUMMARY: Microsoft is permanently retiring the Azure Database for MariaDB service on September 19, 2025, requiring all current users to migrate their database instances immediately to prevent permanent deletion and loss of all data, primarily by...









