Either way works fine.  I like the Detach and Attach methods, they take almost no time, while a backup and restore obviously has to copy everything record by record.  We...

Heck, I would!  Making my worst enemy type Guids all day would be awesome!

Seriously, there is no reason for any user to ever even see a Guid, much less need...

Excellent, factual article Andy.

I started using GUIDs as Primary Keys for the very reasons mentioned in your article several years ago (SQL 7 also has NEWID as a function).  My...

Whoops, my bad.  You are using SQL 2000, we're on 2005.  My comment probably doesn't apply.

You didn't mention whether you were using the 32 bit or 64 bit version of Win2003 Server.  With the 64 bit you don't need to mess with the switches at...

The bottom line message in this article is "Comment your code if it's not absolutely clear what you are doing". 

I like that.  It's what I do.  It's what I...

I've used identical pairs of Linksys routers several times with great success.  They are not hard to setup, they stay setup and they make it easy to map several computers...

We do this, backing up a 40 gig database across a 1 gigabit fiber link to another server.  The impact on the primary server is noticible but certainly not unacceptable. ...

I'm still searching for the answer to this.  Does anyone have any experience, or even any decent guesses?

I'm still fighting this problem.  Does anyone even have any good guesses?

Nice ad.

I'd say it's a bit more than a rumor.  From the About page at the very link you quoted:

The current configuration is the scale-out configuration first deployed in November 2003....

We've got yet another reason to use the DB storage method.  We allow hundreds of customers to trade work between themselves.  This includes attachments that move from one customer to...

Query Analyzer hands down.  Show Execution Plan option specifically.  The version 7 one, 2005 still has me looking around for an old friend.

And who has the time to design, code and test 300 different User Interfaces under the Setup portion of the Application?  We're talking about values that seldom if ever get...