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 MoreIntroduction 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 MoreIntroduction 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 MorePrerequisite: 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
Read MorePerformance Tuning of Slow Running Queries in SQL
Read MoreIntroduction: Transaction log growth is a common operational challenge in SQL Server environments. Uncontrolled log file growth can lead to disk space issues, performance degradation, and operational risks. This blog…
Read MoreIntroduction Data Guard setups often appear straightforward on paper, but real-world environments have a way of exposing gaps in even the most familiar procedures. While creating a Physical Standby Database using…
Read MoreINTRODUCTION: As an Oracle DBA, setting up Data Guard is only half the job. The real responsibility starts after the setup — making sure redo is shipping, applying correctly, and that there…
Read MoreIntroduction: Picture a retail buyer, minutes before a key vendor meeting, asking their system, “What were our top-selling colours in outdoor apparel last season, and what’s the social media sentiment…
Read More