I think the addition of varchar(max) and the xml data types are pretty compelling. Not exciting stuff, but they can really clean up the way you solve problems.

I'll also suggest...

Looks like a valid technique to me. Good article.

Cookie would be easiest, definitely don't pass it over in the query string.

Agree. Header comments are a good idea, as are inline comments. I'd suggest mirroing whatever commenting guidelines you use for 'real' code. Keep it simple, stick to it!

I wrote up a bunch of notes about managing the service while back - here is a link to the first one: http://www.sqlservercentral.com/columnists/awarren/startingandstoppingsqlserverpart1.asp

Good article. Nothing like a challenge to get others at work interested who normally might not be. I'd be curious to hear what your gang thinks of all the other...

It is good to spend a part of the weekend remembering why we have Memorial Day, and making sure our children, nieces and nephews understand too.

Of course, I bet all...

Have you tried putting the data into a new file instead of an existing one?

I thought the article was badly named - should have been something 'Building Test Data Faster with TSQL' or something like that.

Select Scope_Identity() will return the value of the last row inserted in that table on the current spid. SQL 7 users have to use @@Identity. I've got an article posted...

That blog post is a great find, though Im with you in that I'll have to read it a few more times. Im biased of course, but I think Database...

It's not just a matter of upgrading the software, at some point the people have to be upgraded too. It's definitely hard to stay current when your employer is still...

I think I'd rather have someone a little intimidated by the responsibility on the job rather than someone who isn't. Many of us have worked with databases containing sensitive data...

Since you're storing the OCR'd text, you could just go with plan A - when someone requests the record return the stored OCR text, or actually run the OCR right...

I agree that we expect to see MS tools and work, and expect them to do the job reasonably well. It's just not often that they delight. I do think...