Another Update: Migrating from Microsoft Exchange to Google Apps now even easier

I've configured and fixed many Microsoft Exchange email implementations over the years but have never hung out my shingle as a Microsoft Exchange guru.  Having now put the Google apps exchange migration tool through its paces in the wild...

Here is my opinion that I'd enjoy hearing different perspectives on:

Migrating from Microsoft Exchange Server 2003 or 2007 to Google Apps Premier Edition is easier and less costly than upgrading to Exchange 2007 or 2010 respectively.

To help out those that currently use Microsoft Exchange:

• Feature debate: Exchange wins in some areas
• Prefer to manage your own in-house servers: Exchange wins
• Entire company loves Outlook: Exchange wins, or maybe not?
• Too much important historic email sitting in Outlook offline email archives: winner?

I'll pause there.  Please comment publicly on blog.  We do moderate all postings but only for politeness, not for opposing opinions.

Update: Migrating from Microsoft Exchange to Google Apps now even easier

We've put the new Microsoft Exchange migration tool through its paces and it's definitely delivering beyond expectations.

What is most impressive is the ability to do parallel processing.  It's now feasible for us to migrate hundreds of users in a single night.  Thousands of users could be done over a weekend with lots of time to spare.

This tool will definitely reduce the cost of customer migrations.

Android Phones and the Google Nexus One from HTC

I've now had sufficient time to put the Google One Nexus through its paces and I fully recommend it to all Google Apps customers.  It's a beautiful phone.  Businesses can save big on IT labour because setup is as simple as turning on the phone and signing the user into their Google Apps account.  Everything instantly integrates; email, calendar, and contacts.

