As the SQL Team guys point out, horizontal partitioning requires a *lot* of administrative overhead. I would make sure you thoroughly investigate the overhead before you implement this strategy.

I...

Two of your answers are mutually exclusive. One says "You can only use a script", the other says "You can only use Enterprise Manager. You cannot use a...

Well, technically they are "virtual"... so they don't actually "exist" hehe

Anything like this going on in the NJ/NYC area anytime soon?  Thanks!

That's it, just copy the new DLLs into the MSSQL\BINN directory (may require you to stop and restart MSSQLServer service).

That's a very good point.  The handling of punctuation is implementation-specific. ...

Good ideas presented in the article, just one thing I'd like to point out.  In Example 3, you say to use GetDate() in a UDF.  That's not possible since GetDate()...

Thanks Chris, I wrote this as an introductory article to the subject and I'm glad you found it interesting.  I submitted one more on this topic that is a short...

Yeah I think PGP is actually a third-party add-on; I had to roll a version for a bank back in the day on the old ColdFusion platform.

I believe Outlook uses...

Thanks for the comments Rick!  OLAP is going to be a very hot topic and I imagine we'll see a ton of articles on it in the near future.  I...

I just tried it over here and can't reproduce the error.  The result I got from your test string was 'grfg'.  The DLLs don't need to be 'registered' per se, just...

Yup, thanks for keeping me honest!   I don't know what's wrong today - must be a full moon.  The public and private keys...

Thanks for the feedback!

Yeah, I saw the typo in the image after Douglas pointed out the Asymmetric Encryption typo.  I also mis-spelled "voila" as "viola" early on.  That's what I...

A typo was discovered by Douglas Chrystall in the article.  In the section on Asymmetric Encryption, I wrote:

"You encrypt a message with your public key, and it can be decrypted...

Thanks for the reference!  I read Singh's book myself a few years ago and found it very entertaining and informative.  If I recall correctly, he also discusses the future of cryptology: ...

Yes, I forgot to add a title when I submitted it, so Cryptology was added to the title afterwards.  Cryptology includes both Cryptography (securing messages) and Cryptanalysis (defeating cryptography/"codebreaking").  I...