iGoogle - How to Remove Left Navigation Bar

October 20, 2008 – 8:51 am

Log into iGoogle recently? Are the changes on the left side not to your liking? Well, it appears that Google haven’t added an option to change it back to the way it was, but a Slashdot poster has a working solution (required Firefox and Adblock Plus). From the Slashdot post:

NVW55V (994264) Alter Relationship  on Sun 19 Oct 10:34PM (#25436735) 
This Adblock Plus rule will remove the new left tab: google.com#TD(class=leftborder)
Just create a new filter in Adblock Plus with the content in bold above, and refresh the iGoogle page.

SQL Server Management Studio Access to Remote Domains

August 5, 2008 – 2:26 pm

So you need to access a SQL Server (2005) using the SQL Server Management Studio. The server is running with Active Directory only authentication, but your laptop isn’t in the target domain and you only have access to the SQL server port (TCP 1433). What to do?

Well, Galin Iliev has the answer. By using the runas command with the /netonly switch, you can pass credentials to the Management Studio which are used for access to the remote server. Only correction to Galin’s post is that the SQL Server Management Studio executable is sqlwb.exe instead of ssmsee.exe.

So for us road warrior consultants, there is a way to access AD credentialed SQL server databases without have to join a domain or have any more network access than the TCP/IP port for the SQL server.

Buying E-Books from Foreign Countries

August 3, 2008 – 12:00 pm

Grand Cayman is a wonderful place to vacation, and after four days of sun, sand, and drinks, we are on our way home. But with only a few lackluster books to read on my Kindle, how to get content?

For those traveling with laptops, the good news is that Cable & Wireless now offers free wi-fi in the Cayman departure terminal. This is new since November of 2007, and is in line with the same server C&W offers in the Barbados airport. Thank you for this service, and I dearly hope your separation from C&W PLC does the Caribbean market good, and not gouge the islands you still serve.

But browsing the Amazon store and attempting to 1-click purchase comes back with the message:

“We could not process your order because of geographical restrictions on the product which you were attempting to purchase. Please refer to the terms of use for this product to determine the geographical restrictions.”

Hmm. Okay, let’s see:

  1. RDP to home system
  2. Browse the book title and buy it “in the United States”
  3. Navigate the media library and download the .AZW title
  4. E-mail it to myself so it’s an attachment on my Macbook Pro
  5. From my laptop, web mail access and download the file
  6. Connect the Kindle and copy the file over

Viola! I could have spent time going through a proxy server located in the United States or setting up one of my own,  but this was an in-place option.

The book should suffice the two hour wait in the lounge, the three hour flight to Atlanta, and then the two hour transit via MARTA to our car.

SanDisk Cruzer & Washer

April 16, 2008 – 5:59 pm

Take one SanDisk 2GB flash drive, add to a not-so-good Sears HE4T washer, then wash, rinse, and repeat. It didn’t make it to the dryer, smells like Downy, but still works. The driver source for the Realtek Ethernet controller is still on it, and it reads and writes like new.

And smells better! It is amazing what key chain devices like this can go through nowadays.

Three Months with the Amazon Kindle

March 28, 2008 – 11:45 pm

With a remarkable amount of press, both good and bad, Amazon’s Kindle evokes a response one way or the other. That is, for people who have a clue as to what a “Kindle” is as a product. For the last three months I’ve used my Kindle almost daily, and overall it’s a welcome addition to the tech gadgets I take with me almost everywhere.

It’s not perfect, and the cost alone is a deterrent to purchase. There are some fundamental issues that should be addressed in the next iteration, and others that have been resolved.

For Want of an E-Book Reader

I read a lot of books. Maybe 2-3 novels a month on average, and if I pick up a book in a series that turns out to be good, I may read 4-6 books over the course of the month until the entire series is read. To help consolidate the ever growing collection of books, I looked at the older Sony PRS-500 e-book reader at a Borders while in Redmond in June 2007. It was… okay, but non-intuitive and didn’t capture my interest. But having attempted to read content on an Apple Newton, Palm Pilot, and other small screen mobile devices, the e-ink technology of the Sony appealed to me.

When the new Sony PRS-505 e-book reader was announced in October 2007, I contemplated buying one sight-unseen, but then saw the pre-announcement information for the Amazon Kindle. My first impression was that the Kindle was ugly, had features I didn’t need (or thought I needed at the time), and was too expensive. It’s still too expensive, but I like the look and the features make the unit intuitive to use.
As the reviews came out on the new Sony and the hardware solidified on the Kindle, I decided to order one. Thanksgiving came and went, relatives visited, and it wasn’t until the Saturday after Thanksgiving that I finally placed the order. They were already sold out at this point, and I had a mid-December delivery date.

One other justification was my wife. She reads anywhere from 8-12 books a month, on average. My thought was we could share a Kindle between the both of us, and over the course of a couple years pay for the device on book savings alone.

Enter the Kindle

When my Kindle was finally delivered on time in mid-December, getting it operational was easy. The packaging is reminiscent of Apple, but is slightly less polished. The instructions to turn the unit on were easy to understand, and the wireless worked well. The one issue was that the battery indicator didn’t read properly, and it took about 6 hours to fully charge the battery.

As my first e-book device, there are things I initially liked and disliked about it. The good points:

  • Intuitive - The buttons, shortcuts and navigation were easy to pick up. The scroll wheel / clicker became second nature after only a few minutes of use.
  • Screen - Although not backlit or supporting more than 2-bit grayscale (capable of displaying 4 levels of gray), the screen is of good resolution for text (600×800 pixels, or 167 ppi). As it uses e-ink technology, there is a flash as it refreshes the screen.
  • Standards - The Kindle has 180MB of free internal storage, but takes SD memory cards, up to 4GB in size. Also, file formats supported include Mobipocket (PRC or MOBI) and the ability convert other formats for use on the Kindle.
  • Whispernet - This is the Sprint EVDO network built-in for use in the US. It’s great being able to quickly purchase a book or subscription, and for infrequent use, the web browser is handle too.

There are some aspects that I don’t like, or meet my specific needs:

  • Cost - It’s USD$400. That is $100 more than the Sony, and even with discounts on digital books, represented a substantial investment.
  • Power - The devices AC power adpater works as advertized, but USB charging is deficient. It can take up to 24 hours to fully recharge the Kindle via USB, or 6 hours via the AC adapter. As a frequent traveler, I like to reduce my power adapters to my laptop only, which can provide USB power to recharge other devices.
  • Cover - The cover is okay and provides protection to the device when moving around. But the method to secure it is teneous, and over time has become loose. There is only one other third party cover on the market at present, and it too is getting mediocre reviews.
  • Lack of Content - Amazon started around 95,000 titles available at launch, and at the time of writing, were only up to 110,000 titles. A lot of my favorite authors such as Frank Herbert and Peter F. Hamilton are not well represented either.

My Use at Home

I take my Kindle almost everywhere including work, shopping with the wife, and when traveling. Of course it gets good use at home too, in almost every room.

At home the Kindle is just like any other book or magazine. On the couch, before going to sleep, or when waiting for a process to finish on the computer, the Kindle is there and usable. I keep it in the screen saver mode to prevent accidental key presses turning pages. Going from the screen saver in-use take about 5 seconds, and brings you back to the previous document you were reading.

Although I have a few subscriptions from the Kindle store (Wall Street Journal and Salon at present) and have bought about 10 books online, the majority of my books are from free sites such as Project Gutenberg or from “other” sources to augment my already dead-tree versions of books. I use my XP workstation to convert the various formats to PRC (Mobipocket) and then copy them over to the Kindle (it appears as a USB mass storage device when plugged into a PC).

I have bought some books from the Kindle store from authors I’ve read (Stephen King, Stephen Donaldson), and others based upon the recommendation of the store, such as Ken Follett and Elizabeth Bear.

Reading at Work

My main use of the Kindle at work is for access to technical sites and the doldrum of meetings. Converting Word documents to MOBI format allow me to have access to various technical notes, FAQs, and other information useful at work.

Kindle in Flight

By far the biggest change the Kindle has had is for travel. My typical pre-Kindle travel , which includes a 1 hour trip on the Atlanta MARTA train to the airport, was either squinting at my Blackberry or listening to podcasts or music on my iPod. Reading while on the way to the airport and waiting for the flight passes the time quickly, and doesn’t have a big hit on battery life.

The biggest change is the amount of reading material I need to take. It never failed that I would be within 50 pages of finishing a book prior to a trip, and the next book was a hardback. And of course, the book to be read would turn out to be mediocre. Now I can have 5-10 books “on deck”, along with a couple subscriptions.

Most of my travel is international, which limits the use of Whispernet to download daily copies of subscriptions. So I try to make sure that there are enough books to cover my trip (and then some). There is also the ability to download content to a PC and transfer via USB, but so far I haven’t had the need to do so.

A couple years back, I’d have a set of noise reducing headphone (Bose, and bulky), a hardback book, paperback book, a magazine, and some for of iPod. I’ve since trimmed this down–not in features, but size. A pair of Shure in ear headphones have replaced the Bose (less bulk and no batteries). An iPod Touch provides music and video content. And, of course, the Kindle contains a goodly selection of reading material.

The only downside to travel is the power situation. My MacBook Pro is the core for recharging my devices, including Blackberry, iPod, and headset. By only having to carry a single power supply and converters for different countries, this reduces my clutter and reduces the space in the laptop bag or suitcase.

Is the Kindle worth it? For me, yes indeed. It has me reading again and reducing the downtime while waiting in lines, doctors offices, and the now 2+ hour airport waits.

Here are some quick links to content and forums on the Kindle, along with a link to a few Kindle cases from my favorite laptop bag designer, who also makes a set of Kindle sleeves and carrying cases:

  • Amazon Kindle Page - Where it all begins
  • Project Gutenberg- One of the original free book sites
  • Manybooks.net - Another site with 20,000+ free titles. The site owner is responsive too
  • MobileRead - Forums for different ebook readers besides the Kindle. Great information not just on the Kindle use, but also on Kindle technical details and hacking (in the good sense).
  • WaterField Designs - Excellent quality laptop bags, so I know the build quality of the Kindle offerings will be top notch. I’ve ordered the slipcase and will post a review once I get it.

Please feel free to leave comments, I’m curious as to how others are using their Kindle and how it’s changed your reading style.

Setting Default View

March 25, 2008 – 7:24 pm

I like Office 2008 for the Mac much better than 2004, but the idiosyncrasies still crop up. To change the default view from Page Layout to Normal, goto the menu Excel->Preferences… then under Authoring select View, Preferred new sheets, set to normal.

You can also change the default font and size here too. You will have to exit Excel and restart for the changes to take effect. Solution found at MacKB.

New AirPort Firmware Adds Time Machine Support to Apple AirPort Extreme Basestation

March 20, 2008 – 1:26 pm

Apple came out with a fireware update for the AirPort Extreme Basestation and Time Capsule. People have reported being able to use exernal USB drives on the AEBS as a Time Machine destination. Great, six days after I got a Time Capsule for backups! :)

