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. … Continue reading SQL Server – PIVOT Data With TSQL

Advertisements

SQL Server – Generate and Use Size / Storage Dimension

This post shows how I created, generated data for and used "StorageDimension" with PowerBI to slice and dice by that dimension.

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