It’s useful to include a version in DLLs that you deploy, to make it easy to check what code is actually being used where. We build our projects using TeamCity, and it’s possible to write build scripts that grab the version from an environment variable that TeamCity sets in order…
In today’s episode of not-entirely-obvious RavenDB functionality, I was trying to use the CSV import/export functionality in order to transfer a collection from our live to our test DB, since at the time of writing the “export database” functionality seems to be broken if you try to use it to…
By default, PostgreSQL (PSQL to its friends) formats time intervals in a way that makes it much more human-readable, which is nice until you have intervals longer than a day and you want to manipulate the data further in something like Microsoft Excel. To make the time intervals machine-readable again,…
For those who haven’t yet used it, Slack is a powerful communication platform, based around a chatroom-style way of interacting. I won’t go into details here, except to say that it also has an API that provides various methods to interact with the system, many of which require you to…
Please note: this is written from the perspective of using the Git Bash shell. Clone the repository to be copied into a new location to ensure it is a fresh checkout git clone old-repo-url checkout-location cd into checkout-location, and run the following to checkout all branches from the remote: for…
(If you haven’t yet seen it, Gitolite is a set of scripts for configuring a central Git server – see https://github.com/sitaramc/gitolite) Renaming a repository is simple and fairly painless: Log onto your Git server (and any slaves), go to the repositories directory (by default it’s at ~/repositories), and rename your…
[Unfortunately] we have a non-transparent proxy set up at work. Putting discussions about that aside, we’ve recently been looking at automating the provisioning of our infrastructure with Chef. When installing IIS using the community cookbook, which relies on Microsoft’s Web Platform Installer (WebPI), the proxy causes the following error: InternetOpenUrl…
I had an issue recently when using the NServiceBus.Testing library (version 2.6.0.1504, which is a bit outdated now, but the problem is still interesting). The NServiceBus.Testing library comes with the popular Rhino Mocks framework built in, so by adding a reference to NServiceBus.Testing you automatically end up with the Rhino.Mocks…
For some reason (possibly to do with dependencies), Microsoft buried the latest version of FxCop (v10.0.30319.1) inside a Windows SDK, so you have to download a ~570MB file to get at a ~3MB installer for FxCop. For future convenience, I’ve uploaded it here so you can download it from the…
By putting SQL Server into single-user mode, you can log in using any Windows administrator account with sysadmin permissions, even if an equivalent SQL login does not exist. This is very useful when you’ve lost sysadmin access (not-entirely-hypothetical example: someone set up a database, removed all sysadmin accounts except sa,…