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 – Data Visualization Of DateTime Stamps – The Big Picture 24-hour View By Date Using PIVOT

One of the interesting aspects of working with data is how every person can look at the same thing and come to different conclusions. No one is right or wrong but a good visualization will lead to good decision-making. One of the leading data visualization patterns is pivoting and pivoting is everyone’s first choice when … Continue reading Oracle – Data Visualization Of DateTime Stamps – The Big Picture 24-hour View By Date Using PIVOT

Poor Man’s Cube Style Slice & Dice In A Query

This weekend I had the privilege of volunteering the Give Camp in Charlotte.  Give Camp itself is an annual national event where technical people volunteer their time over the course of a weekend to build a solution for a charitable or non-profit organization that could use the help. In my case, I was with in … Continue reading Poor Man’s Cube Style Slice & Dice In A Query