Thursday, January 14, 2010

.Net 4.0 and Azure

We were mapping out a release schedule for one of our Azure based applications today, and a major part of the application needs to be completely refactored to eliminate tight coupling between our WPF client and our server application.  This coupling is exacerbated by the inability to properly XML serialize some of our Entity Framework 1.0 objects due to the recursive traversal capabilities of EF 1.0.  We’d like to push the refactor back until EF 4.0 is available, but that brought up the question of when .NET 4.0 would be available on Azure. 

There is no set release data for Azure with .NET 4.0 support at this time. However, Scott Guthrie mentioned on his blog on Dec 17th that

“We are working with the Azure folks right now to try and get .NET 4 installed on it as soon as possible.  Unfortunately I don't have an exact ETA yet.”

However, the Azure team this week (today since Thursday is their deployment day) did a release to include an ‘OS Version’ attribute for roles so you could specify a particular Azure Build level when deploying. It will default to the most current version if you don’t set it, so it is a way to ensure that if you don’t want to be upgraded, you won’t be. Right now, they only support one version of the Azure OS. This has to be a precursor to the .NET 4 rollout, and something we have been trying to get them to include since our very first meeting with the Azure Team back in November 2008.  I haven’t looked at the feature in detail, but I’m glad they’ve addressed the concern.

My guess is that they will have to spin up .NET 4.0 support well before the commercial launch of .NET 4 because of the integral role of Azure in VS2010, and that in order for final testing to happen, they’ll have to allow full .NET 4.0 Azure deployments. Kind of a chicken and egg thing.  Stay tuned.

Setting up VS2008 For Windows Mobile 6.1 Development

There are a few tricks to setting up your PC for Windows Mobile 6.1 Development that are needed to get moving.  Of course some of this will depend on exactly what you want to do in Windows Mobile.

My project was pretty simple.

  1. Create a Windows Mobile Forms app that interfaces with a Motorola M9090-G scanning device that allows a user of the scanner to scan their employee badge barcode, a barcode for a shipping document, and a barcode for a series of packages.
  2. The user will scan a large number of packages, and then send their scan records in a batch to a central database for further processing.  The user may or may not be close to a wireless access point at the time of the scan.
  3. The app has to be fast.   The folks using this device will fly through dozens of packages a minute, and there will be multiple scanners working to unload a truck, but there are logical gaps in the loading and unloading where the app can upload to the database.

It’s pretty obvious I needed a client cache for the data.  I chose Microsoft SQL Server CE.  For the backend data store, we’re using SQL Server 2008 (with Change Tracking turned on)

I didn’t want to custom build a synchronization methodology, and since I played with Microsoft Sync Services a bit last spring on another project, it seemed like a good place to start.

First off, VS2008 SP1 comes with a number of emulators built in, but no Windows Mobile 6 emulators.  In order to get the right emulators installed, download the following, and install in the following order.  You’ll need to shut down VS2008 to complete this install.

  1. Windows Mobile 6 Profession and Standard Software Development Kits Refresh
  2. Windows Mobile 6 Professional Images (USA).msi
  3. Microsoft Windows Mobile Device Center Driver
  4. Microsoft SQL Server CE for Devices
  5. Microsoft Synchronization Services for ADO.NET for devices – note that you cannot user Sync Services 2.0, as it is not device ready yet.

You should now be able to fire up VS2008 and create a new Smart Device Project.  Make sure you set it up for Windows Mobile 6, or you’ll not have all the options you need, and will have to start over.

One mistake I made, was not realizing that there is a different version of Microsoft SQL Server CE for Devices than for PCs.  You will need to download the correct version to get everything to work.

I strongly suggest creating two solutions for this type of an application.  One for the Mobile client, and one for the WCF Service, whether it be a Windows Service or a Web Service.  It makes it a lot easier to debug, and helps to ensure that you don’t try to deploy Mobile targeted assemblies to the server and vice versa.  The IDE should prevent you from doing it, but it doesn’t hurt to take this approach anyway.

