How To

Check the minutes in your cellphone plan instantly

T-Mobile minutes usedI’ve been trying out a Firefox extension that displays the minutes used in my mobile phone plan (I’ve got T-Mobile) since yesterday, and I’m really excited about it. Once you install it, you can configure it to query your plan and display the minutes used out of the total monthly minutes, right in the status bar, at the bottom of the browser window.

One note of caution: make sure you configure it to query seldom, not often (every two or three hours is plenty). It’s not polling a feed, it’s actually running a query on your provider’s database — this is because cellphone companies haven’t yet moved to the Web 2.0, so to speak, and aren’t providing feeds for the users. If you configure it to poll every 5 minutes, it’s going to be deemed excessive by them, and they might cut off your access. So be nice and gentle to their databases. 🙂

The same fellow who came up with this extension, Winston Huang, also wrote another extension to allow you to check your Verizon minutes used. There are also two extensions to allow you to check your Cingular minutes used. Here’s the first, and the second.

These extensions are wonderful productivity tools. You have your minutes used right there in front of you, the whole day. You can pretty much eliminate overage charges, and I’m all for that.

Standard
How To

Four habits that prevent headaches

If you suffer from frequent tension headaches, like I do, the following list of habits might help you prevent them. These are things that work for me:

  • We tend to frown when we’re frustrated or stressed. Become aware of it, and stop it. Relax your forehead, and keep it that way, on purpose, even when under stress.
  • Stop clenching your jaws, and stop chewing gum. These are two actions that will cause tension headaches and jaw pain, not to mention jaw clenching permanently damages your teeth.
  • Drink water frequently. We should get about 8-10 glasses of water per day. 6-8 glasses is also okay, but it’s better to get more if possible.
  • Breathe deeply and get lots of fresh air. Our breathing is usually shallow, and we’re not really circulating the air in our lungs. Breathing deeply helps keep our brain fed with lots of oxygen and keeps the headaches away. If you can open the windows at home or at work, open them. If you can’t, because you work in an office building where that’s not possible, make sure you keep your office door open, and keep your A/C on to circulate the air. Or bring a desk fan and keep it on, to help move the air a little bit. Go outside and take short walks during the day. Make sure to breathe deeply. In your car, don’t keep the A/C on recirculate, let it pull the fresh air from outside. Or open the window or sunroof slightly, to let in the fresh air.

I’ve found that if I do these things, I have tension headaches much less frequently, and I don’t need to load up on Ibuprofen or other headache medication, which is always a good thing.

Standard
How To

If you can’t connect to SQL Server on port 1433

Just had two fun days of troubleshooting this by working together with Adobe/Macromedia support, and found the solution.

Here’s the original issue: could not set up a new data source connecting locally (localhost, 127.0.0.1) to SQL Server 2000 Standard running on the web server; kept getting a SQL Exception error. Was told SQL just wasn’t listening on port 1433, or any TCP port for that matter, even though TCP/IP and Named Pipes were clearly enabled in the SQL Network Config Utility. Even in the registry, port 1433 was specified, yet I could not connect to SQL on TCP by any means. I couldn’t even telnet to the machine on that port.

Turns out that even though I’d upgraded SQL Server 2000 to SP4, I needed to downgrade to SP3. Still doesn’t make sense, after all, MS SPs are supposed to be roll-ups, but hey, that’s what worked. Luckily, the server I was working was running on VMware, so I reverted to a snapshot I took after I installed SQL and before I upgraded to SP4. Installed SP3, and was able to set up the data source immediately! Something to keep in mind if you’re in the same boat.

Standard
How To

If you can't see the photos on this site

Just had a friend tell me he can’t see the photos in my posts, so I called him and we figured out the problem. There are two things to check, and this solution applies to all blogs out there that might have this problem.

  1. Are you at work? If you are, there’s a good chance that your network admins might have blocked photo sharing sites like Flickr. Therefore, all blogs using those sites to host their images will have problems displaying their photos. While the blog might very well come up, the images won’t, and if you don’t know what’s going on, you’ll be wondering if the blog’s owner is in a right state of mind, talking about pictures that aren’t there… But really, everything’s on the up and up, except for your lousy network admins and cheesy IT policies.
  2. Are you using Firefox? If so, have you gone to Tools >> Options >> Content >> Load Images and checked the box next to “For originating site only”? If you did this, no images of any kind (GIF, JPG, PNG, etc.) will show up unless hosted directly on the blog. Uncheck that option, and a whole new world will open up to you. Here’s a screenshot of that Options tab in Firefox.