Ask your IT department how many hours they spend on Blackberries, iPhones, and Windows Mobile devices and drop me an email (or comment if you don't mind making it public).  Since I'm a professional accountant I'm interested in calculating the ROI across a range of samples.

Here's what I now recommend to corporations running Google Apps for phones:

1. Google Nexus One running Android OS 2.1.  End user can completely configure it themselves.  It's unlocked so you can swap your Rogers Sim for an AT&T Sim and save big on roaming charges when you travel.  Only minus is that you need to install EasyTether or PdaNet for modem tethering with your notebook.  The LG Eve didn't require extra software for tethering.  I look forward to testing a phone like the Motorola Droid which has a hardware keyboard to see if the setup is just as simple as the Nexus One.
2. iPhone - You have to carefully read the documentation to get the full experience.  We usually help the IT department do the first few but the integration is excellent and second only to the Android.
3. Blackberry - still the preferred unit for speedy typing of emails on the go but it's really showing its age with too much complexity.  It still integrates wonderfully with Google Apps but the IT department definitely has to configure it for most users to get full email, calendar sync, and contacts sync.

Earth Shattering news: Migrating from Microsoft Exchange to Google Apps now even easier

For me as an insider this is teary-eyed stuff.  Customers should care because data migrations to Google Apps from Microsoft Exchange will be easier and more cost effective with this tool.

And our team and I will get to spend less nights waking up multiple times to check on desktop data migrations.  Getting ahead of myself... Let us put it through the paces on our own internal Exchange Server test beds first.  Overall Google has always impressed me with the quality of their product releases.  There are third party tools that do the same but most were poorly documented.

• Migrating from Microsoft Exchange now even easier

Welcome to Canada, Google Nexus One!

I've placed my Nexus One order and will report back on its suitability for business executives as compared to the LG Eve and Blackberry Bold.

Why the Nexus One?  Because I get to deal directly with Google and don't have to wait for Rogers to release software updates.  Our Rogers LG Eve is still on Android OS 1.5.  The Nexus One runs on Android OS 2.1.

The LG Eve running OS 1.5 can't invite multiple attendees to a meeting which is important for the on the road executive.  This was addressed in Android OS 2.0 plus with 2.1 you get Turn-by-turn GPS, Google Earth, etc.

Nexus One now compatible with the AT&T 3G network and shipping to Canada
Rogers Wireless: Welcome to Canada, Google Nexus One!

I'm also keeping an eye on the Samsung Galaxy Spica for $450.  If Rogers release OS 2.1 for the Spica it should be a good phone and less expensive than the Nexus One.

DocVerse joins Google

Google Docs is simply awesome because I can edit and share my documents from any computer instantly from anywhere.  However, it still has to coexist with the 600 million users of Microsoft Office.  It's a pain to remember to upload your Excel spreadsheet to Google Documents every time you change it.

This is the problem that DocVerse solves.  Google just acquired them.  I look forward to seeing how Google integrates DocVerse into their solution offering.

Backup Solutions

I did a business process review with a customer yesterday and we both realized that their years of documents and contracts were stored on a single computer with zero backups.

I woke up early today worrying about my client's data.  There are hundreds of different backup solutions to choose from.  I've tested many.  My favourite is Mozy.  Please install it or call us.  Then we can all sleep better knowing that the data is securely backed up in the cloud.

P.S. Use my referral link https://mozy.com/?ref=VX97E6 or referral code VX97E6 and we both receive an extra 512 Mb of backup space.

Throw away your USB drive

Now that Google Apps allows you to upload files of any type without having to convert them to Google Doc format you can stop carrying around your USB drive.  No more having to remember to copy that complex financial forecast in Microsoft Excel to your notebook hard drive or USB stick.  Just open a web browser at the board meeting, log-in and open the file from Google Docs.

Your Google Apps account starts with a minimum of 10 Gb's of storage.

Gmail and Google Apps Calendar management tips

I think children are sometimes the best test of whether a process is simple or not.  My 6 year old is like most and really doesn't care about daddy being late for something so I built him a schedule on Gmail and made sure it integrates with my schedule on Google apps.  He loves it!

Here's a few tips I think are worth sharing with business users from this exercise:

• Learn how "Quick Add" works.  It's a phenomenal time saver.  Enter "today 800 am Bus to School 20 min" or "wed 2 pm Budget meeting 2 hours".  Google Calendar will automatically create the appropriate appointment for you.  If you get it wrong use the Undo Link that appears as part of the yellow message telling you what you just added.
• Open your calendar, Settings, Labs (Gapps administrator has to allow labs for this to appear)
• Enable the components: "Who's my one-on-one with?", "Free or busy", and my personal and my 6 year old's favourite "Next meeting"

Sure there's a whole bunch of encouragement for my 6 year old that helps too, but now I can leave a screen open that's his schedule (coordinated with dad's and mom's) that he's enjoying keeping up with.

Yikes, I'm 2 minutes late for picking him up for the dentist.  Gotta run.

What if your notebook computer was stolen?

How long would it take for you to be up and running with full access to all Email, Calendaring, and Contacts?

If running Google Apps; as fast as you can get to another computer with a web browser; probably minutes.

If running Microsoft Outlook you have to restore from backups; or if on Exchange configure Outlook on another computer...  I'll spare you the details but probably a few hours at least.

Just had a customer have his notebook stolen while on a trip.  The data in his outlook PST file plus all his Excel spreadsheets is at risk because it wasn't encrypted nor password protected.  Identity and financial information theft is a real possibility.  Sure you can use a Windows password, but a tech guy like me can plug the physical drive into another computer and still access all the data unless it was specifically encrypted.

So buy a better notebook with an encrypted drive like this one from Seagate or upgrade to a more expensive version of windows?  Or simply pay $50/year and store your documents (even in MS Excel format) on highly secure Google Apps servers using Google Documents?

Google Apps allows all browser sessions to use https.  So no data will get transmitted nor stored on the local computer in a usable form for a hacker.

I may sound biased but I'll be recommending the Google Apps solution to my customers. :)

Huge cost savings for Canadians travelling to the U.S. with their cell phone

I've had a few clients run up thousand dollar phone bills while travelling into the U.S. For the past few years I've been swapping my Rogers SIM Card for an AT&T SIM card when I cross the border.

Here are the steps to avoid the outrageous $1.45/minute roaming charges from Rogers:

• Unlock your phone by purchasing an unlock code from http://www.gsmphonesource.com. This is required but only has to be done once. If you break your phone and get a replacement you'll have to unlock it again.
• Buy an AT&T prepaid plan from an AT&T corporate store. You have to go in person. Only the corporate stores will let you pick a number anywhere in the U.S. instead of just their local area. A prepaid plan only requires a credit card. The problem with prepaid is that you can only browse the web with the 100 Mb $19.99 data plan. It will not support BIS which is what allows your Blackberry to use it's built in software for email. Custom email apps like Gmail for the Blackberry will still work though!
• Alternative: Buy a monthly plan asking them to waive the $36 activation fee. Don't tell them you're only using it for a trip. Make sure there are zero penalties if you cancel it if you're "unhappy with the service during the first 30 days". Cancel it when you're done your trip. You must register the account to a U.S. address and it's faster if you have a US dollar credit card to pass the credit check. Pick all the options you want on the plan accordingly for minutes, voice mail, texting, and data. AT&T charges extra for tethering if you want to access the internet from your laptop via a Blackberry (or Android phone) with USB cable but this is cheaper than the $10/day most hotels charge for high speed internet in your room.
• With your Canadian SIM still installed call forward your cell phone to the new AT&T cell number. Note this incurs long distance against your Canadian cell long distance plan every time someone calls it. Alternatively, don't call forward and just check your voicemail frequently. Power down your phone. Remove the battery and slide out your SIM card. Replace it with the AT&T SIM card and test calling it from another phone.
• When you return swap out the SIM card, turn off call forwarding. If your email does not work visit http://rogers.blackberry.com or http://bell.blackberry.com and login. Enter your PIN/IMEI at the prompt. If on Google Apps you'll have to re-start or login to the blue Google Sync icon for your contacts and calendar to continue synchronizing.

End result? You pay as low as $29 for 200 minutes instead of $290 or $1.45/minute with Rogers. AT&T has unlimited plans starting at $69.99/month.

Follow-up on Draytek 2950G

We've been running the Draytek 2950G for a few weeks now and the client is very happy with the results.  It balances the load between the 2 WAN ports much better than the prior NetGear router did.

Here's a screen shot of the Data Flow Monitor during a large file transfer:

And this is the NAT table showing the internet sessions split between the 2 WAN ports.  Since WAN port 1 is 12 Mb/s download compared to 1.5 Mb/s for WAN port 2 it allocates more traffic to WAN port 1.

This router is a great way to combine 2 low cost internet data lines for load balancing and fail over/redundancy.  A Rogers Business Cable line for $99/month plus a Teksavvy high-speed DSL line for $69/month should provide lots of capacity and reliability for most medium sized offices.

Bookmark Sync for Chrome

This is so handy for folks like me that work on multiple computers.  Install or update to the latest Chrome browser and you can synchronize and merge your web page bookmarks across all your computers.

Details are here:
http://googleblog.blogspot.com/2010/01/extensions-bookmark-sync-and-more-for.html

Prior to this 4.0 release I found Chrome had some compatibility issues with certain web sites but it's definitely the no contest performance winner over all other web browsers.

Android Phone OS makes impressive gains

I've been using the LG Eve GW620 Android 3G phone from Rogers for a few weeks now.  I'm extremely impressed by the platform but it is ready for prime time use by heavy business users?

It's awesome if your company is already on Google Apps or Gmail as it synchronizes automatically with your email, calendar, and contacts plus uploads pictures directly into Picasa.  There are no extra applications to install or web accounts to set-up like you have to with a Blackberry.  You also don't need Blackberry Enterprise Server (BES) to make everything insantaneous and eliminate the typical 10 to 15 minute delay for email.  Keeping everything in the Google family certainly makes everything simpler to set-up and simpler to use.

One limitation I've run into is the inability to create new calendar appointments that include other attendees.  Also, I can't run real time stock streaming software like Quotestream, however, I've opened a ticket with Quotemedia to see if there is a work around. (Update: Open this link directly to install the mobile Java version of Quotestream Wireless.  It works but cuts off the edges of the window if you hold the phone horizontally instead of vertically)

The Android phone platform is definitely growing rapidly.  I was surprised to see that Android has 27% market share compared to iPhone's 54% market share for mobile ads displayed.

First Impression: DrayTek Vigor2950G Dual Wan Router

After much research we recently installed the Draytek Vigor2950G Dual Wan Router for a client to replace their NetGear FVS336G.  I'm impressed by its functionality and sophistication for $475 USD.  The NetGear's load balancing was simplistic and couldn't properly utilize the combined bandwidth of the customer's T1 line and Rogers Cable modem.

All of the customer's software applications are cloud computing based so our goal is to provide redundancy, yet still utilize all the bandwidth available for better performance.  We also wanted stronger QoS for consistently clear phone calls over Voip.

We configured the Draytek to allocate up to 75% of the T1 line to Voip/SIP calls.  The 75% can still be used by other traffic but only when it isn't needed for Voip.

There are certainly more expensive firewalls/routers with the same functionality.  So far it's working great.  I'll post again after we've had more time to put it through it paces.

Surf the web via your Blackberry - no Internet stick required

Who likes to pay separately for their Internet stick and its data plan?

I've been using Blackberries to surf the web from my notebook (as tethered modems) for over 3 years yet still very few people know about it.  It's never been simple to configure.  There are no additional monthly costs outside of your existing Blackberry data plan.  Make sure you have a 500 Mb/month plan or greater or it's very pricey.

2 ways to make it work via a USB cable which also charges your battery:

• The old way is complex, details are here but it can be done over Bluetooth or a USB cable.
• The new way is to install Blackberry Desktop 5.0.1 or greater and simply click the IP Modem button but this works only with a USB cable

It works on Rogers Wireless and Bell Mobility.  Should work on Telus but I haven't tested it myself.

There's no need for buying software like Tether for Blackberry. I hope this helps a few people save some money.

Connect your computer to the internet via Rogers LG Eve GW620R Android phone

I was wondering if the tricks that work on my Blackberry for modem tethering to let your computer surf the web from anywhere would work on the LG Eve Android phone from Rogers... and it does!

I tested it on Windows 7 32-bit plus Windows XP on Rogers Wireless and the speeds over 3G are excellent.  These instructions should work for Vista too.

1. Install the GW620R LG Eve USB Drivers from the LG Support page
2. Go to Device Manager, Modems, LG Mobile USB modem, Properties, Advanced and add the extra initialization command +cgdcont=1,"IP","internet.com"
3. From Network and Sharing Center, Set up a new connection or network, Connect to the Internet, Create a new connection, Dial-up, Choose LG Mobile USB Modem
4. Dial-up phone number: *99#, User name: wapuser1, Password: wap
5. Optional Step: Dial up Connection Properties, turn off Prompt for name and password, turn of Prompt for phone number so that you don't have to click the extra prompt each time you connect.

Note that there are driver issues with Windows 7 64-bit so I doubt it will work but let me know if it does.

I initially tested PdaNet for Android which works fine but requires repeatedly turning on Settings, Applications, Development, USB Debugging, plus running the app on the phone and the computer.  It also costs $25 after the trial period.

This means there's no need to purchase an internet stick or run extra software to surf the web from your notebook from anywhere!

Google Apps

This past year I did a fair bit of business strategy consulting for small businesses. Having been through the pain and heavy lifting of building a business myself it's been a lot of fun to counsel others on it.

I quickly saw a theme in small businesses where their company had grown and so too had the complexity and problems with their most mission critical system - Email. One client had implemented Microsoft Exchange for calendaring but was still using ISP based POP3 email accounts and storing all email locally on every employee's computer. Most Exchange consultants are already cringing as they read this but the client didn't know any better and why would they when their focus is on manufacturing high quality products not on information technology (IT). They were sitting on a house of cards that was going to bite them soon if we didn't clean it up but they had no budget for it.

Google Apps has over 2 million businesses using it yet it's surprisingly not well understood by the street. For $50/user/year we gave the client instant disaster recovery, a single system to manage, zero configuration of desktops, no spam software to manage, instant receipt of emails on their blackberries, and accessibility to all email from anywhere on virtually any device. Of course there were some lessons learned along the way too... such as Stockhom Syndrome with users when we tried to take away Outlook.

I enjoyed reading Chris Lyman's blog on Stockholm Syndrome and How Google and the cloud changed my company

Introducing... My Interlock IT blog

I'm a bit strange in being a professional account (CMA) with an insatiable curiosity for technology and gadgets.  I'm lucky that my wife of 16 years, Lesley, a psychotherapist, puts up with my constant tinkering and spending on the latest gizmo's.  Take for example, the birth of our first child in 2003, when I pre-built a website to host all the baby pictures and then spent too many hours trying to find a web cam that could see in the dark.  I ended up buying a camera solution from one of the baby monitor manufacturers that required too many steps to use the picture-in-picture on our TV, and had horrible image quality and lots of static... but I wasn't willing to give up.  Lesley had to stand by the TV and constantly give me feedback until I finally figured out the one spot on the wall that produced a reasonable image but required rearranging all the furniture in the baby room.  What normal wife would put up with that?

Anyway, back to the topic at hand.  For me this blog is about contributing tips that will hopefully help others with their business and technology challenges as similar contributions from others have helped me time and time again.

I love figuring out things that stumped everybody else and most of my solutions are found by scouring the internet forums for ideas. Some would say I'm gifted in my ability to make things work but it comes naturally when you love doing it.

Certainly, I also hope that my blog will generate referrals which are so critical to the long term success of an organically grown consulting firm.