I like writing code, but I like getting projects done even more.  So if I find code out there that works, I’m not afraid to put it to use.  There were a couple of projects I found that really help to do some of the heavy lifting:

  1. SyncComm on Codeplex.  This provides you with all the plumbing you need to get Windows Mobile Sync working in your project.  If there is one thing I would change (and did) in the project, it was to break the ClientService.cs up into another partial class to remove the customizations that were done to it.  I have found three methods that I moved into a separate file.  Otherwise the code gets wiped out when you regenerate it.  Cost me an hour of work.  See code below.
  2. Custom Message Encoder: Compression Encoder on MSDN.  Download the sample there.  The download link is trickily hidden under the title of the article.  This provides you with all kinds of samples.  The one you want to go to is under <installroot>\WCFSamples\WCF\Extensibility\MessageEncoder\Compression\CS.  Take the GZipEncoder and add the project to your server solution.
public ServerClient(System.ServiceModel.EndpointAddress endPointAddress, BindingType bindingType)



        : this(GetBinding(bindingType), endPointAddress)



    { }



 



    static Binding GetBinding(BindingType bindingType)



    {



        Binding binding;



 



        switch (bindingType)



        {



            case BindingType.Basic:



                binding = CreateDefaultBinding();



                break;



            case BindingType.Compressed:



                binding = CreateCompressionBinding();



                break;



            default:



                throw new ArgumentException("BindingType value not excepted");



        }



 



        return binding;



    }



 



    //NOTE:



    //set compressed endpoint binding custom properties here



    public static Binding CreateCompressionBinding()



    {



        // Create a CustomBinding



        var customBinding = new CustomBinding();



        // Create a compression binding element



        var compressionBindingElmnt = new CompressionMessageEncodingBindingElement();



        // ..and add to the custom binding



        customBinding.Elements.Add(compressionBindingElmnt);



 



        // Create an HttpTransportBindingElement and add that as well



        var httpBindingElement = new HttpTransportBindingElement();



 



 



        //TODO



        //Set here desired values. Take care to match such values 



        //in app.config in SyncComm host project



        //max buffer size



        //httpBindingElement.MaxBufferSize = int.MaxValue;



        //max received message size



        //httpBindingElement.MaxReceivedMessageSize = long.MaxValue;



        //max buffer pool size



        //httpBindingElement.MaxBufferPoolSize = long.MaxValue;



 



        customBinding.Elements.Add(httpBindingElement);



 



        return customBinding;



 



    }




In order to get WCF to connect from the Windows Mobile 6 Emulator to a Web Service on the local host, you’ll need to follow the steps listed by Chris Brandsma on StackOverflow.  This is critical and can cause a lot of frustration if you don’t do it.



So as of today, I have a client on my Windows 6 Emulator, a Web Service, and the basic data flowing, though I have a lot of work left to do to test and refine the processing, and to test on an actual device.  I’m sure I’ll find a few more issues, but I wanted to note what I had done to this point, just in case I need to replicate the process on another PC or build server here in the near future.



Let me know if this doesn’t work for you.

Monday, January 11, 2010

Windows Mobile versus Windows CE

As I explore the wonderful world of really small screens, I’m having to choose between Windows CE and Windows Mobile.  There are pros and cons to both, and what I’m going to list below is just what I think I know at the moment.  Of course what I thought I knew on Friday has changed a bunch, so I’m sure I’ll be contradicting myself in later posts, if not calling myself a complete idiot.

Windows CE is a term used to describe a variable set of OS components that can be deployed to small devices with limited memory and storage.  If you look at the .NET Framework options available in CE apps, you’ve got very little available.  Certainly no WPF, no Silverlight, no native WCF.  You basically need to build up your OS as you go with these components.

Windows Mobile is built on top of CE, but comes with a more standard (i.e. heavier) package of components and applications built into the OS.  The basic environment to run the application is baked in, but you can add elements from CE type SDKs as needed.

At this point, there seems to be the following CE Environments:

  • 4.2 – Deprecated and generally not supported
  • 5.0 – Most devices can run 5.0.  Its like the XP of the Device world.
  • 6.x – Various incantations of 6.0 are out there, but the adoption rate by the major vendors is slow.  Motorola (who bought Symbol), is the big player in the scanner market, and they’re just releasing their 6.x machines this year, and 6.x hit the market in 2006.

