Posts

DRM hits you coming and going

If you re unfamiliar with the term DRM, it stands for digital rights management. The record (RIAA), movie (MPAA), and software industry has used forms of DRM to prohibit you from sharing your purchased digital goods with others. This continues to be a headache for the honest, while the less honest folks are able to find free "cracked" version of the same materials. Take for example if you purchased music from the likes of Microsoft or Yahoo! You were notified (hopefully) this past year that they will no longer support these services. For reasons that appear to agree with what has been argued all along -- that DRM only impacts honest, paying customers -- Microsoft, Yahoo!, and now Wal-Mart are reversing their business models by discontinuing the DRM practice. Microsoft and Yahoo! have easied up some what on their position, to give you more time to find a work-around, but nevertheless you are left either with losing the music once your current PC dies or the burden of transf

Is your ISP keeping you safe?

Image
Recently a new vulnerability was found in the core of the web surfing systems... the DNS server. The DNS server, short for Domain Name System, is used to translate a websites URL to a websites ip address, the addressing system of the Internet, so your web browser can find the website you are looking for. In order to manage the load of users, there are many, many DNS servers. In fact DNS is provided by ISPs -- either their own or third party systems that they have paid for -- so when you connect through your ISP, you can find the website you want. When the DNS you connect to cannot find a website, it will contact another DNS server to update its records. Likewise, websites will have DNS servers to tell other DNS servers what ip addresses are required for their website. Here's the problem at hand. It has been figured out how a hacker could tell a DNS server a wrong ip address, when the DNS server is updating its records. It does this through forcing the server to ask for a new update

Referencing the value of a cell, not its formula

Image
In Excel, I will use formulas quite frequently for my analysis. At times I want to reference the resulting value of the formula for comparison or to feed another formula. Unfortunately, if you are doing a comparison, Excel will try to compare the formula instead of the formulas results. Well, turns out there is an easy way to correct this. If you want your formula result to be a number, then use the VALUE function. If you want the formula result to be text, use the TEXT function. Here is the syntax for each: VALUE(text) TEXT(value,format_text) -- The format_text value can be any format from the Category box on the Number tab (in the Format Cells dialog box) except General. Here is an example of each: =VALUE(MID(A2,46,FIND("&",A2)-46)) -- this actually finds a number beginning with the 46th character of a string, and continues until it finds the ampersand character. By wrapping the formula with VALUE, I can now compare the number to other numbers in my looku

Faster Firefox

With the release of Google Chrome just weeks ago, speed tweaking tips are popular topics for Firefox. I found a list at TechRadar to be fairly good. Of the 8 tips offered, I am trying the following: 1 - 3, 6, and 8. Not that some of these are as much about perception as really making any difference. But isn't perception all we really care about? If we perceive it to be faster, it must be faster.

Microsoft goes Back to the Future to kick-off TechEd 2007

With all the buzz around Microsoft's latest ad campaign, prior videos are re-appearing. Thanks to Digg, I found this video with Christopher Lloyd as Microsoft kicks-off TechEd 2007. I found most of it quite funny. "Oh, Biff..."

Real iPhone speed, not the commercial speed

As published on the Silicon Alley Insider , here's a video that compares the real speed of an iPhone against the speed you see in the iPhone commercials. In looking at the ad, Apple has clearly cut out much of the connection and load times. Now let's examine the reality of cell phone network speeds. As reported by tests done by Computer World , AT&T's network averaged download speeds of 755Kbit/sec. and average upload speeds of 484Kbit/sec. Computer World also included a 3 second network connection time. With this information, let's calculate the load time for an average 50kb page. Convert our download rate to Kb: 755/8 (8 bits in a byte) = 94.4 Kb/sec Download page time: 50 / 94.4 = 0.53 seconds Total time: connection time of 3 sec + download time of 0.53 seconds = 3.53 sec For us to really get the performance we have come to expect from our computers, it appears the issue right now is the connection times. We can grow our page sizes 6x (and many have) before the

Language Bar keeps returning to Taskbar

Image
I recently got a new laptop with Windows XP and I'm slowly getting it configured to all my preferences. One thing I noticed is that everytime I rebooted, the Language Bar would reappear in the Taskbar. No matter how many times I removed it, it would rear its ugly head again. With a little research, I found out how to stop this nasty behavior. You need to un-register and re-register a DLL that controls the behavior. Specifically, here's what you do: Go to Start and click Run... Enter"Regsvr32.exe /u msimtf.dll" and click OK Go to Start and click Run... Enter "Regsvr32.exe msimtf.dll" and click OK Next time you reboot, it wont show up.