Very nice article! I like this idea. You can also add the SPID of the session that spawned the trigger using @@SPID, and once you have that value, you also...

For the tempDB questions, my advice differs a little from what others are saying.

I agree 100% that most systems do not need 1 data file per CPU (that's logical CPU,...

If they need to do write operations, then mirroring isn't going to work either unless you do something like what ALZDBA recommends. What is the nature of the writes? If...

That's correct. SNAC = SQL Server Native Client

Yes, the 2 phase commit would not affect a read operation.

What access protocol are you using? (SNAC, ODBC, JDBC?) Can you share your connection string (with any sensitive data obfuscated)...

The client does not check the failover partner unless it fails to login to the principal. Can you post a repro?

I'll always answer questions whether you buy my book or not. Help comes with no strings attached.

You can't specify an instance name for the conenction string. only server name (FQDN...

If you only update the log shipping secondary every 2 or 4 hours, then I agree that it becomes a trivial issue.

If you're using log shipping primarily as DR and...

Yes, there are examples and much, much more in the book I wrote. 🙂

Melissa, you have the slash going the wrong direction. Should be / instead of \.

SET WITNESS = 'TCP://MirrorDB\SQLWitness:5033';

Because then you have to kick off users to be able to...

Was that a typo? Does your server really have only 4 GB of RAM? Do you have the 3 GB parameter set or using AWE?

My minimum reccommendation for SQL Server...

I have to question your priorities. The server was down because the master database was corrupted and you opted to deal with WMI permissions first?

I love this reply!! This is by far the best response!!

+1