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...

Comcast’s comcastic consumer extortion tactics!

I hate Comcast https://en.wikipedia.org/wiki/Fair_use This is purely a rant post because I hate Comcast with every part of my being. Louie CK said it the best, summarizing: “I am using my whole ...

How to use Excel and tSQL to help you Generate Code

Introduction It’s amazing to me the reactions I get when I show people seemingly simple tricks on how to automate or generate code and/or script generation. Whenever I see a pattern, that means ...

SSRS Windows Integrated Security: Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’

The Overly Complicated Problem I spent about 2 days trying to figure this problem out, until we had some professional help step in to help us figure it out. The solution is embarrassing. First an over...

Telerik RadGridView Hierarchical Data (Child Grids) for Winforms Gotcha

The Gripe I have been banging my head against a wall since yesterday trying to figure out what the hell I was doing wrong with my RadGridView’s Hierarchical Child Grid. I configured it...

SQL Server: String or binary data would be truncated.

Msg 8152, Level x, State x, Line x String or binary data would be truncated. What does this mean? This is the equivalent of SQL Server telling you that you are trying to fit too much into a container ...