Windows Mobile is on a slightly different pace

  • 5.0 – Seems to be fading fast
  • 6.0, 6.1 – Are the mainstay of the Windows Mobile Market place, though being surpassed on phones by 6.5
  • 6.5 – The current version, though wikipedia says it was never really planned.  It just sort of happened.  I hate it when that happens.
  • 7.0 – The light at the end of the tunnel, coming out sometime this year.  Rumors are swirling that the whole OS will be built in Silverlight.  Microsoft has to come out with something just kick ass to stay relevant in the market.  If Windows Mobile 7 is still based on CE, then that’s a good indication, that they’ve given up on everything except bar code readers.

As I was evaluating the various options, I got that creepy feeling with Windows CE, that if I tied my client to it, or worse, spent the year learning it myself, it would be obsolete before the calendar read 2011.  I was also finding it really difficult to just get going with it, finding the tools I needed to build the software, figuring out how to deploy it, and how to build an emulator for it.  I can’t say that from an architectural perspective, it’s a bad product, but in my gut, I knew it was a dead end.  It hasn’t updated in 4 years.  Even COBOL has been updated in the last 4 years, right?

So I switched my project over to target Windows Mobile 6.1, and within an hour or two (most of that being downloads of SDKs), I was up and running, and realizing just how little real-estate is on a 240px-320px screen.  Now it’s a matter of figuring out Windows Synchronization Services, and I’m off and running.

Tomorrow, I’ll post what I did to get my Visual Studio 2008 ready to build and test the Windows Mobile app, which is something I need to document anyway, since I’ll be getting a new work computer soon, and will need to reinstall it anyway.

Let me know if you think my evaluation is off target.  I’d appreciate the feedback.

Friday, January 8, 2010

Windows Devices

I recently took on a new project at work to build a custom scanning app for one of our customers.  It’s a brand new system, likely to be built on the Motorola (ex-Symbol) MC3090-G or MC90900G platform using either Windows CE or Windows Mobile as the base environment.

I’ve never worked on a mobile device, and the first three days has been something of an adventure.  I’d love to use Silverlight, but the 3090 doesn’t seem to support it.  I’d love to use the Microsoft Sync Framework 2.0, but it looks like that SyncFX 2 does not work on CE, and I’ll have to use 1.0.  I may end up spinning up my own sync processor since the database is dead simple (1, maybe 2 tables). 

What’s weird is that a year ago I was struggling as an early adopter to learn all new concepts for Azure, a new technology with little documentation and an unstable base.  Now I’m trying to use technology that’s been around for quite a while, and changes a lot more slowly than Azure and Windows Desktop, yet the process of learning is just as hard because the documentation all dates back to 2006-2007 and my gut says ‘don’t trust it, it’s old’.

So over the next few weeks, I’ll be blogging more about CE / Win Mobile.  Hopefully others will find this useful to get started, and maybe, just maybe, someone will read this, and be able to point me in the right direction.

Anyone at Microsoft need an early adopter for Windows Mobile 7 + Silverlight on a scanner?  Let me know.  I may consider it if I can’t figure out the other ways sooner than that.

Moral Responsibilities

If you work in the software industry long enough, sooner or later you are going to be asked to do something that comes into conflict with your conscience.  Whether it be to ship with defects in the hopes that no key users will find them before you can get it fixed so you can ship on time, or whether it be to include some arcane EULA agreement into the software that no one will ever read, but gives the software or the company to do anything to your PC, or to gather and distribute any personal information the company wants to sell.  Sooner or later, you will review the strength of your convictions.

When I started out in the industry fifteen years ago, I was an idealist (aren’t we all when we are young).  I can remember tracking my hours religiously to ensure that I got paid for every minute I worked past 40 (this was in Canada and overtime was required… that was nice).  Now, I track hours so I can bill clients, but I have adapted to the term ‘salaried employee’, and I just do the work.  It took a few years to get the ‘overtime’ idea out of my head, but I’m paid well for what I do and I want the small company I work for to be a success.  I also know that I must spend my own time to improve my skill set.  That  was something I didn’t see as my cost of working, just a few short years ago.  My moral values changed over time. 

A few weeks ago, I upgraded all my personal PCs to Windows 7.  One thing I hadn’t done was to install the HP driver software so I could download pictures from my HP C6180 All in One printer.  I could print to it, but I couldn’t see the SIMM card reader to get the photos.  We had a bunch of pictures on the camera I wanted to post for family to see.  I went out to HP’s website and started to download the installer for the drivers.

I stopped the download when I saw it was 340 MB.

Yes, 340 MB.  For drivers.

