Sql Server REPLACE function makes expression string NULL when replacement string is NULL
Obscure problem This has happened to me before, but naturally I forgot because it has been a while. The scenario is that you have dynamic SQL and you are trying to replace tags in your...
Visual Studio 2017 will not connect pre-existing repository to TFS after TFS URL has changed
Irritating problem There is an amalgam of complaints about this issue already on the product form, you can view them here: https://developercommunity.visualstudio.com/content/problem/26914/team-explorer-does-not-recognize-previously-cloned.html The scenario for this problem to play out is like so: Your TFS administrators...
Simple trick for improving late night coding
The Problem Most developers will code well past the time where the sun goes down at work or at home. The brightness of your screen can really affect your eyes making you tired or causing...
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...
Windows 10 won’t display password box after restart
The stupid problem This was an especially stupid problem. My computer lost power while I was trying to shut it down on UPS power during Hurricane Irma – I didn’t catch my PC in time...
After appending child elements to a parent element using jQuery some child elements won’t render
This was a head scratcher All too often we become very comfortable with what we are doing, so when we stumble across some of the basics it becomes a very strange problem all of a...
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...
Google Analytics Post Pageviews – Google OAuth 2 authorization – Error: redirect_uri_mismatch
Introduction This post is geared towards completing the installation for the Google Analytics Post Pageviews plugin for WordPress. It is not straightforward and the provided instructions are either dated or lacking. Either way this consumed a...