Monthly Archives: December 2009

Capturing Music Streams

Posted on by

Is there a way that I can save down the music I’m listening too from an Internet stream?

If you use WinAmp, you can use a tool called Streamripper that will save the music down even when you’re not listening.

I do this when I know I’m going to be traveling. I’ll start this up the night before and stream some music to disk and transfer it to my iPod.

Once I’ve listened to the stream, I usually just delete the music to make room for more, random music.

Enjoy.

Force IE8 to IE7 Compatibility Mode

Posted on by

Is there a way that I can force IE8 users to enter IE7 compatibility mode when they hit my website so that I don’t have to change my working IE7 site?

Yes. There is. Details are on this Microsoft blog.

Essentially, there are two ways to implement this:

  • On a per-site basis, add a custom HTTP header

X-UA-Compatible: IE=EmulateIE7

  • On a per-page basis, add a special HTML tag to each document, right after the <head> tag

<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />

I hope that works for you.  I understand from some that even with this setting, you might have to tweak a few things.

Enjoy!

Can’t Access Database After a Restore

Posted on by

I can’t access my SQL Server database after a restore from a SQL Server authentication account.

This happens when you restore a database from a different server. You need to update the database with the appropriate keys for the users on your server; they are still the ids from the old server.

In the database, you can execute this

EXEC sp_change_users_login ‘Report’
 
to list the users. If you have the user your are looking for, you can run this to fix it.
EXEC sp_change_users_login ‘Auto_Fix’, ‘UserNameHere‘
 
If you don’t have the user, you can create one and then run the above statement.
 
I didn’t put much detail on this. You might want look in the sp_change_users_login command to get a better understand of what is happening.
Posted in SQL

DW20.exe is Using 100% CPU

Posted on by

A process named DW20.exe is using 100% of my CPU on my web server and I can’t figure out what is causing it?

This is Microsoft’s error reporting tool (Dr. Watson). If you need to fix the problem immediately, feel free to kill the process when it appears. Your web server will start functioning fine after the process is dead.

In the long run, you can turn it off by following the instructions found here and just turning it off instead of on. By default, it is turned on.