Happy 10th Anniversary

Today marks the 10th Anniversary of this blog. My first post was the 22nd April 2005 and was about passing values in a WinForms application.

A lot of things have changed in the last 10 years, for a start I used to look like this:

Colin Mackay, circa 2005

And now I look more like this:

Colin Mackay, circa 2014

I’m still writing code in C# and with the .NET framework. I’m still writing mostly web applications. But I use a lot more open source, and I’ve created my own open source project now too.

For a period I was a Microsoft MVP (for 4 years), I was also a Code Project MVP as well (for 5 years). I’ve worked for 4 companies in that time, I’ve lived in three places. I found love, and got married (finally!)

I wonder what the next 10 years will bring.


2012 in review

The stats helper monkeys prepared a 2012 annual report for this blog.

WordPress emailed me a very nice summary of my blog stats for 2012. Actually, they emailed me twice because at the start of 2012 I self-hosted then I moved to WordPress when I realised that would be much cheaper and take a lot less effort. The only downside being that I had to give up Google Analytics. Below is a bit of a summary, I’ve tried to combine the numbers from both sides of the fence to give a more accurate picture:


4,329 films were submitted to the 2012 Cannes Film Festival. This blog had 103,000 views in 2012. If each view were a film, this blog would power 24 Film Festivals.In 2012, there were 36 new posts, growing the total archive of this blog to 492 posts.

These are the posts that got the most views in 2012.

  1. Custom error pages and error handling in ASP.NET MVC 3  May 2011
  2. Running Queries on Excel Spreadsheets using SQL Server 2008  August 2011
  3. Entity Framework: Unable to load the specified metadata resource.  July 2011
  4. Getting just the columns you want from Entity Framework, July 2011
  5. Kendo UI: Paging and accessing the filtered results in javaScript  July 2012

The top referring sites were:


Visitors came from 173 countries in all! Most visitors came from The United States. The United Kingdom & India were not far behind.



Browser wars

Every so often I update my chart of the technologies people use to view my blog. The last time was back in October last year, and the chart as it looks now is very interesting. The three major browsers (Internet Explorer, Fire Fox and Chrome) are now converging at around 30% share each. Other browsers such as Opera and Safari don’t get much of a look in. However, it does look like I’ll shortly have to start noting down one or two mobile browsers distinctly. Currently mobile browsers are all lumped into the “Other” category.

Meanwhile, on the operating system front Windows XP continues to slowly ebb away. However, the fact that 30% of the visits to my blog are from a Windows XP machine is still painful to see. Vista users are also dying away and are down to about 6% now. At its current rate of decline there will be more Mac users visiting my blog by the turn of the year.

Google Analytics also has a facility to record page load times, however it is currently only reporting from Internet Explorer and Chrome at the moment. That coupled with only 3 months of data so far doesn’t make for very interesting trend watching. However, in a future update I’m sure I’ll add page load times.


A bit of Google Analytics on my Blog

In the summer of 2007 I added Google Analytics to my blog. Here is some trivia I’ve learned since then

Browser and Operating System stats

Operating System All time Last Month
Windows (All) 95.23% 92.98%
Windows (XP) 52.94% 36.07%
Windows (Vista) 24.01% 9.40%
Windows (7) 17.04% 45.70%
Macintosh (All) 2.51% 3.59%
Linux (All) 1.31% 1.26%
iPhone (All) 0.35% 0.85%
Browser All time Last Month
IE (All) 49.50% 40.87%
IE (7.0) 22.79% 7.44%
IE (8.0) 17.13% 26.01%
IE (6.0) 9.27% 2.33%
IE (9.0) 0.31% 3.83%
Firefox (All) 34.17% 30.01%
Chrome (All) 11.35% 22.86%
Safari (All) 2.08% 3.67%
Opera (All) 2.06% 1.94%


Last month’s top 10 posts

Position Originally
% Post
1 July/2008 12.18 SQL Server Memory Usage
2 June/2009 8.72 Dynamic Objects in C# 4.0
3 Aug/2008 6.37 Installing SQL Server 2005 on Vista
4 July/2009 5.99 Geeky Your Mom Jokes
5 Aug/2008 4.74 SQL Server / Visual Studio Install Order
6 Aug/2007 4.49 Chocolate Crunch Cake
7 June/2007 3.79 Internal Error 2755 caused by folder encryption
8 June/2007 3.70 SQL Exception because of a timeout
9 Oct/2009 3.43 Visual Studio / SQL Server install order on Windows 7
10 Oct/2008 3.09 Method hiding or overriding – or the difference between new and virtual


What is most curious is that 8 of the top ten are in summer months.


Statistics for 2008

It’s the end of the year and as it typical it is time to reflect over the past year. So with that in mind, what are the scores on the doors for my blog? (Stats are from 1st Jan 2008)

Visitors: 32,545 unique visitors.

Browser use: Internet Explorer (60%), Firefox (34%), Opera (2%), Chrome (2%), Safari (1%), etc.

Operating System: Windows (97%), Macintosh (2%), etc. Breaking the Windows variants down: XP (66%), Vista (27%), Server 2003 (4%), 2000 (2%), etc.

Screen resolution: 1280×1024 (27%), 1024×768 (21%), 1280×800 (14%), 1680×1050 (11%), 1440×900 (8%), 1920×1200 (5%), 1600×1200 (3%), etc.

Top ten posts of 2008:

1. Installing SQL Server 2005 on Vista

2. SQL Server / Visual Studio Install Order

3. Tip of the Day #5 (SQL Server memory usage)

4. Using PushPins with the Virtual Earth ASP.NET control

5. What’s New in Visual Studio 2008 Service Pack 1

6. Method hiding or overriding – or the difference between new and virtual

7. Finding things with Virtual Earth

8. Microsoft Surface

9. Drawing lines on the map with the Virtual Earth ASP.NET control

10. Using a different map server with the Virtual Earth ASP.NET controls.

I’ve omitted the home page in the above list, however, if you are curious, it would have come in at #5 had I included it.