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 here:¬†https://stackoverflow.com/questions/16760900...

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

Query SQL Server using PowerShell

I don’t understand why it was so difficult for me to find an example on this, so I compiled one from three posts so I could put it here: [crayon-5ce82c5563c7a408564908/] Enjoy...