If you rename a host on which MSSQL is running, the MSSQL server will not be renamed internally, causing the error message “Invalid Urn filter on server level” to pop up. What this means, in this case, is that the connected SQL server doesn’t match the name the client has for it. You can check […]
I recently had some issues with a flaky VPN service. I wanted to make a little script I could run on a different machine that would restart the VPN connection, should it break. This particular VPN connection included a DNS service for the remote .local-domain, which I decided to use for testing, but you could […]
Sometimes, when I’m just screwing around with some software, Windows security just gets in my way. Here are the things I wanted gone this time, and where to find them: Strong password enforcement and password aging: Administrative tools => Local Security Policy (secpol.msc) => Account Policies => Password Policy Ctrl+alt+del to login: Administrative tools => […]
Found this on xiph.org. If you think you need 24 bit audio, and that you can actually hear the difference, you need to read it. You also need to do a blind test with their provided audio files. Archived here, just in case.
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 […]
Just learned something neat: In XChat, if you hold ctrl and shift, and then press “u”, followed by “a”, you get a weird character that signifies a line break. This can be used to put several commands on one line in the configuration, or to type several lines before spamming them all at once into […]
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] […]
I recently had to repair the Switched Mode Power Supply for my RockWheel (a one-wheeled electric “vehicle”). Looking around for some general guidelines, since I hadn’t touched line voltage in a while, I found this guide over here useful. Archived here for archival purposes…
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