Build your own embedded XBMC HTPC

Earlier I wrote an article how to build a cheap XBMC media center with a XBOX1. But nowadays you want a high definition media center and XVID and DIVX isn’t acceptable anymore on your full HD television. So I read a lot of information how to make an nice media streamer like the popcorn hour, ac rayon and xstreamer but then highly customizable . ...

December 1, 2011 · 4 min · thomasf

Howto: Combine or edit subtitles

Run Subtitle Workshop. Tools > Join Subtitles Check the boxes ‘Load file after join’ and ‘Recalculate time values’. [it will load the new combined file and reset the values on the second part of the subs] ‘Add’ the subtitle files and click ‘Join’. The new combined files will load. Click ‘Movie’ and open the movie file and check the subs sync.

August 29, 2008 · 1 min · thomasf

How to shrink a SQL Transaction Log

For 2005: --\* you can get the logical log file name usingthe following command in Query Analizer: exec "databaseName".dbo.sp_helpfile Now execute the following command to shrink the database log to 200MB: DBCC SHRINKFILE ("logicalLogFileName", 200) BACKUP LOG "databaseName" WITH TRUNCATE_ONLY DBCC SHRINKFILE ("logicalLogFileName", 200) –if it doesn’t work, run the two commands again. –When done with that, do a full backup of your db as you will have broken your tlog backup chain. For 2008+ ...

February 20, 2008 · 1 min · thomasf