Prerequisites: a. Oracle Linux 7.9 b. Oracle 19c database (should be 19.3 or higher version), Check using… SELECT target_version AS RU_VERSION FROM dba_registry_sqlpatch WHERE action = 'APPLY' ORDER BY action_time…
Read MorePerformance Tuning of Slow Running Queries in SQL
Read MoreIntroduction As organizations move critical workloads to the cloud, traditional perimeter-based security models are no longer sufficient. Modern cloud environments are highly dynamic, distributed, and interconnected, requiring security to be…
Read MoreIntroduction Many OCI users are noticing sudden cost increases even though their compute or storage usage hasn’t changed. In most cases, this happens because logging features like Flow Logs, DNS…
Read MoreIf you’ve been watching the data engineering space lately, you know how painful data silos and vendor lock-in have become. Oracle just rolled out something that might really shake things…
Read MoreIntroduction: This blog has the SQL query that retrieves all Quality test samples along with their corresponding results. Cause of the issue: Business wants a report that contains the details…
Read MoreIntroduction/Issue:Running Kubernetes on AWS gave us flexibility, but we noticed our monthly bills were climbing fast. On closer inspection, we found workloads consuming way more resources than they needed, leading…
Read MoreIntroduction/Issue:During one of our deployments, we noticed several pods stuck in a CrashLoopBackOff state. This immediately raised alarms since critical services were unavailable. The CrashLoopBackOff loop happens when a container…
Read MoreIntroduction/ Issue: When building Power BI reports, a cluttered fields pane can confuse report developers and slow down the design process. Duplicate-looking columns, technical keys, or backend fields often end…
Read MoreIntroduction/ Issue: DAX is powerful, but its behavior is tied to context—row, filter, and context transition. Misunderstanding these can lead to wrong results, especially in totals, averages, and complex calculations.…
Read More