The Changing Face of Community

July 7, 2009 · Posted in SQL Server 

Alt title: NNTP is Dead. Long Live the King! I am not old school like BBS’s and gopher but I have been online since 95. I didn’t get into SQL until about 99. Back then there were mostly just NNTP usenet groups and majordomo style mailing lists for SQL communities. I loved both of them up until a few years ago. I got bored with them. I got bored with the internet in general. I jumped back into the SQL NNTP group and MSDN forums in 2007. To be honest, it was mainly to promote my blog by having a link in my sig. I was turned off by it because there were like 10 answerers to every person asking questions. The same 10 questions get asked every other day. For answerers, they are rewarded for quantity instead of quality. Am I jaded? Maybe :) Then I found twitter along with other social sites and it was like there was this new thing called the Internet again. It is more than just twitter. Twitter is the glue that combines blogging, RSS feeds, Facebook(and others), mobile social networking, real time search, and an open web. Not quite sure what it is called….. Anyway, I was curious if others are thinking the same way, if it is affecting traditional communities and what the future holds. I researched and came across these interest tables. Messages by Month for Microsoft.public.sqlserver.server since inception

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1996 3 12 13 96 35 26 41 350
1997 897 855 1018 1317 1356 1180 1171 1091 1614 1418 1297 1530
1998 1828 1853 2022 1983 1831 1919 2004 1822 1833 1956 2170 1920
1999 2994 2997 3487 2954 3399 3650 3437 3793 3581 3506 3829 3333
2000 4130 3611 4056 3785 3614 4006 4129 4349 3820 4287 4583 3642
2001 4840 3901 4381 4470 5229 4424 4169 4996 3905 5056 4539 4716
2002 5335 5076 5018 4843 4679 4197 4986 3877 3548 4655 3655 3864
2003 6178 5181 5003 5082 4767 4657 4809 4989 4930 4896 4575 4079
2004 4195 4158 4044 3182 3619 4618 3960 3727 4061 3870 3789 3390
2005 3542 3457 3971 3480 2881 3749 3157 3732 3186 3260 3234 2919
2006 3681 2740 3284 3218 3658 3380 3340 3633 2794 3072 3073 2440
2007 3218 2569 2623 2396 2551 2449 2189 2583 2389 2501 2619 1717
2008 2339 1724 1664 1648 1649 1784 1913 1623 1429 1560 1298 1085
2009 1576 1166 1112 1368 1262 1360 163

Messages by Month for Microsoft.public.sqlserver.programming since inception

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1992 2
1996 5 17 113 29 40 72 344
1997 907 746 809 895 904 831 877 964 1263 1187 975 1108
1998 1558 1661 1854 1718 1774 1911 1774 1751 1982 2110 2159 2081
1999 2414 2642 3006 3130 2950 3441 3350 3797 3890 3739 3878 3473
2000 4255 3891 4497 4064 4750 4673 4711 5604 4941 5501 5571 4625
2001 5974 5306 6048 6789 7677 7567 6946 7907 6147 8486 7652 6668
2002 8784 8228 9041 8827 8192 7410 7808 6598 6496 7264 6825 6243
2003 8438 8108 8623 8010 7723 7542 8060 7377 7216 7246 6553 6352
2004 6843 6499 7355 5304 5883 6761 6634 6567 6593 6266 6227 6161
2005 5854 5898 6697 7108 5876 5714 5957 7182 5656 5891 6146 5462
2006 6696 5768 5528 6076 6364 5660 5448 5519 5506 5340 4645 4364
2007 5265 4337 4637 3980 4060 4188 4462 4099 3551 4042 3679 3218
2008 3762 3207 3607 3783 3321 2793 3752 2941 2760 2671 1989 1830
2009 2377 1729 1893 1636 1975 1974 261

Both peaked in 2003. If I had to guess, the decline from 2004-2007 was because HTTP forums like MSDN and third parties became more popular. What is really interesting is looking at the % of drop from 2007-2008 and 2008-2009 vs. the previous same month year over year drops from 2004-2007. The decline on NNTP is hastening. The biggest drops have occurred when the SQL Server community really embraced social networking apps like twitter and facebook along with sites like StackOverflow. That is my hypothesis. No proof. Just cold hard unforgining numbers to interpret. Watching the trend as time progresses will be interesting. I am not happy that NTTP is declining but happy that something better is taking its place. Thoughts? P.S. Change is good otherwise we would be living in caves bonking small animals with clubs.

This content is published under the Attribution-Share Alike 3.0 Unported license.

Comments

  • Where did the comments go??
  • statisticsio
    I am still learning Wordpress apparently...
    http://jasonmassie.com/archive/2009/01/the-chan...
  • port 119 should be banished into the information superhighway trashcan as soon as possible also :P

    Is it possible because these days we have less apsm on the newsgroups (yeah right, just kidding)

    Maybe a lot of the people from these newsgroups migrated to the msdn forums? I did notice that the traffic is much better there than let's say 2 years ago
blog comments powered by Disqus