Oracle 23ai: JSON Schema Support

Overview: Oracle first introduced the ability to display a JSON schema when they introduced the JSON Data in Oracle 12.2… Read more

How to create a CentOS 7 Virtual Machine on Windows using Vagrant

Vagrant is an open-source command-line tool for creating and managing virtual machine environments. Although virtualization… Read more

Restore a Database in the MS SQL Server Always On Availability Group

Prerequisites 1. Backup File: Ensure you have a valid full backup of the database you want to restore. I used AdventureWorks2019.bak… Read more

Encrypt an Existing MS SQL Server 2019 Database in always on Environment using TDE

Transparent Data Encryption (TDE)  Transparent Data Encryption (TDE) in SQL Server protects data at rest by encrypting… Read more

ODA Bare Metal Patching From 19.16 to 19.20

ODA Upgrade from 19.16 to 19.20 Patching Oracle Database Appliance (ODA) Bare Metal Systems involves applying updates… Read more

Oracle 23ai: Enumeration Domains – List of Values in the Database

Overview: Oracle Database 23ai introduces a new way to create lists of values: enumeration (enum) domains Benefits: Create… Read more