SQL Server: Dynamically Calculate Delta Values For Numeric And Date Columns From DMV’s Or Any Table

DMV's are very useful. In fact, they are like glass windows that lets you look at a running engine. There are lots of them and they give us lots of numbers but Most are cumulative in nature!  i.e., the numbers keep on increasing and never decrease. A variation of above like space usage where the … Continue reading SQL Server: Dynamically Calculate Delta Values For Numeric And Date Columns From DMV’s Or Any Table

Advertisements

Oracle (or) SQL Server: Find Row Level Data Differences Using MINUS/EXCEPT – 100 Level

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

Perform Set Operations (Union, Intersection, Minus & Complement) Using PowerShell

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