PowerShell – Case-insensitive String Replacement

The problem: Replace "a" with "b" case-insensitively You have a simple string and you want to replace all "a" with "b" in a case-insensitive manner. First attempt (fail): PS C:\Windows\system32> [string] $someString = 'aAaAaAaA' $SomeString.Replace('a', 'b') #Result bAbAbAbAbA What happened? The [string].Replace() method is case-sensitive Second attempt (looks like it works but not quite): PS … Continue reading PowerShell – Case-insensitive String Replacement

Oracle Tip – COPY Command – When You Don’t Have DataPump

This is an old post that I am re-cycling. The recommended method to copy data around is by using DataPump. However, if you are on an older version of Oracle, COPY command is an easy way to copy data from one database to another or even within the same database. There are countless situations where … Continue reading Oracle Tip – COPY Command – When You Don’t Have DataPump

SQL Server Loops – Alternative to OPEN, FETCH & CLOSE loop using ROW_NUMBER in TSQL

Have I every said that I hate don't like cursor based logic? This time, I am going to show how to replace cursor logic in your TSQL with loops. Caution: RBAR is bad! While row-by-row processing is generally bad both in Oracle and SQL Server, there are instances where it is best to simply loop … Continue reading SQL Server Loops – Alternative to OPEN, FETCH & CLOSE loop using ROW_NUMBER in TSQL