Scenario As usual when you don’t do something for a very long time, it is easy to forget what you knew already. I had to […]
Pivoting data without an aggregation column
Don’t use PIVOT for non-aggregate-able data I ran into a rather displeasurable experience where a separate team of people built some very important tools for […]
How to get Filename and File Extension from a Column with tSQL
I have written this query like 100 times, but this time I am going to document it so I don’t lose it again. This query […]
Telerik RadGridView Column Format Calamity
Wow… just wow. I lost about an hour trying to figure out a: TargetInvocationException: Exception has been thrown by the target of invocation. This is […]
Storing null in a Column will compile, but will cause run time exception
You can legally store a null in a column from a data row and the code will compile. Don’t do this thought because it will […]