It's becoming too hard to track all the T-SQL between all versions, so I left this off. SQL 2005 is out of...

My apologies. I think I selected the wrong answer when reworking things. The original answers weren't quite clear, so I altered them.

I have fixed things, and awarded back points.

life is more of an issue with writes than reads. If you are using these mostly for reads, I wouldn't be as worried as if you use them with lots...

I tend to agree with TheSQLGuru, make sure you get enterprise grade SSDs.

TDE encrypts the data at rest, on disk, and the backups. There is CPU overhead for this.

Encrypting the data, so that a DBA or unauthorized user who accesses the database,...

I'm not a replication expert, but all subscribers? Or certain ones?

If I make changes to rows at the publisher with "red", "green" and "blue" values. Does the (or all) subscribers...

I'm slightly confused. You are using a lot of pronouns, and using "replica" a lot and it's not clear what you mean. I assume you mean an individual node...

GSquared (2/1/2012)

---

Looks...

Thanks, Mevio is having issues. I have pinged them.

I need a filter to whack multiple embedded quotes. It can be quite annoying.

you can use SQLCMD to connect to another server and export data, OPENDATASOURCE, or use SSIS to pull data over.

I thought I heard the 2012 certs would be released this year, but I'm not sure.

However Koen has a good point. If SQL Server 2012 is released in April (guess),...

Wow, excellent writeup. Nice rules of thumb as well.

Stephanie J Brown (1/30/2012)

---

I'm not sure I agree with the "companies who would use it don't need it; companies that need it would abuse it" philosophy that some have expressed....

Not that I know of. Named pipes is usually used for local connections. It's not listed as deprecated in the R2 docs: http://msdn.microsoft.com/en-us/library/ms187892.aspx