SQL Server: Visualize Your Backups For Insights – By Month Day, Time etc.

Backups are a very important part of a DBA's job. Understanding when they have happened and when they have not happened is even more important. Quantifying things quickly can mean the difference between good and bad decisions when you are in a bind. Note: If you are looking to do something similar with Oracle, please …

SQL Server – Dynamically PIVOT ANY Column On ANY Table in ANY Database For ANY Aggregation With ANY Condition

SOURCE CODE ATTRIBUTION: Before I proceed, I want to give credit to the original procedure by sfrejofsky based on which I created this procedure (mostly improvements). The source of this procedure is https://stackoverflow.com/questions/10404348/sql-server-dynamic-pivot-query I had a need to do dynamic PIVOTing for one of my projects and instead of reinventing the wheel, I used the …

PowerShell: Get Security Updates List From Microsoft By Month/Product/KB/CVE With API

I am a regular at my local PowerShell user group. I keenly look forward to our monthly meetings. We share a lot amongst ourselves. It is a small but close-knit group. Recently, one of the members, Julie came up with a coding challenge for the group. This blog post is about the challenge. My solution …

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 …

SQL Server – PIVOT Data With TSQL

Note: Although I wrote this in year 2012, it is still valid. If you are looking to convert rows to a CSV string and vice versa in Oracle, please read my related post on that here. If you are a serious PIVOT'er, I know that you would use Excel or Power Pivot or Power BI. …