I say, Monogra·fi

MSysGit / Curl not finding your _netrc file?

Make sure you have an environment variable pointing to your home directory (or rather the directory where your _netrc file is).

TSQL’s UNION operation really is a UNION

This one caught me a bit off guard. It turns out UNION in TSQL really is the mathematical union of the two result sets not just the concatenation of the involved results.

Include the keyword ALL to ensure duplicates are also returned.

ALL

Incorporates all rows into the results. This includes duplicates. If not specified, duplicate rows are removed.

Anonymous clone, authenticated push with Git over HTTP

It seems that you can’t configure Apache to support the anonymous-clone authenticated-push scenario over the http-backend.

http://git.661346.n2.nabble.com/git-http-backend-and-Authenticated-Pushes-tp4703506p4703506.html

Fortunately the situations where I need anonymous access are rather limited (TeamCity does not support authentication over http for git). I was able to solve it by serving repositories without authentication under a different url like so:

ScriptAlias /git/ “C:/Progra~1/Git/libexec/git-core/git-http-backend.exe/”
ScriptAlias /_git/ “C:/Progra~1/Git/libexec/git-core/git-http-backend.exe/”

Error 80041003 when manipulating Services using WMI through ASP

You can run into quite strange errors when attempting to access WMI though ASP, note that there are a few steps to remember for bliss.

1. Ensure you give permissions for the user in question to access WMI. Computer -> Manage -> Configuration -> WMI Control -> Properties, in the Security tab ensure your user has permissions to the right namespaces (probably Root/CIMV2). The permission required is usually 
2. Use either SC.exe or preferrably SetACL.exe to set access control lists for the relevant user on the service, for example:

   SetACL.exe -on SERVICE_NAME -ot srv -actn ace -ace "n:USER_OR_GROUP;p:start_stop"

3. Finally you need to enable impersonation to work, for that we need to pass the password as plaintext. To do this ensure you use Basic authentication instead of Windows Authentication.

Using SQLite with NHibernate on 64 bit Windows

If you encounter an exception like this when initializing the ISessionFactory under FluentNHibernate with a 64 bit version of Windows

NHibernate.HibernateException: The IDbCommand and IDbConnection implementation in the assembly System.Data.SQLite could not be found. Ensure that the assembly System.Data.SQLite is located in the application directory or in the Global Assembly Cache. If the assembly is in the GAC, use <qualifyAssembly/> element in the application configuration file to specify the full name of the assembly.

Then you should probably ensure that the project is compiled for “x86” instead of “Any” in the project properties dialog.

ISeeYourMouthMovingButIDontUnderstandAWordYouAreSaying

Who the hell can read this sh*t?

public void LoopThroughAllTypesAndRegisterForOpenGenericsOfType(Type openGenericInterface)

or

Type closedGenericInterfaceWithParameters = openGenericInterfaceType.MakeGenericType(closedGenericInterfaceWithoutParamerters.GetGenericArguments());

From the source code to CodeCampServer specifically from /trunk/src/Infrastructure/DependencyRegistry.cs. Please also note the typing error in the second declaration.

Is this what we get for relying on keyword completion (Intellisense) too much these days?