Enlarging a CHAR column

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 increase the column size of a CHAR field from 9 to 15 bytes and I totally...

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 us and they did a lackluster job and...

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 specifically assumes that you have a single column that contains a file nam...

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 probably one of the most useless exception m...

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 definitely throw an exception during run time 🙂 dr[“columnName&...