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