I've been playing with the Amazon Cloud servers just to see what they have to offer.  I thought I would set up a quick little SQL Express database and then connect to it remotely just to play around.  It turned out to be a bit of a pain and so I though I'd share what I did in order to be able to connect to it remotely using management studio. 

After the database was setup and running I made sure that it would accept remote connections (Connected to the Database in Microsoft SQL Server Management Studio -> Right Click Database Instance (localhost\sqlexpress) -> Properties -> Connections -> Make sure "Allow remote connections to this server" checkbox is checked) .  I then tried connecting using Port 1433 and my IP address (We'll pretend my IP is 20.10.20.105 for this entry), but was never able to connect.  So I tried using the command prompt and entering: telnet 20.10.20.105 1433 and still got nothing.  So the first obvious thing to me was that the port was not listening for my connections. I logged back in to the database and ran the command:

use master
go
exec xp_readerrorlog

on my database and found my database was listening on a dynamic port (Text read Server is listening on ['any' <ipv6> 48231].)

I logged on to the EC2 machine and opened the Sql Server Configuration Manager (Start -> All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> SQL Server Configuration Manager).  Then I opened SQL Server Network Configuration ->Protocols for SQLEXPRESS. Open TCP/IP by double clicking.  Then selected IP Addresses tab -> Scroll to the bottom under IPAll.  Here was my dynamic port reading TCP Dynamic Ports 48231.  Under it was a blank TCP Port.  So I added TCP Port 1435 (No rhyme or reason for that number).  I went back and rand the xp_readerrorlog and found that my database was now listening on any <ipv6> 1435 in addtion to the 48231 now.  I thought I was good to go.  NOPE!

I logged in the AWS Management Console and selected Amazon Elastic Cloud Computer EC2 at the top of the screen.  I then see my two instances listed by clicking on instances.  I clicked on the instance I was having trouble with and scolled to the bottom to find my Public DNS ec2-20-10-20-105.us-west-1.compute.amazonaws.com.  (If you don't see your instances, make sure you select the right region on the top left, mine defaults to East region and my instances are in the west). 

I now tried to connect with telnet by using: ec2-20-10-20-105.us-west-1.compute.amazonaws.com 20-10-20-105 1435.  Still nothing!  I was getting very frustrated at this point, but then I remembered the security groups.  Amazon has security groups under the AWS Management Console as well.  I clicked the Security Groups link on the left and opened the security group my instance was on.  At the bottom of the screen I saw two tabs "Details", "Inbound". I opened the "Inbound" tab and found some ports that were open.  I created a new Custom TCP rule with the port range of 1435 and Source: 0.0.0.0/0 (I don't recommend using the 0.0.0.0/0, it opens your port to every IP address, but I was just playing.  Open it for just your IP address if possible.)

I went back to my telnet and Wa La!  I was able to connect remotely. 

I've give my disclaimer right up front, I'm a Microsoft junky. 

I hear a lot of people hyping up Google and what a great search engine they are etc. etc. etc.  Yes, Google has the majority of traffic from internet users, but after analyzing some site statistics for clients the past couple of days, I have come across a very interesting stat.  The bounce rate for Google is more than double that of the bounce rate for Bing!.  What does this mean?  It means that the search results Google gives are not as relevant as those for Bing!  It means that Microsoft's ads for Bing! claiming that their search results are better when using Bing! are actually true.  It means the visitors you get from Bing! are worth more.  You may get twice as many visitors from Google, but in the end only those that "convert" to whatever your site is, are the ones worth measuring. Google seems to just lump a bunch of information together, whereas it appears that Bing! is giving better results. 

Now to admin that I have a problem.  I still use Google out of habit.  I guess that means Google is addictive, but so is cocaine.  Does this mean Google is bad for you? Recognizing a problem is the first step in overcoming, right?

I've been doing some research using the search term "Flex vs Silverlight".  Almost every article I read out there says to use Flex, but they are all written by anti-Microsoft people.  I tend to disagree on this one.  Before you go and start calling me a .Net head, please be aware that I love Adobe products.  I just see some things in Silverlight that Flex doesn't have.  Sure Flex has the "user base", but so does Microsoft...good chance you're reading this using some form of a Microsoft product.  If you answered "No I'm not", I gotcha, you are.  This blog was developed using .NET, a Microsoft product.  Some may not want to admit it, but Silverlight is a valid player in the RIA game.  Flex is great and I won't downplay that at all, but Silverlight is worth looking at. 

There are lots and lots of .NET programmers.  The majority of Flex developers are graphical guys that moved over to the programming camp.  Programming is an afterthought for them, it's not what they truly love.  Now sure the argument can be made "You'll have a better looking app from a graphical guy."  Very true.  So hire a graphical guy to design your silverlight app and then hand it off to a programmer to program the backend.  One of the beauties about Silverlight is this capability.  That being said, your developers are not going to be able to just install the Silverlight API and start programming. There is a bit of a learning curve here, but they will learn Silverlight A LOT faster than Flex because of the familiar feel Silverlight has. 

One of the reasons I feel Silverlight is truly a player now is the majority of Flex pro articles I read point out flaws in Silverlight that are now overcome.  This shows Microsoft is serious about making a go of Silverlight.  Many forward thinking companies are moving to Silverlight.  Netflix believes Microsoft's platform is enough of a player in the game to have gone the Silverlight route.  So here's my top 10 reasons Silverlight is worth taking a look at in the RIA world:

1. A lot of developer's are familiar with the backend code.
2. The logo is just thought provoking (Whether the thought is "What were they thinking?" or "I think that's a cool logo" it's still thought provoking.)
3. Deep Zoom is a cool technology.
4. It's revolutionary for Microsoft.
5. Ability to use existing C# code.
6. XAML is search engine friendly  (For SEO guys this is huge)
7. Ability to use languages like LINQ.
8. Asynchronous tasks.
9. Expression Blend is a cool tool and getting better. 
10. You just don't bet against Microsoft. 

Reasons not to use Silverlight.

1. User base is still low.  (It is growing though and quickly.)
2. Binding methods are confusing and take extra work.
3. Other platform development is non-existent.
4. Printing capabilities are terrible.  (Although Silverlight 4 looks like it has this one fixed.)
5. You like to spend money on development software like Flex Builder.  (Expression Blend is cheaper and there is a free express version)
6. Number of controls has room to grow.
7. It's still considered young and bleeding edge.  (This may be a reason to use it for some)
8. Flex sounds more manly.  (You Flex your muscles.)
9. You don't like to source control your code.
10. You like to bet against Microsoft.

I recently made the jump from Vista to Windows 7.  As far as the interface goes, I don't see much difference, but I do like some of the new features of Windows 7.  I thought I would try out the Windows 7 XP Mode for an old game I could not get to work in regular 7 mode.  I fired up XP Mode and tried to install the game and received this error while running Windows 7 XP Mode:

"Program too big to fit in memory"

I found a pretty quick fix.  All I had to do was:

1. Create an ISO of the game. 
2. Open Virtual Machines
3. Right click the Windows XP Mode machine
4. Click "Settings"
5. Click "DVD Drive" in the left hand column
6. In the right column click the radio button "Open an ISO Image"
7. Browse to the ISO
8. Click OK
9. Launch XP mode virtual machine
10. Open the "DVD Drive" from step 5 in My Computer
11. Launch the installation of the CD using Run or Setup etc.

Pretty quick fix and the game installed very nicely.

Name.com is offering domain names for $5.99 today only.  This is a great deal.  Domains normally cost $8-$10 a year. 

Last Saturday night I realized one of my clients web sites had expired about three weeks ago.  The account owner of the domain had passed away and so no one received the renewal notifications.  I thought it might be useful to explain the process of recovering domain names in case this ever happens to you.

The first thing to do is not panic.  Most of the time you can recover a domain name even after it "expires" or you do not have access to it.  For expired domains, there is a grace period for the owner to redeem their old domain name.  This ranges from a couple weeks to 45 days.  However, retrieving your domain after it expires will typically cost an extra $40+ to recover the name.  It is always best to just renew the domain before it expires. 

If the domain name is not expired, but you do not have access to your domain due to an event such as death or someone leaving your company, you can also regain control of the domain.  Typically you will need to contact the company that the domain is registered through.  Visit www.who.is in order to determine the registrar.  Contact the registrar and explain the situation to them.  They will normally ask you to fax identification and proof that the domain is yours.  After a review period they normally will give you the domain that rightfully belongs to you.

I have been trying to display my most recent posts on the home page of onecubicleover.com.  I was trying to consume the RSS provided by BlogEngine.Net using ASP.NET and C#.  When I used the code:

DataSet ds = new DataSet();
string blogURL = "http://www.onecubicleover.com/blog/syndication.axd";
XmlTextReader rdr = new XmlTextReader(blogURL);
ds.ReadXml(rdr);
datagrid.DataSource = ds.Tables[2];
datagrid.DataBind();

I get the error "A column named 'title' already belongs to this DataTable" when it reaches the ds.ReadXml(rdr) line.  The problem lies in the syndication.axd file.  The tag <title> is used under <channel> as well as under <item>.  A quick XSLT file and <asp:Xml/> control instead of a datagrid on the default.aspx page was the solution for me.  Here's what I used:

On the default.aspx page I placed:

<asp:Xml runat="server" ID="xml1" TransformSource="XSLTFile.xslt" /> 

On the default.aspx.cs page I used

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml;
using System.Xml.Xsl;
using System.Data;

public partial class _default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //Show the latest blog post snippet
        string blogURL = "http://www.onecubicleover.com/blog/syndication.axd";

        XmlDocument rssRead = new XmlDocument();
        rssRead.Load(blogURL);
        xml1.Document = rssRead;

    }
}

And finally my XSLTFile.xslt file:

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

  <xsl:template match="/">
    <table>
      <xsl:for-each select="rss/channel/item">
        <tr>
          <td>
            <xsl:element name="a">
              <xsl:attribute name="href">
                <xsl:value-of select="link"/>
              </xsl:attribute>
              <xsl:value-of select="title"/>
            </xsl:element>
          </td>
        </tr>
      </xsl:for-each>
    </table>
  </xsl:template>
</xsl:stylesheet>

I have completed phase 1 of a site for a new client.  Phase 1 of this web site is a simple brochure type web site.  The web site is www.crazefunzone.com.

Craze Fun Zone is a family entertainment facility located on College Avenue in Rexburg, Idaho.  They pretty much gutted and restored the inside of the old IdaMont hotel.  There is a laser tag arena where the old dance hall was.  In keeping with the IdaMont theme, they named their cafe the IdaMont Cafe where they serve Damburgers in honor of the Teton Dam Flood.  Other features of the company are miniature golf, an arcade, and other family entertainment fun.

Future additions to this site will include a photo gallery slideshow of the different areas of this companies business.

Everytime I go to restore a MySQL database locally that was created from a dump file, I get this error in the GUI interface:

The dump file was not created by MySQL Administrator and could contain unsupported syntax. Hence we cannot restore its content. You can override this behavior by enabling "Ignore errors" on the General page.

Sometimes the "Ignore errors" checkbox has worked, but very rarely. Instead I just restore the database using the command line syntax as follows in a command prompt. Before I run the following, I'll create the database in the GUI and give the user privileges to the database that I want to use to restore.

Navigate to the right directory: C:\cd C:\Program Files\MySQL\MySQL Server 5.0\bin

C:\>mysql -u username -p dbname < restoreFileName

Enter password: ********

For the past month a lot of effort has gone in to the site redesign of Backcountry Secrets.  I basically rebuilt this web site from the ground up.  Some of the features of the new site design are faster page load times, a more pleasing graphic design, and more intuitive user interface.  We also added the ability for members to share photos through Flickr, upload and download KML files that are displayed on Google Maps, and submit user reviews.  One new feature that will help with Search Engine Optimization and keeping users on the site longer is the display of "Points Nearby".  These will be internal links and keep users on the site longer looking at related points.