MS SQL: Reset identity seed

Occasionally, I need to reset the value of the identity column in MS SQL database. I keep forgetting how to do this, and have to search all the time. So here is a note to myself: DBCC CHECKIDENT (TableName, RESEED, 0)

August 13, 2009 · 1 min · 41 words · kenno

Restore Grub Boot Loader

Warning: this guide is only a personal note to remind myself when I have to restore Grub again. In my previous post, I had just installed Windows 7 as a dual boot with Debian on my Toshiba laptop. The following describe the steps taken to restore the Grub boot loader so that Debian can be started again. I booted the laptop with Ubuntu Live CD, then open a Terminal. To get the partition tables, as a root execute the fdisk command: ...

August 8, 2009 · 1 min · 187 words · kenno

Windows 7 64 bit on Toshiba Satellite A200

I just finished installing Windows 7 64-bit Ultimate edtion on my 1+ year old Toshiba laptop. The model is Satellite A200-*****. The installation went smoothly, well almost. On the first boot, the graphic card driver, the finger print reader were automatically updated with Windows update. The only two devices which weren’t detected are: unknown device “ACPITOS6205” (bluetooth) and the Texas Instrument 5-in-1 card reader. The 64-bit driver for the bluetooth can be downloaded from: http://aps2.toshiba-tro.de/bluetooth/ thanks to this post at Toshiba Laptop forum. ...

August 8, 2009 · 1 min · 131 words · kenno

Linq Read Inserted Id of a Record

Suppose we have the following code sinppets: <br /> private BlogDataContext db = new BlogDataContext ();<br /> ... article.Created = DateTime.UtcNow; article.Modified = DateTime.UtcNow; db.Articles.InsertOnSubmit(article); db.SubmitChanges( ); The ID of the article is automatically generated. How do we get the Id of the newly inserted record? It turns out that the article is updated with the value of Id after the method SubmitChanges( ) is invoked. So, we can just get the Id this way: ...

August 4, 2009 · 1 min · 88 words · kenno

Convert wav to m4a with GNU/Linux

There are probably a gazillion ways to do this. I use FAAC, Freeware Advanced Audio Coder, to do this job. It works very well: <br /> faac originalfile.wav -o outputfile.m4a<br />

July 27, 2009 · 1 min · 31 words · kenno