T-SQL: Derived tables & table value constructors
In this technical blogpost one of our developers, Peter de Heer, highlights T-SQL derived tables & table value constructors. He then presents a well performing technique for doing unpivoting operations with them.
T-SQL: Compare NULL by value
In this technical blogpost one of our developers, Peter de Heer, demonstrates how equality matches, that treat NULL values as if they were an actual value, are typically handled. He then shows a not well known, but much better technique for doing this and explains where and why to use it.
T-SQL: Len() and DataLength()
In this technical blogpost, Peter de Heer explains the meaning of the Len() and DataLength() functions and how they're used. By showing you a small demonstration we hope to give you some insights on these two functions that seems very similar, but have their own side-effects.
Gitflow plus: Participative Software Development
Basically all software development is: 1. Turning coffee into cool things 2. fixing broken thing (due to lack of coffee, or coffee-overdose)