Postgresql Installation
POSTGRESQL INSTALLATION ON WINDOWS PURPOSE AND SCOPE This document focuses exclusively on the installation of PostgreSQL. It outlines the purpose of installing PostgreSQL and defines the scope limited…
Read MoreSQL Server Index Maintenance
SQL Server Index Maintenance: Improving Query Performance PURPOSE AND SCOPE This document explains the importance of index maintenance in SQL Server and demonstrates how to identify and resolve index fragmentation…
Read MoreOracle GoldenGate Installation on Linux
Oracle GoldenGate Installation on Linux Introduction Oracle GoldenGate is a real-time data integration and replication tool that enables reliable, secure, and high-performance data movement across heterogeneous systems. It is widely used for real-time reporting,…
Read MoreSetting Up Azure Monitor and Alerts for Proactive Incident Detection
Introduction / Issue In modern cloud environments, infrastructure reliability depends heavily on continuous monitoring. Virtual machines, storage accounts, databases, and network components must remain healthy to ensure uninterrupted application availability. However,…
Read MoreRecovering Deleted Files Using Snapshot Backups in Linux
Introduction / Issue Accidental file deletion is a common risk in production environments. Even experienced administrators can mistakenly remove critical files during maintenance activities. In one instance, important application configuration…
Read MoreOracle Data Guard Setup in Oracle 23ai Migrating from Non-CDB (Primary) to CDB (Standby)
Introduction This document explains how to configure a normal Oracle Data Guard physical standby in Oracle Database 23ai, where the primary database is a Non-CDB and the standby database is…
Read MoreStep by Step Guide to Oracle Data Guard Broker (DGMGRL)
Introduction High availability and predictable disaster recovery are critical in any Oracle production environment. While managing Data Guard manually via SQL*Plus is possible, the number of manual steps during incidents…
Read MoreCreating a Database Link in Oracle 19c Database to connect MS SQL Server using ODBC Driver
Prerequisite: 1. MS SQL Server with a SQL Authenticated User. CREATE LOGIN Sivakumar WITH PASSWORD = 'Doyen@123', CHECK_POLICY = OFF; SELECT name, type_desc,…
Read MoreParameter Sniffing Issue in SQL Server and Its Resolution
Parameter Sniffing Issue in SQL Server and Its Resolution Parameter Sniffing Issue in SQL Server and Its Resolution
Read MorePerformance Tuning of Slow Running Queries in SQL
Performance Tuning of Slow Running Queries in SQL
Read More