Load images option in Firefox

Hope this fixes it for you!

Standard
How To

A quick maintenance operation that will prolong the life of your laptop

I upgraded the RAM in my laptop yesterday, and stumbled onto a really easy maintenance job that will most certainly prolong the life your laptop, and help it run faster, cooler and quieter. It sounds impossible to do all that in one fell swoop, but it’s really easy to do, and it works. I’ll give you a hint: it has to do with your laptop’s cooling.

I realize your laptop is going to be different than mine, so my photos may not help you much when it comes to doing this on your own laptop, but bear with me, the principle is the same, and this simple clean-up job will really help.

What I’m talking about is the laptop’s cooling fan assembly. It’s the fan that cools the processor’s heatsink, and is responsible for keeping the processor below the upper temperature threshold. It’s like your car’s radiator. If it wasn’t working, your car would overheat very fast, wouldn’t it? Same thing here, except your laptop’s “radiator” is prone to getting clogged up with dust – lots of it, too.

After about a year and half of using my laptop mostly on clean tables — not on carpets, or my lap, or on tablecloths, as some of us do [!] — I was very, very surprised to find out how much dust had accumulated on my laptop’s cooling grill. I didn’t even open my laptop in order to inspect it. I just wanted to install some extra RAM, but saw the cooling fan and figured, hey, let me open it up even though it looks clean enough from the outside. Boy, was I in for a shocker! Have a look at this photo to see for yourselves.

Cleaning an Averatec 6240 series laptop

You may not think that layer of dust is much, but have a look at a macro photo I took of a piece of it. I used a moist cotton swab to pull off the dust from the grill. Can you see how thick it was? It’s a wonder any air managed to get through!

Cleaning an Averatec 6240 series laptop

In case you’re wondering how I removed the cover from the cooling fan, it’s simple. There were four small screws holding it in place. They were each about the size of those screws you find in the frames of your eyeglasses, so you can use the small screwdriver from a frame repair kit. (If you’re a geek like me, you probably have your own mini-screwdriver set.) After using moist cotton swabs to thoroughly clean the grill, I blew through the grill from both sides of the laptop to make sure no dust was stuck inside. I was out of air spray, so I just used my lungs — if you do the same, be careful, don’t inhale the dust, it doesn’t taste good… Then I also wiped the fan blades clean with more moist cotton swabs, after which I used a couple of dry ones to wipe the entire assembly. Have a look at the finished product. Looks pretty good, doesn’t it?

Cleaning an Averatec 6240 series laptop

The important thing to remember is that most people can do this at home, and it’s a completely user-serviceable operation. I didn’t have to remove any warranty stickers (although my laptop’s out of warranty anyway). As a matter of fact, I only removed the panel that’s supposed to give me access to the RAM. It’s a big panel, so it really gives me access to a lot more stuff.

Cleaning an Averatec 6240 series laptop

If my laptop managed to get that much dust inside after only a year and a half of normal use (on tables and desks), I can’t imagine how much dust there is in other laptops that get used everywhere, and never get cleaned! To me, it’s a miracle that most survive through their projected 3-year lifetimes, and even last beyond that. I have to wonder how much better they’d run if their owners would take the time to clean them out once in a while. My suggestion is that you schedule time to do this cleaning once a year.After I finished, I noticed a difference right away. My laptop is cooler now, and runs much quieter. Before, the fan ran in overdrive most of the time. Now, it only runs at higher speeds when the processor is crunching through difficult operations, which is the way it should be. It also runs a little faster, and it’s more responsive. This also makes sense, because a cooler processor works better. It’s the same principle behind water-cooled processors, which can be overclocked because their temperatures are kept low.

At any rate, I encourage you to open up your laptops and try this for yourselves. But please, make sure they’re turned off, unplugged from any power source, and the batteries are removed before you even think of opening them up. Also, ground yourselves before you touch the circuits. You don’t want to short anything inside with any static electricity you might generate.

Standard