Now I’m not an expert on driver software, but I recognize bloatware when I see it.  I stopped the download, and attempted to find driver software just to get the ph0tos.  You know, something that will allow me to see the SIMM as a USB device.  HP’s own site (in small letters off to the side), said that if you wanted just the drivers (no network), to search for the Basic package.   I did that.  The only package that came up was one for XP and Windows 2000 Server.  Hmmm.

I got impatient.  I didn’t plan to have my whole evening sucked up with just trying to get pictures off the camera,  That’s supposed to be the easy part.  So I decided to download the 340 MB package and install it.  I knew that the previous version of the software had some really annoying apps that I didn’t want, so I figured at some point during the install I would have a chance to opt out of those. I started clicking through the install.  I got to  the page that asked you to accept the EULA.  I clicked to accept (like anyone reads those), and then clicked next.  I then noticed that the install was about to start without giving me an option to opt out of the bloatware.  Hmmm.

I went back a screen, and re-read it.  On the screen were a series of links that look like they are part of the text, but are really optional installer screens that let you go an opt out of some of the options.  Okay, my fault, I missed it.  But reading on, I see a part that says failure to install all of the options will probably cause the installer to fail.  What?  Scare tactics or honest truth?  Bad software?  I was about to commend them for their honesty, until I went into the screens, and started to see all the crap (pure bloatware) and all the really dangerous stuff (outright spyware) they were about to try to install.  Holy Mother of God.  I’ve never seen such a blatant attempt to take my personal information.

Let me stop here for a second, and go back 29 hours.  The previous day I got a call from my wife that she got a call from our credit card company that they had noticed some unusual activity on our credit cards, and sure enough, someone had stolen our number and was buying stuff at BigLots! and Target in California.  I live on the West Coast, but nowhere near California.  So we cancelled our card, had the charges removed, and everything was taken care of in a couple of hours.  I was a little upset, and briefly talked about the death penalty for credit card theft (a damn fine idea if you ask me), but after a few hours, everything was okay.

Fast forward to last night, sitting in front of my PC, looking at all of this crap.  I was spitting mad.  Mad at HP for creating such a mess.  Mad at HP for knowingly taking advantage of the fact that no one ever reads the EULA.  Mad at HP for violating the trust that we are supposed to have for large purveyors of  hardware and software.  They are supposed to be out there fighting against this kind of thing.  Mad at HP for making software developers do this, because I have to believe that no self-respecting developer would ever do this except against their will in an effort to keep their job.  Mad at the industry that slowly whittles away our moral values to the point that this is acceptable behavior.  Mad at the fact that my elderly parents would install this without questioning it, and expose themselves to all kinds of corporate invasion.

I went through and eliminated the stuff I didn’t want, and installed what I thought was the barebones driver.  But I missed a checkbox, and it still installed something called HP Web Printer Helper.  The next time I fired up a browser, half the screen was taken up by an HP add on that kept asking for special permissions to send information HP to help improve my experience.  What the fuck!?!  Screw that.  Search though the add on list and disabled it.

But then I realized that disabling it wasn’t enough.  My other logins for the rest of the family may still have it installed and active.   So I went back into Control Panel and removed anything from HP that was questionable.  I was still pissed.

I popped on to HP’s site, looked through their contact page, and fired off a long note to the HP CEO Mark something or other.  There was a 3500 word limit.  I may have been close.  I doubt if I’ll hear back, and I doubt even more if HP will change their evil ways.  I was ready to call for an all out boycott, but I realized that I liked the HP EX 490 Home Server I recently purchased too much not to recommend that one to other people.

Instead, I’ll simply document my experience here, and hope that my tale takes root, and those roots break the concrete of corporate greed and malfeasance.

So be forewarned, those of you who blindly approve all EULAs from supposedly trustworthy companies.  They know it, and they’re starting to take advantage of that fact.  Scary.

Thursday, January 7, 2010

Bug in Entity Framework

I found a great little bug in Entity Framework this morning.  One of their exception handlers can throw an exception, that hides the true exception.  Here’s how to recreate this:

  1. Set your thread culture to a neutral culture:  i.e. ‘en’ instead of ‘en-US’
  2. Create a new EF Context
  3. Find an object (A) that has a dependency to another object (B) via foreign key and B has a dependency to object C via another foreign key.
  4. Create a new object of type A called ‘a’
  5. Get object B and detach it from the database (as if you were getting it in via a web service call).  B should lose it’s link to C
  6. Add object B to A
  7. Attempt to add A to the database via the context.AddToA(a)
  8. Call context.SaveChanges().

