MERGE statement was a very useful addition which was introduced from SQL 2008. It is very useful in lots of day to day scenarios like normal UPSERT (UPDATE + INSERT) operations, slowly changing dimension processing etc. This blog aims at…
T-SQL Tips: Fun with date FORMATing
FORMAT was a new function introduced in SQL 2012 which can be use to format date,numeric values to a variety of different formats and styles.This blog discusses on some of the cool date value formatting tips that can be done…
Troubleshooting SQLServer CDC Service for Oracle Capturing Only Changed Column Values for Updates Issue
Recently for one of my datawarehouse projects we had a scenario which required getting data from a Oracle server. Since this Oracle server was a high end OLTP system with high frequency DML operations happening the impact on the system…