Cursor-Scoped Event Aggregation Pattern – for high performance aggregation queries

1st of June, 2016 / / No Comments

Often, stateful applications executing enterprise scenarios are not just interested in the current state of the system, but also in the events which caused the transition that resulted in the particular state. This requirement has exponentially increased the popularity of the Event Sourcing Pattern.

Event Sourcing Patterns ensure that all changes/events that caused a transition in application state are stored as a sequence of events in an append-only store. These events can then be queried for tracking history or even be used to reconstruct system state in case of an unexpected application crash.… [Keep reading] “Cursor-Scoped Event Aggregation Pattern – for high performance aggregation queries”

Use Excel, PowerQuery and Yahoo Finance to manage your Portfolio

24th of June, 2015 / / 25 Comments

There are some new and powerful Business Intelligence options available to all of us, from scalable cloud platforms to the Excel on the desktop. So its a good time to demonstrate some of them and show where BI and Application Development meet.

Power Query and the language M have been quietly making their way into the Microsoft Business Intelligence stack and in particular Excel for some time. The set of “Power” components (Power Query, Power Pivot and Power BI) all sound a bit like the marketing guys won the naming battle again and don’t really help explain the technology nor where they fit so I avoided it for a long time.… [Keep reading] “Use Excel, PowerQuery and Yahoo Finance to manage your Portfolio”