Obscure and not straight forward This is one of those things I can never remember because it doesn’t come up that often. This is usually […]
LinqPad quick reference
This is a quick post for my own ignorance. On occasion I use LinqPad to make changes in a database and I find the stock […]
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 […]
Could not load file or assembly System.Web.WebPages.Deployment
I encountered this problem when moving from an old machine to a new machine. I vaguely recall having this problem once before, but it was […]
Dot net core NUnit unit test won’t start
I was hoping this problem would resolve itself, but it hasn’t so I am writing about it to document it to refer to in the […]
Cannot ping or RDP to Windows 10 machine
Problem This is a particularly stupid gotcha. For a long time now I haven’t been able to RDP into my Windows 10 Surface Pro 4. […]
Padding a string in tSQL
Gotcha There isn’t a Pad Left or Pad Right function in tSQL. Solution There is a lengthy discussion about this topic already on Stack Overflow […]
RedGate SQL Compare – Index was out of range error
Problem This was a weird one because it is clearly a bug in the software. I am running version 13.6.1.7928 Professional of RedGate SQL Compare […]
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 […]