There is a very powerful feature in SQL Server that if you know how to take advantage of can cut down on the amount of […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]