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 […]
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 […]
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 […]
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 […]
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 […]
After upgrading to Bootstrap 4 glyphicons no longer work
Silly mistakes I was avoiding upgrading to Bootstrap 4 for a project I have been working on because each time I did all of my […]
Why months is a terrible measurement
Introduction There have been numerous times that I have been asked to provide a threshold or measure something in months. I always warn that this […]
Get CPU and Memory utilization in percentage via PowerShell
The seemingly simple problem I could not believe what a total pain in the ass this was to resolve. I tried getting the CPU and […]