An Experiment Concludes

Home / Misc / An Experiment Concludes
That was hard work

You may or may not have noticed, but every single week day for the month of September, I’ve put up a blog post. Some were short little blurbs linking to some other person’s blog or an article that I decided to comment on. Some were the normal, longer, type of posts that I put up, explaining some bit of technical behavior that has interested me or that I’ve had questions about. This is the last week day of the month and I’m excited to be able to go back to blogging 1-2 times a week again. There was no small amount of stress ensuring that I had posts scheduled out for each day, coming up with ideas, getting them written up.

Whew! It’s over.

The outcome?

Well, first off, it was just a personal goal. Could I do it? That part of the experiment is successful and complete. If I were to do this again, I think I’d do what others have done, 30 Days of X. If I had a single topic that I could come up with 30 blog posts about, I think it would be easier than simply bouncing between query tuning, PASS, Azure, whatever jumped into my head or caught my attention. Note, I’m not saying it would be easy. Putting together blog posts is labor. Well, if you care about them at all it’s labor.

Next, I wanted to see how it would affect… influence? I have two pre-cons coming up, one at the PASS Summit and one in Dallas. I was curious if I could drive more registrations to these events. Also, there was a little contest going on in another location, so I was trying to do well there. How did this turn out. OK, but not great. I have more registrations at the PASS Summit than expected, but it didn’t grow that much through September. Which suggests that my attempts at influence were unsuccessful. I also didn’t do too well in the contest. So, saturation may not be a good way to push influence, at least for me. But, you could argue since I was pushing three different agenda’s I diffused all of them. Not sure, but I’ll chalk it up as failed.

Finally, I wanted to see how posting this often affected my ability to pull people into the blog. Using Google Analytics I can compare this past month with the same month last year and with a month earlier this year. Here’s what the daily page views and average time on the page looked like for this past month (minus part of today):




Here is the same measure one year ago:


And here is the measure from May of this year as an average of my normal blogging (seven posts for the month):


The average time on site in May was 2:54, September 2012 2:52, this month was 0:58. Page views were; May: 7,669, September: 9,612, this month: 10,808.

What does all that tell me? One thing, If not for the single outlier of 1,162 views on September 20th of 2012 (which coincides with presenting at 24 Hours of PASS), the number of views would have been quite a lot less. Still, the number of views, especially the number per day, is up for this past month. Next, more blogging does mean more hits. It doesn’t lead to better quality hits though. And, the increase in hits wasn’t radical. Better? Yeah, but not for the amount of labor that went into it. If putting together 21 posts vs. 7 resulted in a three-fold increase, it would absolutely be worth it. But three times the work for a 10-30% bump… nah.

Oh, and one more thing. I’ve frequently been a very vocal member of the “post your goals” type of people. But, I’ve been reading lately that keeping your mouth shut on your goals and working quietly towards them can be more rewarding and, much more importantly, more successful. It worked well enough I guess. Hard to quantify this one, but I didn’t tell any of you I was doing this before I did it.

In no particular order, some things I think I might have learned from this

  • I am unlikely to do it again
  • Presenting and speaking drives hits as much as, or more than, tweeting, etc.
  • Stick to nerdly posts, they don’t do better than the short ones, but they last longer
  • click bait, or at least my ability to identify it, doesn’t work
  • plus, I’d rather have 3 posts I’m proud of than 15 posts that are junk
  • Day of the week matters, Tuesday is better than Monday. Weird.

areyounotentertainedThanks to all who have ever visited the blog, even by accident (some of the search terms are bizarre). Thanks to all who have ever posted a comment, even, especially, the critical ones. Back to our regular, not-quite scheduled, blogging.



  • ShawnMTherrien

    I think I liked it better when I’d open my RSS reader and occasionally I’d see a Grant blog that I was almost always excited about.

    Recently it’s been more excitement in seeing that there is another Grant blog, but then a lower percentage of them appeal to me.

    Overall I think it’s about the same number of posts that I really enjoy, so I’m complaining!

  • ShawnMTherrien

    Whoops, bad typo!

    Overall I think it’s about the same number of posts that I really enjoy, so I’m *not* complaining!

    lol I would never complain about something that someone puts time into and they give out for free!

  • ShawnMTherrien

    You seem very familiar with Azure. How about AWS?

    My shop went with AWS for their LAMP based software. Now I have a few months for the analysis of keeping MSSQL in a data center moving it to AWS or raising an army to fight for Azure.

    Or do you know someone proficient enough with both to make good comparisons? Brent Ozar had some posts up over a year ago, but most of that information is so outdated with the cloud solutions.

  • Steve Harris

    I nearly always read your articles, there’s a few key SQL authors I like to follow .. including you.

    Looking forward to SQL2014 info

  • I struggle with just getting the occasional GOOD post written and published. I can’t fathom writing one per day – not with a “real” full-time job getting in the way. Kudos to you for completing the experiment.

OK, fine, but what do you think?