The goal of this post is to compare two text files that may have millions of lines and compare them to quickly find out which lines differ using Oracle EXTERNAL tables. As an Oracle professional, “external tables” are something you may already be familiar with or maybe you have heard about them but not used … Continue reading Oracle – Compare Text Files With 10 Million Lines In 10 Minutes Using 10 Lines Of Code – EXTERNAL Tables
This post is about the various types of JOIN's and how the conditions affect the results when placed in the JOIN clause versus the WHERE clause. OUTER JOINS Database programmers use OUTER JOINS in their job day in and day out. There are certain “gotchas” that you need to watch out for. One not only … Continue reading Oracle and SQL Server – Conditions In WHERE Clause vs. JOIN Clause – Why And When It Matters? Must Read!
Changes needed for SQL Server The simple SQL illustrations mostly show Oracle code but the final SQL is also shown for SQL Server (simply remove the “FROM DUAL” references and replace "MINUS" with "EXCEPT"). What this post is about? When we need to compare two sets of data to find out which rows are different between the … Continue reading Oracle (or) SQL Server: Find Row Level Data Differences Using MINUS/EXCEPT – 100 Level
Our Windows security setup is completely (well, mostly 🙂 ) AD groups based. When new employees are hired, we ask for an existing employee after whom the new employees permissions should be mirrored. In other words, if we added the new employee to the same AD groups (that are related to SQL Server of course), … Continue reading Compare AD group membership of two users
Recently I wrote an generic object persistor (to DB) in PowerShell. I would love to share it but there are too many depenencies. The subject of this post is however on doing set operations. The object persistor, simply saves one or more custom objects to a given database table. This involved validation to make sure … Continue reading Perform Set Operations (Union, Intersection, Minus & Complement) Using PowerShell