What you should get is

System.Data.Entity  Type: System.Data.UpdateException  Message: Entities in '[contextName].B partticipate in the 'FK_B_C' relationship. 0 related 'C' were found. 1 'C' is expected.

What you will get is:

System.NotSupportedException: Culture 'en' is a neutral culture. It cannot be used in formatting and parsing and therefore cannot be set as the thread's current culture.     at System.Globalization.CultureInfo.CheckNeutral(CultureInfo culture)     at System.Globalization.CultureInfo.get_NumberFormat()     at System.Globalization.NumberFormatInfo.GetInstance(IFormatProvider formatProvider)     at System.Data.EntityUtil.ConvertCardinalityToString(Nullable`1 cardinality)     at System.Data.EntityUtil.UpdateRelationshipCardinalityConstraintViolation(String relationshipSetName, Int32 minimumCount, Nullable`1 maximumCount, String entitySetName, Int32 actualCount, String otherEndPluralName, IEntityStateEntry stateEntry)     at System.Data.Mapping.Update.Internal.UpdateTranslator.RelationshipConstraintValidator.ValidateConstraints()     at System.Data.Mapping.Update.Internal.UpdateTranslator.ProduceCommands()     at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)     at System.Data.EntityClient.EntityAdapter.Update(IEntityStateManager entityCache)     at System.Data.Objects.ObjectContext.SaveChanges(Boolean acceptChangesDuringSave)     at System.Data.Objects.ObjectContext.SaveChanges()  

The only way to get the real error, is to change your current culture from a neutral to a specific culture.  I’ve never seen this one before, and I had a few minutes of head scratching before we got the real cause.

Friday, January 1, 2010

Evolution

I have evolved.  Well, not me personally, but the technology in my house has definitely undergone an evolution over the past few months.  Or at least a refresh.  It was a long time coming, and there’s still a way left to go, but here’s where I started from, where I am now, and where I think I still need to upgrade.

Last year at this time I had the following:

  • Home Computer:  Dell XPS 410 pretty much a standard ship from the factory (without the TV card) running Vista Ultimate bought in 2005
  • My Laptop:  Toshiba U405-2854 running Vista Ultimate bought in 2008
  • My Wife’s Laptop:  Dell Latitude 550  running Windows XP bought in 2004
  • Phones:  Qwest RAZR with limited texting (2 phones bought in 2005 appx $70/month charges)
  • Internet Connection:  Qwest DSL 1.5 MB Download, .3 MB Upload ($30 / month)
  • TV Connection:  Comcast Basic Cable ($78/month with DVR and 2 cable boxes)
  • Game System:  Standard XBox circa 2004
  • Backup Strategy:  Used Windows Live Mesh for my writing and personal docs, plus a Maxtor 300 GB US Backup drive with Norton Backup (Never worked right)

A number of factors came together over the past year to cause me to spend a bunch of time and a bunch of money upgrading various technical aspects of my life

1. We upgraded from the basic Qwest Phones to Apple IPhone 3GS with unlimited data from AT&T last spring.  I was happy with the phone I had, but Qwest was discontinuing wireless in our area, and we had to choose a new plan.  I left it up to my wife to pick a new plan / phone for us.  I’ve been fairly satisfied with the IPhone on the whole.  I use the phone every day, for far more than I thought I ever would (who needs web / email on their phone, I used to say), but I actually regret having email on my phone.  I have it linked into my work email, and at times I feel obliged to answer emails at odd hours of the night.  There is nothing worse than getting home on a Friday night, ready for a good, relaxing weekend, only to see an emergency email pop into your box at 6:00 PM.  A year ago, that email would have waited there just fine until Monday morning, and no one would have cared.  I may not work two jobs like some people I know, but I have one job that takes up twice the time it used to.

I am not happy with ITunes, but that is a whole other story.

