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...
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 ...
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...
HBO’s Silicon Valley
HBO’s Silicon Valley I have been avoiding watching HBO’s Silicon Valley for a long time now, I have heard it is funny and that I should watch it. I had knee surgery recently so I decided s...
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 is a bad idea, but quickly I am over ruled because wah...
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 Memory utilization via CMD but that produced incredibly unreliable result...
Tips on onedrive-d and re-installing it
Introduction I recently install Mint Linux on a tiny $200 13″ laptop because Windows 10 was killing its performance since I got it. I got this low powered sad excuse for a laptop because the onl...
Where are the SSRS, SSAS and SSIS templates for Visual Studio 2017?
SSDT Templates I am not sure why Microsoft did this and you can join the angry mob here if you want to join in on the hate fest, but for some reason or another SQL Server Data Tools SSDT that you elec...