Eclipsys Blog
Latest Posts
Oracle Database 23ai: Fetch Top-N Rows Per Group Queries
Overview: Oracle 23ai introduces partition by clause in fetch first clause to get top-N rows per group. A query’s syntax SELECT …….. FROM …….. ORDER BY , FETCH FIRST , ROWS ONLY..
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 but without the option to validate the structure of JSON..
OLVM : KVM Certificate Renewal
Intro Virtualization has revolutionized the IT industry by enabling organizations to utilize server resources more efficiently. Despite the rise of cloud technology, many..
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 can be time-consuming, especially with open-source..
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..
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..
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 to both the operating system and Oracle Software Components...
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 lists of name-value pairs in the database Query the enum..
Oracle 23ai: Quick Overview
Oracle Database 23ai Oracle Database 23ai is the next long-term support release of Oracle Database It brings AI to your data with the addition of AI Vector search to Oracle’s..
Oracle 23ai: Bigfile Tablespace Shrink
Overview: If you try to resize/shrink a datafile before Oracle Database 23ai, you’ll get “ORA-03297: file contains used data beyond requested RESIZE value” because there are..
Popular Post
