bolt | boltblog

Enabling read_committed_snapshot on an existing MSSQL database

Unknownbolt | 2014-12-08

In short, for the database named “internal”: SELECT is_read_committed_snapshot_on,snapshot_isolation_state FROM sys.databases WHERE name=’internal’ ALTER DATABASE [internal] SET allow_snapshot_isolation ON ALTER DATABASE [internal] SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE [internal] SET read_committed_snapshot ON ALTER DATABASE [internal] SET MULTI_USER SELECT is_read_committed_snapshot_on,snapshot_isolation_state FROM sys.databases WHERE name=’internal’

Note to Self: Useful cygwin packages

Unknownbolt | 2014-12-02

vim cron autossh openssh nc wget curl rsync Just jotting these down for myself. UPDATE: installation script

Typing the escape character ^] on a non-english keyboard

Unknownbolt | 2014-12-01

This works on a Norwegian keyboard, but may apply to others. So, your terminal says something like: Connected to foo Escape character is ^] So, ] is easily typed using “Alt Gr + 9” on my keyboard, but “Ctrl + Alt Gr + 9” does not produce an escape character. However, “Ctrl + 5” does, […]

Removing VMware Player or workstation when the Hyper-V role is active

Unknownbolt | 2014-11-10

Blatantly stolen from Jussi Palo’s post here, and archived here. All credit to the original author. Challenge Time to go all in with Windows 8 and migrate development environments to Hyper-V. When you’re migrating from VMware to Hyper-V, and you happen to install Hyper-V before uninstalling VMware Workstation or Player, you will get warning that […]

Make exim4 on Debian respect .forward and /etc/aliases when using a smarthost

Unknownbolt | 2014-11-05

When configured to send all mail through a smarthost, exim4 on Debian will not respect your /etc/aliases file, nor will it care about your users’ ~/.forward files. This is due to the numbering, and consequently the sorting, of the files in /etc/exim4/conf.d/router/. If you look at 200_exim4-config_primary, you’ll see it handles smarthost routing in smarthost […]

Samba servers show up slowly in Network Neighborhood when VMware is installed

Unknownbolt | 2014-11-01

The VMware virtual network adapters can make browsing the Network Neighborhood in Windows a total pain. Try using “net view” in a command console (cmd.exe). The command should return results almost immediately. If it takes upwards of a minute, and you have VMware installed, even just the player, then you have this issue. Go to […]

Resetting an Aeon Labs Z-Stick S2

Unknownbolt | 2014-08-10

From the manual: This must be done through the host software which takes control of the Z-Stick USB adapter while the Z-Stick is in SerialAPI-Mode. If you have the Danfoss ZWave PC Controller, previously available here, you can use the “Reset Controller” button to do so. This works fine in VMware Player too, so you […]

Reverse SSHFS mounts (fs push)

Unknownbolt | 2014-07-14

sshfs is a neat way of mounting a file system from one machine to another over an encrypted ssh channel. However, for machine CLIENT to access a file system that resides on machine HOST, CLIENT must generally be able to log in to HOST. In addition, CLIENT must be able to connect to HOST in […]

regedit access denied

Unknownbolt | 2014-07-08

The registry on newer Windows systems has access control lists. This means that even if you run regedit.exe as an Administrator, you can still get “Access Denied” trying to erase or alter some keys (CurrentControlSet/Enum/USB comes to mind). The solution to this is to run the registry editor as the “System” account, which can be […]

Removing a WIFI-network in Windows 8

Unknownbolt | 2014-04-01

After having to look this up a third time, I found a post on Vonnie’s blog about it. I made a copy here. In short, Microsoft fucked up and you’re left with the command line to do this, unless the wireless network is in range. The following commands list all the WIFI networks you have […]