Okay, I'm following the lead of Joe Webb, who recently posted My Most Popular Posts From 2010.
- I think it can be a very useful exercise to go back and look at what blog posts were popular and, arguably more importantly, which posts were most thought-provoking and generated the most dialog (whether it is praise, heckling, or a mixture).
- I think you can a learn a lot about your blogging habits and perhaps where to focus energy in the future.
- You can also be quite surprised at which posts go viral and which don't … for example, I thought my Denali topics and posts from my "Bad Habits to Kick" series would have dominated the top 10 in both counts, but that was not the case.
- I'm going to list the top 10 in each category here, but in chronological order rather than proper rank.
- I think it is more interesting to see that – aside from a quiet summer – the top posts were distributed well throughout the year as opposed to being centered around a particular month – though, to Joe's point, neither list has a post from December, even though that month represented 18 of my 116 blog posts from last year (15.5%).
- Those that are in both lists are denoted with an asterisk (*) – less correlation here than I thought, also.
Most Unique Views
- 01-05 : My experiences upgrading 2005 => 2008
- 02-04 : When bad error messages happen to good people
- 02-08 : Bad Habits to Kick : putting an IDENTITY column on every table *
- 03-10 : The ethics of aggregating other peoples' content *
- 03-15 : Yes, you can benefit from both data and backup compression
- 05-18 : New cumulative updates for SQL Server 2008 SP1 & R2!
- 09-29 : This time it's for real – SQL Server 2008 Service Pack 2 is available!
- 10-21 : A first glimpse of SQL Sentry's Plan Explorer
- 10-26 : Useful, free resources for SQL Server *
- 11-23 : SQL Server v.Next (Denali) : The New SSMS *
Most Comments
This exercise was likely a lot more useful for me than for you, but I hope it was interesting to at least one of you.
Nice way to slice & dice the data, Aaron.