Nice job, Jason. Good explanation, and looking forward to reading about the other join types.

AFAIK, Gail is correct. You do not downgrade from 64 bit to 32 bit. You license the edition. The platform you choose is up to you. 64 bit does not...

I tend to agree with Gus. Despite the good I think it would do, many companies worry that if they release this, they will give something away, or look bad....

You can try something like this: http://www.sqlservercentral.com/articles/Stored+Procedures/tsqldoc/678/

There is still a small chance here that two people would run the SELECT at the same time, then one would get the update lock.

Ultimately, what are you trying to...

You might try restricted_user mode, which only lets Db_owner/sysadmin in. That might work for you.

I might also recommend Andy Leonard's blog: http://sqlblog.com/blogs/andy_leonard/default.aspx.

He is also doing a class later this year on SSIS. You can pick up an SSIS book as well, which will...

I'm not sure what you mean by transaction logging. Do you mean transactional replication? Or log shipping?

Replication works at the table level, and shoots changes across either on a schedule...

I would think that the 32 v 64 doesn't matter for most clients. There are some drivers on the server that might have an issue, but not the client.

Can you...

Ah, I haven't added it to the Zune marketplace. Should, and I can only say I've had a bit of the Apple iPod bias here.

The feeds are:

WMV - http://feeds.feedburner.com/SqlservercentralcomArticlesTaggedEditorial-Wmv

MP4...

sysinternals: http://technet.microsoft.com/en-us/sysinternals/bb896653

Thanks for the update. I was going to suggest IP connections.

The networking gets a little funny at times for SQL Server since we are so used to using the Windows...

Any edition other than Express can restore this.

Be aware if you change versions, as Gail mentioned, you cannot go back to the old version after the restore. You can, however,...

You can use a script like this to kill connections: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31833/

Jeff Moden (1/3/2011)

---

If someone doesn't already have enough reasons to avoid the cloud, here is a recent post that may contain some additional reasons you may not have been aware...