Blog: SQL

How to use APEX Assistant (AI Chat Capability) 🤖

Introduction: APEX Assistant adds AI chat capability to all APEX code editors to assist you with writing SQL queries, debugging code, etc.

Read More

How to Chat with Oracle 23ai using SQL Agent

Read More

Oracle Database 23ai: SQL Firewall – Part 1: Intergrate SQL-Firewall with Data-Safe

Introduction We live in the data era, where every organization invests significant resources in securing its IT infrastructure. Protecting data is crucial because modern..

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 for my test. 2. Availability Group..

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 database data and log files on disk. It works transparently..

Read More

MySQL: Updating the Configuration of a MySQL DB System on OCI

Overview: A MySQL configuration is a collection of variables that define the operation of a MySQL DB system. It is analogous to the my.ini or my.cnf files that you use in..

Read More

MySQL: Creating a MySQL Configuration on OCI

Overview: A MySQL configuration is a collection of variables that define the operation of a MySQL DB system. It is analogous to the my.ini or my.cnf files that you use in..

Read More