In modern data warehousing, the "pure" Oracle environment is a myth. We often manage dozens of Oracle databases but still encounter that one necessary SQL Server instance holding critical data. When you need to pull data from SQL Server into Oracle, you have two primary options: the paid "Oracle Database Gateway for SQL Server" (DG4MSQL) … Continue reading The Oracle DBA’s Guide to SQL Server Integration: Implementing DG4ODBC on Oracle Linux 9
Solving the Country Dimension Chaos in a Data Warehouse: Smart Design Tips You Can Use
If you’ve ever worked on a data warehouse with multiple subject areas, you’ve likely run into a seemingly small issue that turns into a huge problem: inconsistent dimension values — especially for something as basic as countries, Gender and others. Recently, I faced this exact challenge and wanted to share how I tackled it, along … Continue reading Solving the Country Dimension Chaos in a Data Warehouse: Smart Design Tips You Can Use
Patching Oracle Linux against CVE-2023-48795 Vulnerability on Air-Gapped Servers
We’ve all been there. That email from the security team lands in your inbox, or a routine scan flags a new, critical vulnerability. This time, it’s CVE-2023-48795, also known as the "SSH Terrapin Prefix Truncation Weakness." It sounds intimidating, and the thought of a man-in-the-middle attack. For many, the fix is straightforward. But what if … Continue reading Patching Oracle Linux against CVE-2023-48795 Vulnerability on Air-Gapped Servers
Ahmed AbdelFattah Blog ! 