PowerShell Tip: Specify Select Column List (Attributes/Properties) Dynamically

As we pipe stuff through a pipeline, we may have the need to add/remove/rename columns. These three operations are easy to do. Remove/Add/Rename Remove: Here we remove all attributes returned from Get-Process except Handles and ProcessName by not selecting them Add: Here we add a new attribute name "NewAttribute" to the existing two attributes Handles … Continue reading PowerShell Tip: Specify Select Column List (Attributes/Properties) Dynamically

Eating An Elephant – How To Work With Huge Datasets In Oracle And SQL Server

Simplifying complex problems is difficult but when done, the rewards are definitely worth it. How I single-handedly managed to migrate 55 Billion rows in 4000+ tables: Last year, I created PowerPump a PowerShell based data copy server which continuously migrated 4000+ Oracle tables to SQL Server. It was no simple task given that I had … Continue reading Eating An Elephant – How To Work With Huge Datasets In Oracle And SQL Server

SQL Server: MERGE (AKA UPSERT) =(INSERT / UPDATE / DELETE) – All In One

MERGE statement does INSERT/UPDATE/DELETE For the longest time Oracle and SQL Server users have written code like this (pseudo code) This is great but this is such a common construct that everyone has also been long craving for built in support in the database for what people commonly call UPSERT (UPDATE if key exists else INSERT). … Continue reading SQL Server: MERGE (AKA UPSERT) =(INSERT / UPDATE / DELETE) – All In One

Oracle REDO – A Basic Explanation

In an earlier post, we saw how Oracle’s UNDO works in very basic terms. REDO is another critical aspect that goes hand in hand with UNDO. Let us get the basics of REDO sorted out here. UNDO and REDO In its most basic sense UNDO is information saved to get back in case a ROLLBACK … Continue reading Oracle REDO – A Basic Explanation