THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Is The Paid-Article Website Dead?

This blog has moved! You can find this content at the following new location:

Published Sunday, December 27, 2009 11:13 AM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



AaronBertrand said:


every time I see a link to a site I know is paid, I don't think "I must join that site some time", I simply automatically skip over their content.


I am absolutely 100% the same way.  By way of being an MVP I could get a free membership to the most notoriously annoying of them, but I decline.  I just don't feel right encouraging paid-for sites that in many cases just have copies of articles that are free elsewhere.

December 27, 2009 9:58 AM

andyleonard said:

Hi Greg,

  A couple thoughts...

  Sites can generate revenue without charging subscription fees. This isn't a new idea, a lot of the diminishing print publications are surviving in this manner. (Some have always survived via advertising.)

  "Pay" is an interesting term. The transfer of capital can take many forms - all of which directly or indirectly lead to economic transfer of wealth.

:{> Andy

December 27, 2009 12:17 PM

Greg Low said:

Hi Andy,

Yes, I suspect that advertising is the main option here. Rather than "user" pays, I think we still need another model for funding content.

Alternately, efforts like SQLServerPedia that Brent has been putting in place might well be the future of all such content.



December 27, 2009 7:57 PM

Alex K said:

Is it really good enough? I randomly opened an article on sqlserverpedia. Enjoy:

"SQL Server supports nesting transactions, however, writing nested transactions is usually not a good idea. The problem with nested transactions is that ROLLBACK and COMMIT statements affect multiple open transactions. Nested transactions usually occur when one stored procedure begins a transaction and then calls other procedures also using transactions before commiting the initial transaction. However, a single stored procedure could also have multiple transactions open at the same time.

Despite the common belief that nested transaction problems can be mitigated by using named transactions, ROLLBACK and COMMIT statements don't behave as you would expect from the first glance. ROLLBACK TRANSACTION only maintains the name of the outermost transaction ; if you try rolling back any transaction except the outermost one, your statement will fail. The COMMIT TRAN statement, on the other hand will not fail; however, it will only commit the inner transaction, without releasing the exclusive locks until the outermost transaction is explicitly committed or rolled back. If the outermost transaction is rolled back, then all inner transactions are also rolled back, regardless of whether or not you previously committed the inner transactions. "

Do you think that reading this good enough article was worth your time?

December 27, 2009 8:04 PM

Alex K said:

Although there is abundance of free information online, plenty of customers willingly pay for high quality information. Consider Wall Street Journal, which seems to be doing very well. Go to their website, most articles are for subscribers only. But their articles are their own content and they are high quality indeed.

I am willing to pay for high quality information which is interesting to me. Me and my team read books by Itzik Ben Gan, Adam Machanic, Kalen Delaney, and other excellent authors, and paying money for the books is a form of saying thank you to the authors for their excellent work. But we do not subscribe to sites that charge money for aggregating free content, as we do not need this service.

As long as we work with the technology, we would rather pay for high quality work than waste our time reading low quality free articles. However, I disagree with Jonathan Kehayias - unlike him, I am not saying that all free articles are of low quality. He had a blog post some time ago where he stated that articles from paid magazines should be trusted more than blog posts.

December 27, 2009 10:25 PM

Brent Ozar said:

Alex - sorry that the random article you opened wasn't worth your time.  I totally understand that for experts like you and me, not every article is going to be of value.  Sometimes beginners have different interests than the more senior guys.

The cool part about SQLServerPedia, though, is that if you don't find an article useful, you can edit it - right now!  You can create an account and start improving things that you're not satisfied with, thereby making the transition from lurker to contributor.  I think you'll find it can be even more satisfying than leaving comments.

Feel free to let me know if you've got questions about it, too.

December 28, 2009 8:12 AM

a.m. said:

Alex: SQLServerPedia allows anyone to write content; the goal of that site is to get the Quest name into search engines by getting lots and lots of indexable text (a.k.a. keywords) onto the site. That's a big difference between it and this site: we don't sell anything, and only want lots of GREAT content, so we vet potential writers. And even with our system we've had some less-than-ideal content posted here. Nothing is perfect in the world of free content (nor in the world of paid content, but at least there you sometimes have articles that have been tech reviewed)...

December 28, 2009 10:24 AM

Alex K said:

Hi Brent,

I really like the other site you participated in creating,, and I enjoy contributing to that one. Regarding my previous comment, sorry I was not clear. The topic about nested transactions, or that in fact there are no nested transactions in Transact SQL, is very interesting. Yet this particular article IMO could be slightly improved. I do not think it is currently completely correct. This interesting topic deserves a fuller description.

Challenge accepted ;).

December 28, 2009 11:45 PM

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement