Someone correct me if I'm wrong, but in my understanding the 4GB limit John talked about does not apply in x64 editions of Windows Server 2003 using an x64 edition...

Smallint is 16 bits, d_vis.  Perhaps you are thinking of tinyint?

I partially agree, though.  What need could there possibly be, on a single table, for more than 249 indexes?  Seems...

Of course those will be hard to crack, but they will also be hard to memorize.  I know I wouldn't want to have to memorize a 16-character string that combined...

That's unfortunate.

There are a few places I could have replaced some slightly less graceful code with that.

The example did say "pseudosyntactical," so there's no guarantee that that's actually the way...

Activation would be a pain for this, especially since we rebuild the test servers so often.  The developer edition, at minimum, should never ever ever have activation.

I guess it would...

MS SQL Server is significantly more expensive to run as a multi-user system than ~$800.  If you are doing web development for commercial purposes (ie not for your personal website)...

"Upsert" exists in 2005.

The command is called MERGE.

Here's an example from one of my favorite books on developing with MSSQL 2K5 - Introducing Microsoft SQL Server 2005 for Developers,...

Just for completeness, I'll explain why sentences or multiple words are better than a single password.

Even if someone was to create a dictionary cracker or brute force algorithm that was...

Someone is probably going to hate me for saying something like this, but changing the password more than monthly is really competely unnecessary.

Choose passwords that are 5 or 6 word...