January 28, 2011 | SQL Server

Greatest Hits : A reflection on my 2010 blog posts

Okay, I'm following the lead of Joe Webb (blog | twitter), 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! 

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

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.

 

3 comments on this post

    • Joe Webb - February 1, 2011, 12:46 AM

      Nice way to slice & dice the data, Aaron.

    • Jerry - February 4, 2011, 12:48 AM

      Your 02-08 link on Identities is broken – it has an extra "%20" at the end.

    • AaronBertrand - February 4, 2011, 1:06 AM

      Thanks Jerry, errant space removed…

Comments are closed.