Introduction I usually like to keep any explanation I write to be straight to the point, but informational and no fluff. There are times where […]
Biases in naming database objects
Introduction Over my whole software engineering career, I have watched and learned the right way and the wrong way to style and format code. Especially […]
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 […]
Visual Studio 2017 SSIS unable to start debugging
Error details For what it’s worth here are the error details. Microsoft’s handling of SSDT isn’t good I have criticized Microsoft about this before here […]
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 […]
Incorrect syntax was encountered while parsing :SETVAR
Gotcha When working with SQL CMD mode every now and then I will get this vague error and I can’t figure out what the problem […]