2.  My wife’s computer, the Dell 550, is a beast, both in weight and in the heat it puts out.  It would literally burn your legs if you left it on your lap for too long.  In November, she finally ordered a new laptop, an HP.  That was the same week I went to Microsoft PDC, and received a new ACER 1420P laptop running Windows 7 courtesy of Microsoft.  We promptly returned the HP unopened, and swapped / upgraded laptops.  She got my Toshiba (just over a year old) and I got the Acer.  If you’ve read my blog, you know what I think of the ACER.  I got the raw end of the deal, and would switch with my wife if it wasn’t such a pain to move ITunes from one machine to another.  Unless I can find a glare reducer for the ACER, I’ll probably replace it before 2010 is done.

We upgraded my wife’s Toshiba to Windows 7, and the Dell XPS 410 to Windows 7 as well.

3.  With the money we originally had budgeted for the new Laptop, we bought an HP-490 MediaSmart Home Server.  I love this box.  Easy to do the initial setup, looks good, runs quiet.  I added an extra 1.5 TB of disk into it so it could spread the load over multiple disks.

4.  I then splurged on a new XBox 360 Elite with the 120 GB hard drive, with the idea that I could use it an a media extender for my home server.  I also got the idea that with a little planning, I could drop the $78/month Comcast bill, and make back the money I spent on the XBox in less than 6 months.  This is where my plan started to run into some trouble, and also where the story gets interesting.

First off, I wanted to put my media server and XBox 360 in my Home Entertainment center, hard wire them to my wireless router and DSL line, then run my desktop off a wireless USB receiver.  A few problems cropped up.

a)  Running a desktop PC off a USB Wireless G (Linksys WUSB54GC) when you are frequently remote desktopped into you work PC from there is a complete disaster waiting to happen.  Of course the morning after I set this all up, I had to be up at 4:00 AM to talk to someone in India, and my connection kept getting dropped, and I had to go pull the router back out of the entertainment center and put it back into my office just to finish the chat.

b) 1.5 MB download over Qwest DSL is not fast enough to watch movies on Netflix or TV shows on Hulu.  I thought initially I’d be able to upgrade to 7 or 12 MB on Qwest, but that level is not available in my neighborhood.  Time to call Comcast.

c) In order to watch internet TV on the XBox 360 from the HP Homeserver, you need to install a product like PlayOn Media Server.  The product works pretty well, though the install on WHS is not straightforward.  Follow the special directions as best you can, and do lots of Google searches. The HP 490 does have one critical flaw for those of you who want to run PlayOn to stream Internet TV.  The CPU is a little slow.  In hindsight, upgrading to the 495 with the Dual Core CPU would have been a better deal.

I also went out and bought the XBox N Wireless antenna, and had Comcast Upgrade my router to N as well.

Once I confirmed that Comcast could give me the service level I needed, I was able to drop my TV cable plan from the $78/month to $13.50 a month by going with their very basic plan, and getting rid of the Comcast DVR.  I bought a Hauppauge 1850 Win-TV-HVR PCI-E card and popped that into the last PCI-E slot on the Dell XPS 410 to act as my TV guide / tuner.  That brought up another issue though with the Dell 410.  Drive space.  The Dell is supposed to have dual 175 GB drives set up in a Raid 1 configuration.  When I upgraded the machine to Windows 7, it appears that I lost the Raid Configuration, and now I have 175GB C: drive, and 48 GB on the D: drive.  If you try to set up the DVR on the D drive on the digital tuner, you can only record about 4 hours of TV.  If you set it up on the analog channel, you can get about 30 Hours of shows (due HD vs std output.).

5.  We bought a Harmony 900 universal remote.  This thing is a beast, but it does work with everything we have, though not quite perfectly.  We’ve been talking about getting something like this for a very long time, but using the XBox controller as a remote for the DVR was the final straw.

So what was the cost of all this (Roughly, tax excluded)?

IPhones:  $199 each + $170 per month  (We’ll keep those out the final numbers, since my wife can’t hold those against me.)

  • HP 490:  $475
  • Extra 1.5 TB for Home Server:   $90
  • XBox 360:  $350
  • XBox 360 N Connector:  $99
  • USB G Receiver:  $50
  • Hauppauge WinTV Card:  $119
  • PlayOn Media Server:  $40
  • Windows 7 3 Pack for Toshiba and Home PC - $149
  • Microsoft Office 2007 Home edition 3 pack - $129
  • Harmony 900 – $274 ($138 by using a bunch of Christmas Gift certificates)

