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...
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 and I kept getting this error after performing an upgrade...
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 is: A fatal scripting error occurred. Incorrect syntax was encountere...
Guide to using Git for TFS users
Introduction It’s that time again – that time where the development industry has decided for us that what we were using before isn’t good enough anymore and everyone needs to change ...
Killing Floor 2 freezes while using free look camera
Problem Here are the reproduction steps for this annoying bug: You are playing Killing Floor 2 You die during a round You are watching the other players while you are waiting for the round to end to j...
DotNet Core EF migration not working
Problem Here is the basic setup of this problem: You created a .Net Core application and wanted to use .Net Core EF in your application for the data layer. You have already installed .Net Core EF from...
Avoiding the Red Gate Sql compare “Non-Schema statement was ignored” warning
Gotcha I recently had to create some non-schema related objects for a database project I am working on. It caused an annoying problem with Red Gate SQL Compare where I was prompted each time I did the...
A very basic guide to GIT commands
Why GIT commands? When you use GIT long enough, you begin to realize it is just easier to use GIT commands. Using a console is faster in every way because UI for some reason or another is laggy and sl...