Category Archives: Windows

Stuff about Microsoft’s answer to elevator music

Cygwin for Windows XP – fast mirror

Cygwin stopped being compatible with Windows XP in 2016. Following this post on stackoverflow, you can find the setup files and a (very slow) mirror that’s compatible. I made my own, considerably faster, mirror of the last Windows XP compatible Cygwin release, at The mirror date is 2016-08-30, the 30th of August 2016 AD. […]

Installing Windows XP on the Dell Vostro 1700

This is basically the same procedure as installing Windows XP on the Fujitsu Siemens Esprimo u9200, in that it needs custom SATA drivers to find the harddisk during install, as well as a bunch of other ones. For this install, I decided to actually create a driver disk, and use a real floppy drive. I […]

Windows Volume License Keys (VLK)

I keep having to look these up, especially the “Upgrade Key” at the bottom. So I stored them here. Windows Server 2016 Operating system edition KMS Client Setup Key Windows Server 2016 Datacenter CB7KF-BWN84-R7R2Y-793K2-8XDDG Windows Server 2016 Standard WC2BQ-8NRM3-FDDYY-2BFGV-KHKQY Windows Server 2016 Essentials JCKRF-N37P4-C2D82-9YXRT-4M63B Windows 10 Operating system edition KMS Client Setup Key Windows 10 […]

Installing Windows XP on the Fujitsu Siemens Esprimo u9200 in 2017

I recently picked up a brand new vintage 2009 business targeted netbook, sealed in box – the Fujitsu Siemens Esprimo u9200 (fact sheet) (review => archive). At just short of 2KG (4.37 pounds) it’s rather bulky compared to today’s netbooks, but as a rather disposable piece of equipment for travel, which I’d be perfectly fine […]

The Windows XP PowerToys, archived here for your pleasure

These are apparently slowly disappearing from the intertubes. This is my attempt at archiving them. -> DOWNLOAD HERE <- Included PowerToys: Alt-Tab Replacement Task Switcher replaces the simpler Alt-Tab switcher with a more visual one which shows live window previews. CD Slide Show Generator generates a slideshow from photos burned to a CD. ClearType Tuner […]

Setting all SQL Server databases to “simple” recovery model and deleting all the transaction logs

Sometimes, you just want things brutally simple and stupid. I was searching for how to do this, and stumbled upon this post on SQL Server Central. Turns out the query listed there doesn’t handle databases with weird names, containing version numbers with “.” in them, for instance. Thus, I modified it slightly, adding brackets and […]

Debugging SQL Server Query Performance

To enable timing of your query: SET STATISTICS TIME ON Time statistics provides output like this in the “Messages” tab of SSMS after running a query: (127 row(s) affected)  SQL Server Execution Times:    CPU time = 0 ms,  elapsed time = 42 ms. To show IO statistics: SET STATISTICS IO ON ..which provides stuff […]

Force SQL Server Database offline

If you right click a database in SSMS and select Tasks => Take Offline, you might find yourself staring at this dialog for hours, if there are active sessions running queries on your database. Here’s how to force it to go offline, rolling back any current transactions. Replace [dbname] with the name of your database. […]