I would still shy away from using the AEBS with Time Machine until there is a body of evidence that it works without fault. Some people have reported network drops and even kernel panics, and Apple is famous for not having the best disk support on the AEBS.

Time Capsule - The Good, The Bad, The Ugly

March 15, 2008 – 10:08 pm

Diagram of the back of Time Capsule

Apple announced Time Capsule, a combination wireless access point, network storage (500GB or 1TB), and remote print server at Mac World in January, 2008. It is positioned as an Apple AirPort Extreme Basestation (AEBS) extension for those that need the AEBS’s wireless capabilities, along with network attached storage that actually works.

In our house with have three Apple computers. I use a 15″ MacBook Pro which spends 90%of the time on an Ethernet connection. The wife has a circa 2005 iBook connected via Wi-Fi, when it’s not spending time at Starbucks. A Mac mini, connected via Ethernet to the home network, is used by the kids daily.

Prior to Leopard, I used SuperDuper to create backups on the three computers to a Linux box running samba file sharing. Time Machine is a much more elegant solution, and allows the wife and kids to access backed up information without my assistance. However, the AEBS does not allow for Apple supported Time Machine backups when connecting a USB external drive.

Enter Time Capsule

Luckily (or unluckily to the wallet), I wanted to replace an older Linksys WRT-54g router with an 802.11n device. That, along with the desire to finally use Time Machine to backup the Mac’s, made it an easier decision. I bought the 500GB unit. There are a few external USB drives floating around the house, making it easier to add and scale storage over time.

