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...
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.
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...
Understanding Transparent Application Failover in Oracle Database
SUMMARY: Transparent Application Failover (TAF) is an essential high-availability feature in Oracle Database, typically used in Real Application Clusters (RAC) environments, that automatically reconnects client applications to a healthy instance when a failure (like a...
Create Temporary Tablespace in Oracle and Make It the Default Temporary Tablespace
This article covers the steps to create a temporary tablespace in Oracle and make it the default temporary tablespace for the database. Step-By-Step This method works for both regular Oracle databases and multitenant databases. Each PDB and CDB has its own separate...
Transitioning to the Windows App: Essential Information for Remote Access
SUMMARY: Microsoft is replacing the Azure Virtual Desktop Preview with the unified Windows App to ensure uninterrupted service by centralizing access to cloud PCs, virtual desktops, and local resources through a single, cross-platform gateway. The Windows App provides...
How to Upgrade Oracle Database to 19c
Below is a step-by-step guide to walk you through how to upgrade oracle database to 19c. Step 1 Download the Oracle 19c binaries, the latest version of OPatch, How To Download And Install The Latest OPatch (6880880) Version (Doc ID 274526.1) and the AutoupGrade Tool...
The Rising Costs of Database Monitoring Tools and Why Virtual-DBA Is the Smarter Choice
SUMMARY: XTIVIA’s Virtual-DBA service addresses the escalating costs of traditional database monitoring by replacing rigid, per-instance licensing with a predictable subscription model that integrates automated alerts with expert, US-based human support to ensure...
Azure Removing Default Outbound Access for Virtual Machines
SUMMARY: Microsoft is retiring default outbound internet access for new Azure Virtual Machines on September 30, 2025, to enhance cloud security by requiring administrators to replace unmanaged, ephemeral IP addresses with explicit routing solutions like NAT Gateways...
PostgreSQL in GCP: Tackling “permission denied for language C”
SUMMARY: Database administrators can resolve the PostgreSQL "permission denied for language C" error in Google Cloud Platform (GCP) by abandoning custom C-language functions and instead enabling the native uuid-ossp extension for secure UUID generation. GCP Cloud SQL...
Azure Deprecating TLS 1.0 and 1.1
SUMMARY: Microsoft is deprecating Transport Layer Security (TLS) versions 1.0 and 1.1 across Azure SQL services, requiring organizations to upgrade client connectivity to TLS 1.2 by August 31, 2025, to ensure data security and compliance. Azure SQL Database and...