Total Hardware / Software Cost:  $1501

  • New: Comcast TV – 13.50 / month
  • New: Comcast Internet:  $20/month for 6 month (25MB down, 8 MB up), $45 / month after 6 months
  • New Total Cost / Month:  $33.50 / 58.50 after 6 months
  • Original Cost / Month:  $30 (Qwest) + 80 (Comcast) = $110.
  • Savings after 6 months:  450
  • Savings after 12 months: 450 + 300 = $700.

So after 1 year, I will have saved about $700, so it will take me about 2 years to break even.

But I also gained a more reliable backup system (worth quite a bit to me).

I also turned my WHS into a Web Server and Host my own website there (www.joebeernink.com), which I was hosting on Windows Azure, but since they are about to start charging outrageous amounts of money, I was going to have to switch to GoDaddy.com ($4 / month).  But this way I can try more things with my web site and set up others as well.  Not a big savings in money there, but honesty, going out to godaddy.com when I’m at work makes me feel like I’m looking at porn on company time.

All of this was a learning experience.  I had some grandiose plans about getting rid of Comcast for good if I could get fast enough DSL speeds, and find all the TV content I wanted on-line, but alas, neither the former or the latter is completely possible, yet.

For someone about to go through all this themselves, here are a few tips.

  1. Confirm your DSL provider can give you the speed you want before you start.
  2. The HP Home Server is great, but get the 495.
  3. Don’t try all this with Windows Vista.  Wait till you have Windows 7
  4. Upgrade your wireless to N before you start
  5. Really investigate what you think you will do with you gaming system.  The PS3 might be a better choice if you want to watch BluRay.  The XBox doesn’t support it.  The number one reason I bought the XBox was because most of my friends have it and they play on line.  I haven’t yet had time to play on-line, so maybe that wasn’t the wisest decision
  6. Don’t buy a USB Wireless card for a desktop PC.  Waste of money.
  7. ITunes doesn’t play well with anything.  If you think you will be able to backup your ITunes library to your home server, then play your playlists on your stereo, you will be sadly disappointed.  ITunes playlists are a proprietary format, and not compatible with Windows Media Server.  So don’t promise your wife that this is possible.
  8. If you want to stream music from your media server to your stereo, and you have a TV like mine, you may have to leave your TV on all the time while listening to music, and you’ll have to watch those seizure inducing graphics.  My TV doesn’t pass audio through when the TV isn’t on, and I haven’t yet invested in the XBox to component out audio connector.
  9. Your life will be more complicated with this setup.  Instead of just checking your queue on Netflix and seeing what’s on TV / your DVR, you’ll have to do the following:
    1. Check your Netflix DVD queue
    2. Check your Netflix Instant Play Queue
    3. Check your PC to see what is on your DVR
    4. Copy the shows you don’t have time to watch now over to you media server so your PC doesn’t run out of space.
    5. Look through Hulu for stuff to watch
    6. See what you can watch on-line that can be streamed through the XBox.  Not everything can be.  To me, there’s a whole lot of collusion going on out there that is preventing the internet from being THE source of entertainment content, but the FTC is in the hip pocket of big business, and not going to do what is best for consumers, which would be to give everyone a choice of how to get their content.  My hope is that over time, more content will be integrated into PlayOn so that everything I want to watch is in one place.
  10. Be prepared for things to not work right the first time.  In fact, if you are doing this just to save money, forget it.  You won’t at least not right way, unless you already have most of this hardware.

What’s really weird is that since we’ve started setting this up, I’ve barely had time to watch TV, and I haven’t really missed it.

So what’s on the table for 2010?

  1. Add more disk to my Dell XPS.  Disk is cheap now, and if I added a couple of TB into it, it would go a long way to allowing my to record everything I want to.
  2. Add a second cable splitter into the line coming in to the Dell 410 so I can have both HD and analog feeds, and choose which format to watch / record.
  3. Clean up the directory structure on the Home Server to make things easier to find.
  4. Develop a Home TV guide for everything we might want to watch (how to get to it, restrictions, etc.)
  5. Figure out if I can access my Windows Media Center remotely to allow me to set up recordings while I am away.
  6. Test my backup strategy.  It’s a common saying that you don’t have true backups unless they have been tested.
  7. Replace the ACER 1420P.  We’ll see how long I can cope with this one.

Give me a few more weeks, and we’ll see if I get this all working just right, or get outsourced as the VP of technology in my own home.