I recently faced reinstalling a Windows 8 machine, without knowing the key used for deployment on it was an upgrade key. Not wanting to wipe the drive (again), dig up a Windows 7 key, then installing Windows 8 again, I googled and found this advice at Lifehacker, which worked brilliantly: If you do a clean […]
To avoid locking a table for a damn long time, this is how Google told me to do mass copies of data in Microsoft SQL Server: DECLARE @BatchSize INT = 1000 DECLARE @IdMax INT = 25179272 DECLARE @i INT = 0 WHILE @i <= @IdMax BEGIN INSERT INTO [mydata].[dbo].[ProjectEventValues] WITH (TABLOCK) ([projectId] ,[descId] ,[index] ,[controllerId] […]
Got a small SSD as your C drive? So do I. Storing your documents on a network drive? Yep. Want to index that network drive, to include it in libraries, searches, etc? You bet. You’ll want to move your offline cache. Create a folder for your offline file cache. Something like D:\Cache From an elevated […]
This error seems to pop up every now and again when I configure a new IIS server, even if I do remember to check the ASP option during the initial role selection. Here’s how to resolve it (run as admin) on a 64-bit system: %windir%\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -i ..and on a 32-bit system: %windir%\Microsoft.NET\Framework\v4.0.21006\aspnet_regiis.exe -i
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’
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 […]
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 […]
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 […]
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 […]
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 […]