October 26, 2008

iTunes Data Grid Skin

I am playing around with a couple new data grid skins roughly based on what iTunes looks on my Vista box.  Here is how it is looking so far ... iTunes on Vista ...    My iTunes data grid ... Live Demo | Download   Blue and Gray Skins I actually created 2 slightly different skins- a blue and a gray one.  The gray one is above and is a little bit darker.  The blue one is slightly softer and looks like this ...    The Markup The markup for the grid consists of a HTML table with wrapped in a DIV.  I am using the odd/even classes for zebra striping and I also have a DIV above the TABLE for the title bar.  1: <div class="grid"> 2: <!-- title bar ... --> 3: <div class="title">The title goes here</div> 4: <table class="datatable" cellpadding="0" cellspacing="0"> 5: <thead> 6: <!-- header row...

Topics: ASP.NET , jQuery

October 20, 2008

Hiring and The Google Background Check

Stephen Wynkoop posted an interesting question regarding social networks last week on sswug.org.  Basically he is curious if people are using social networking sites to help make hiring decisions.  Here is what he had to say ... I had an interesting question posed today.  The gist of it was that someone was interviewing to fill a DBA position in their company.  One of the interviewees had been doing DBA work for quite some time and seemed like an interesting candidate.  The issue was that searching for this person online resulted in... nothing.  Nothing at all.  No social sites, no posts, no nothing.  Now, it's possible that it was just necessary to keep searching, but it brought up an intriguing question.  If you cannot find someone online - someone that has been working with computers - is this an issue?  If you couldn't find a single post, a single message, a...

Topics: Other

October 18, 2008

Updates to my Live Traffic Page

I made a few more modifications to the Live Traffic page I posted about previously.  Here is what I changed ... New IP to Location Database I replaced the WIPmainia database with the GeoLite City one that Richard Lawley recommended.  For some IP's it can potentially provide location information down to Region/City/Postal Code level (and its still free).  teebot raised a good question about the accuracy of these free IP to Location databases.  The GeoLite web site claims it's database is over 99.3% accurate on a country level and 76% on a city level for the US.  Not too bad ...      Using ASP.NET to Simulate a Windows Service Decoding an IP address to a location isn't an instantaneous operation.  And I have a feeling as I build out the rest dimensions for my Visit/PageView cube it would be nice to run some of the data scrubbing processes some where...

Topics: Other , jQuery

October 12, 2008

Creating a Live Traffic Page from my PageView/Visit Database

I put a screen on top of the pageview data that I recently started collecting.  Thought I would pass along some of the interesting stuff I encountered while building it ... I used the jQuery jTemplate plug-in Dave Ward blogged about to build the rows for the grid.  The data is fetched from a webservice and then sent through the jTemplate templating engine to build the markup for the rows I looked into finding a free IP to Location database that I could bounce incoming IPs against to get some high level geographic information about my visitors (I need something like this anyway for my PageView/Visit cube) Below is what the end product looks like (you can check out the live version here).  And below the screen shot is some additional information regarding the two points above.   Using jTemplate and a Webservice to Populate the Grid I used jQuery's...

Topics: Other , jQuery

October 07, 2008

v0.2 of my Visit/PageView Cube - Creating a Hierarchy for the Source Dimension

So I am still playing around with building an Analysis Services cube from the pageview data I recently started collecting.  Over this past weekend I added a hierarchy to the Source dimension of my cube that gives me a bit more insight about how visitors find their way to my site.  If you read my last post, you saw that I could view my pageview data broken down by two pretty general traffic sources: direct traffic and referring links ...   Well, now with my new hierarchy, I can not only view hit counts by direct traffic, referring site, or search engine ... ... but I can also drill into each of these sources and view my pageviews at a more granular level. I can do this because I have added a bit of preprocessing logic to my cube creation process that sends all referring urls through a very simple...

Topics: Other


Consulting Services

Yep - I also offer consulting services. And heck, I'll do just about anything. If you enjoy my blog just drop me an email describing the work you need done.

Recent Comments

  • TimothyP wrote: I work with tons of developers who haven't even got a clue what Twitter of Facebook is. In fact, it'...
  • Janko wrote: Yes it's strange that people think it's ok to blog at work but consider unethical to use facebook. P...
  • Kam Lagan wrote: Hi Matt, The numbers do seem a little "off" to what you perceived the community would be like. But...
  • Siderite wrote: You're kidding me! So the people that don't blog think it is ok to blog at work (maybe because they ...
  • Guy Harwood wrote: Good to see the results. one typo.... 'What best describes your current job title?' appears twice,...
  • sirrocco wrote: One problem with : DEV I DEV II DEV III was that I didn't know what it meant :( .(is it common ...
  • Jack wrote: How many person fill the survery? Blog is very common, so I don't think 71.5% is high. Maybe our bos...
  • Andy wrote: Done. The developer1, developer2 question - not sure how meaningful the results are going to be for ...