One thing that bugs me in SQL Server is how hard it is to get information about your tables to analyse usage, indexes and size.Read More
The data required “unpivoting” so that the measures became just three columns for Volume, Retail & Actual - and then we add 3 rows for each row as Years 16, 17 & 18.
Their are various ways of doing this in Spark, using Stack is an interesting one. But I find this complex and hard to read.Read More
A while back now I started to create some PowerShell modules for assisting with DevOps CI and CD scenarios.Read More