A Configuration Overview

The network in my house is centralized on an older Cisco 2924EN-XL switch. All devices, with the exception of wireless ones, are connected directly to it. This includes workstations, DHCP/DNS servers, printers, and the Internet router/firewall (pfSense). The wireless access points (AEBS and Time Capsule) are also connected to the switch via the LAN ports (not the WAN uplink port) and run in bridged mode This allows Wi-Fi devices to connect and get IP assignments from the DHCP server.

Installation and Use (Round 1)

The Time Capsule installed with no apparent problems. I say apparent, but I did have to run the AirPort Utility while on wireless to connect to the Time Capsule. Ethernet would show the device details, but wouldn’t allow for a configuration download.

Once the unit was configured similarly to the AEBS (wireless with WPA2, bridged mode, static IP assignment, etc.) and the disk named and configured, I connected my MacBook Pro to Ethernet and started the Time Machine backup. It found the Time Capsule with no problems and the disk information I created. However, once the “preparing” portion was completed (why does this take forever the first time?), transfer speed was about 300-400Kbit/second. Well under the 100Mbit speed between the laptop and the Time Capsule device. The speed was confirmed to be slow by simply trying to copy a file locally to the Time Capsule.

I visit the Apple forums for the AEBS/Time Capsule. Wow. Probably around 10:1 posts hating on the product. My initial fears of getting a lemon product from Apple were starting to come true.

