This answer to a beautiful Stack Overflow question I've given recently needs further explanation in a blog post. When working with Microsoft Excel, we can create beautiful and also very insightful Pivot Tables with grand totals. What are they? This is best explained visually. Assuming you have this normalised form for your raw data. As … Continue reading Creating a Microsoft Excel Style Pivot Table With Grand Totals in SQL
Tag: Excel
The Top 10 Productivity Booster Techs for Programmers
This is the list we've all been waiting for. The top 10 productivity booster techs for programmers that - once you've started using them - you can never do without them any longer. Here it is: 1. Git Before, there were various version control systems. Better ones, worse ones. But somehow they all felt wrong … Continue reading The Top 10 Productivity Booster Techs for Programmers