Greatest Hits : A reflection on my 2010 blog posts

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

Most Comments

  • 01-04 : Quick poll : what is your favorite Management Studio tip or trick?
  • 02-01 : Your laptop may be ready for SSDs, but are your SQL Servers?
  • 02-08 : Bad Habits to Kick : putting an IDENTITY column on every table *
  • 02-16 : Bad Habits to Kick : inconsistent table aliasing
  • 03-10 : The ethics of aggregating other peoples' content *
  • 07-07 : Splitting a list of integers : another roundup
  • 08-22 : What's in a Name?
  • 10-18 : Moving on up… but not to the East Side
  • 10-26 : Useful, free resources for SQL Server *
  • 11-23 : SQL Server v.Next (Denali) : The New SSMS *

     
    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.

  • Aaron Bertrand

    I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at SQLPerformance and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

    1 Response

    1. Joe Webb says:

      Nice way to slice & dice the data, Aaron.