Set a color property to a hexadecimal value in Visual Studio's Form Designer as opposed to in runtime

https://stackoverflow.com/a/46216148/1219280

Task.Run, Unwrap and other .NET 4.5 additions

https://blogs.msdn.microsoft.com/pfxteam/2011/10/24/task-run-vs-task-factory-startnew

Found the Unwrap particularly interesting.

Assembly Binding Log Viewer (fuslogvw)

I only managed to have fuslogvw show something after following the remark I added in this post.

How can I see WCF server logs?

What is suggested here worked for me.
This is cleaner. Update: this has always been working for me, and seems more complete/easier. Put it  right before the closing configuration outer node.

<system.diagnostics>
  <sources>
    <source name="System.ServiceModel.MessageLogging" switchValue="Warning, ActivityTracing">
      <listeners>
        <add name="ServiceModelTraceListener" />
      </listeners>
    </source>
    <source name="System.ServiceModel" switchValue="Verbose,ActivityTracing">
      <listeners>
        <add name="ServiceModelTraceListener" />
      </listeners>
    </source>
    <source name="System.Runtime.Serialization" switchValue="Verbose,ActivityTracing">
      <listeners>
        <add name="ServiceModelTraceListener" />
      </listeners>
    </source>
  </sources>
  <sharedListeners>
    <add initializeData="Service.svclog" type="System.Diagnostics.XmlWriterTraceListener, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" name="ServiceModelTraceListener" traceOutputOptions="Timestamp" />
  </sharedListeners>
</system.diagnostics>

Rename msbuild specific assembly only (as opposed to using /p:AssemblyName={...}, which renames all build's project assemblies)

Problem and solution described here.

mySQL Error Code: 3037 Invalid GIS data provided to function st_geometryfromtext.

If you have been trying to find what's wrong with your geometry objects and why your sql insert statement is failing, check this, which reveals the cause (congrats to all of us who went "as far as completing a BSc degree in computer science" (and how far is that?) and could yet miss this...).

I was startled because, in cloning some tables from one DB schema to another, I was facing this error. But how come values that do exist in one table cannot be inserted (are treated as invalid) in another ?

Later on I heard that this was a change made in later versions of mySQL. So I assume the records were inserted at the time this constraint was not there yet. And they must have kept existing data as valid for backward compatibility.

ILMerge errors (exited with code 1, could find dll, assembly has a value for its PeKind flag that is incompatible...)

After leaving very few spots in my head unscratched (I am environment-conscious, there are those who act with a bit less self restrain and throw their computers through the office's window), I came up with the following solution to ILMerge errors of all sorts. ILRepack is being developed to replace our endeared ILMerge, and although I am sure all of you keep deep feelings (feel free to make them public) about it, my solution was to:

1. backup C:\Program Files (x86)\Microsoft\ILMerge\ILMerge.exe renaming it to, say, _ILMerge.exe 
2. place a copy of ILRepack.exe 
3. rename it to ILMerge.exe  (it follows the exact same ilmerge command line parameters syntax)

 And that's it. Rebuild your solution.
Yes, you are rid of ILMerge. Unbelievable.