I tried various things such as erasing the disk, power cycling the unit, changing speed/duplex settings on the switch, etc. Finally I called Apple and started the wait. One hour on hold. Speakerphones are great for this, and Apple does have decent on-hold music. But still,an hour Apple? That is more time, in total, then I spent on my MacBook Pro battery replacement.

Installation and Use (Round 2)

Once I got a specialist on the phone, we went through some basic troubleshooting. The few changes and checks made didn’t have any effect. Finally, he had me factory reset the unit by depressing the reset button for 10 seconds with the power connected. But when hooked up to a LAN port on the switch, I couldn’t connect. In hindsight I bet this due to the fact the unit has a 10.x.x.x address on the LAN ports and it’s own DHCP server.

After moving the Time Capsule and cross connecting an Ethernet cable to my laptop, I was able to run the AirPort Utility and reconfigure the unit. The initial configuration was by the assisted config (I normally run advanced). After that, I assigned a static IP address, set the mode to bridged, and placed it back on the switch.

It worked fine and a file copy was at a nominal speed for 100Mbit Ethernet. Sweetness! The only glitch was when I redid the wireless to match the existing SSID and WPA2 settings, the Ethernet side was reset to Internet Connection mode with it’s own DHCP range and address. A final change of that (thank goodness for laptops) completed the configuration.

I’m now 80% of the way through the last Mac establishing the Time Machine backup. The other two systems have the sparse images created and are doing the interim backups with no problems.

Overall, wireless coverage is much improved over the combo AEBS and WRT-54G. Both WAP’s are in the basement, and in the past coverage two floors up was 1-2 bars at most. Now both the laptops and Apple TV have 4-5 bars and nominal speed. No more buffering on YouTube videos.

The Good

The product, so far, meets my expectations. This, in and of itself, makes the product a thumbs-up, especially for Apple households.

  • I like the simplicity of Apple products for most “just work” situations–Time Capsule meets this requirement
  • Supported Time Machine backups
  • Consistent Interface between the AEBS and Time Capsule using AirPort Utility
  • Feature Rich - Internet connection, NAT, printer sharing, network storage, and 802.11n
  • Gigabit ports for LAN and WAN. I can see the LAN port use, but gig speed for WAN (for DSL or Cable modem–per the literature)

The Bad

There are some failings of this product. Some are not particular to my use, but may affect other users.

  • Price - USD $299 for the 500GB model, and USD $499 for 1TB Time Capsule
  • Simplicity - For people doing anything more that casual use and Internet access, such as bittorrent, online gaming, or VoIP, there are not a lot of controls over quality of service or port address translation
  • Resets - Some changes to the configuration may require the unit to restart. Which really stinks when your 95% of the way through an initial Time Machine backup and get a “disconnected” message
  • Tech Support - One hour on hold is way out of line for support, even if it is a toll free number.

The Ugly

I’m pretty sure my problems were due to a corrupted configuration. I’ll watch out for this in the future, and may change my rating of the unit based upon performance, resets, etc.

Summary

The Time Capsule is a welcome addition to my network. The west end of the house now has great coverage, backups are flowing, and the shared storage via Bonjour will be easier for the family to use. In a bridged mode the features of the unit are available by both wired and wireless systems.