Modelon Solutions

A fresh take on your ideas

Blog

  • SQL and extensibility

    Having a schema in SQL defeats extensibility – and there is no way i am having columns named “ExtensibleColumn1, ExtensibleColumn2″… I have come to embrace storing JSON directly in the database, quite easy actually as JSON is simply text… The bigger problem though was how to extract specific data from this JSON, or filter on Read more

  • SQL Magic row to column concatenation

    Imagine you have a very simple data model with two tables, Invoice and InvoiceTaxes. When creating a report, i would like to see all invoices and the taxes applied to each, but not as a 1 to n relationship, but rather as a sting concatenation. i.e. Invoice1, “TPS” Invoice2, “TPS, TVQ” Invoice3, “TVH” I went Read more

  • Windows 10 Creator`s update

    I have been using the new Windows 10 Creator`s update on my main laptop now for a few days, and things are pretty smooth. The upgrade process didn`t break anything… The good : Taking screen shots and putting them to the clipboard is not built in. It is the same combination as OneNote used. windowKey Read more

  • Application Insight Availability

    I just helped put a rather big system in production. There are always a lot of things to do and we lately turned on availability monitoring with Azure Application Insights. Since we knew we were going to use this feature, we had added a “ping” controller to our API tier. This controller had a single Read more

  • Azure and Memory Leaks

    I know I know, how can i have memory leaks, you’ve got a garbage collector in that fancy .net don’t you ? So this is the second project i work on where we find memory leaks in production. The first one was a third party library that didn’t release a bitmap when it generated reports Read more

  • SQL Dynamic Data Masking

    When working with database, we sometimes have to backup-restore them in order to bring them to a test environments. When this happens on premise, there is a good chance the backup gets restored to a know machine. With the cloud and outsourcing, the backup could be restored miles away on another continent. Go read this Read more