Increment or decrement a column in SQL Server

Using SQL on SQL Server, it is easy to decrement or increment a column.

UPDATE t_test
SET inc = inc + 1,
dec = dec - 1
WHERE blah = blah

Restarting the sound system in Ubuntu

There is a really annoying bug that crops up sometimes in which you will get an error message similar to "xine was unable to initialize any audio drivers" or in KDE 4.2 "The audio playback device HDA Intel (AD198x Analog) does not work. Falling back to ."

To fix this, I would normally reboot, but I found a page that specified how to restart the sound system. The instructions, unfortunately did not work for me, and I could not post a follow up.

First run:

$ lsof | grep pcm

The importance of full duplex

I am not a network guru by any means, but I do troubleshoot well, or so I've been told.

A perplexing problem involving HP 3000 connectivity has, hopefully, come to a close today as a vendor recognized an unusual number of errors on a port on one of our switches. This port just happened to be where our netequalizer unit plugged into. Because the netequalizer unit uses a custom Debian variant (yay!) I was able to login and look at the interfaces.


You can now watch the inauguration using Linux and Silverlight

You can now use the Firefox plugin at and the link at to stream the inauguration. This plugin was created in part by Microsoft engineers volunteering for the mono project.

My thoughts on the T-Mobile G1

I have owned the T-Mobile G1 since October. I had been looking for a replacement for the T-Mobile Wing for some time, and being a fan of open source and Linux, I was very excited to read about Android (even exploring Android development using their SDK), and even more excited to learn T-Mobile had the initial offering of an Android based cell phone.

The Seattle P-I goes up for sale

Rumors are now circulating that Seattle's oldest newspaper, the Seattle P-I, may be going up for sale, and if no one buys, may close. Unfortunately, the progression of technology cannot be without some casualties.

Another local newspaper has been advertising for a ColdFusion programmer on and off. I have to wonder how long the newspaper can remain relevant. It will be a sad day when the last issue goes to print; Similar, I imagine, to the last buggy rolling off the assembly line.

The importance of complex passwords

An incident at the popular web service called Twitter has brought to light the importance of complex passwords. A hacker decided to try to break into a popular user's account at the service. He did so by writing an automated tool that used what's called a dictionary attack to try and guess the user's password. He went to bed and let the tool run all night. The next morning, he found he had broken into the user's account, finding the user's password was set to the word "happiness."

Microsoft, Windows 7, and Linux

I read an article on Slashdot detailing an announcement by Microsoft. This announcement states that Windows XP will be available to OEMs, or computer system builders, until May 2009.

Vista was supposed to replace Windows XP on new computers in January of this year. However, sales of Windows Vista and a public outcry persuaded the company to extend the sales of OEM copies of Windows XP through 2010.

Finally splurged and bought a new computer

After realizing my current processor and motherboard was ordered over three years ago, and my current processor, an Athlon XP 3200+, was originally manufactured in 2003, I decided to build a new computer. It has taken me two months to decide what I wanted and to get the funds budgeted, but I finally ordered it tonight.

I purchased the case, an Antec Sonata III 500, over a year ago. It's an expensive case, but one of the best as far as silence and style goes.

Windows 7 be more like Linux

An interesting article on Slashdot pointing to an article at which points out what features Windows 7 must implement.

I'm obviously bias, but I think the author is picking out what he likes most about Linux? It's funny how a few years ago, Linux had to be more like Windows, but now, Windows needs to be more like Linux.


Subscribe to RSS - technology