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 […]
Reinstalling Windows XP on an ancient (well, vintage 2009) laptop recently, I suddenly remembered how much I hated the “Favorites” button that’s stuck on the favorites bar and shows you your favorites when you click it, just as the bar already does. This thing: While the rest of the crap, such as the favorites, the […]
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 […]
No introduction here. Let’s get to it. Go to settings Add an external account Enter your existing external email address, e.g. “you@otherdomain.com” Select POP3 Enter your existing credentials The settings shown are for the Cathedral mail server – yours may be different. Contact your provider if you’re not sure. Choose to treat it as an […]
When setting up jails, I commonly end up with structures like this in my /etc/fstab: /dev /jail/test/dev auto bind 0 0 /dev/pts /jail/test/dev/pts auto bind 0 0 /dev/shm /jail/test/dev/shm auto bind 0 0 /proc /jail/test/proc auto bind 0 0 /sys /jail/test/sys auto bind 0 0 /dev /jail/test2/dev auto bind 0 0 /dev/pts /jail/test2/dev/pts auto bind […]
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 […]
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 […]
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. […]
On a Windows machine, you can normally use Start => Run => control userpasswords2 to enable automatic login for a given user when the system boots. On computers that are part of a domain, this is not the case. However, while the functionality is removed from the user interface when you join a domain, it […]
The tempdb database often won’t just shrink when you ask it to, through SSMS or otherwise. Apparently, Sql Server holds on to it for its cache entries. To shrink the table anyway (and have the cache reload), this should do: DBCC FREEPROCCACHE DBCC FREESYSTEMCACHE (‘ALL’) DBCC SHRINKDATABASE (‘tempdb’, 0) Enjoy 🙂