TDE is Enterprise only.

The author possibly overlooked that in the first sentence the word "coffee" is twice.

In my personal opinion there is missing that part that should disable the PK ... author probably mentioned to put it before those two insert however he didn't.

That's what probably the author meant but it doesn't change the fact that the query as provided returns an error.

I'm aware of this ... but the application can't connect to the mirror just by its name - when the port information is missing ... and this is in my...

This sound logically to me. Good hint. Thank you very much - I need to check this.

Hi, I have the following answer:

When connecting to a mirrored database SQL client always attempts to connect to the primary connection specified in its configuration file first (Server=xxxx). This is...

SIDs checked - they're the same.

I can't check this right now but I'll will ... there is a question then ... assuming you're right - why during failback (Primary becomes again Principal and secondary Mirror)...

As mentioned in my initial post:

>>... ODBC driver where both connection strings configured properly i.e. SERVER=SQL1.company.com,2444 and FAILOVER_PARTNER=SQL2.company.com,2444<<

Again - both connections work when the application starts/restarts. Only the automatic failover...

Hi Neeraj, unless I oversight something important this is not a credentials related issue. If I restart the application when the Secondary server is the Principal - it connects with...

Here is the article you (probably) were looking for: http://technet.microsoft.com/en-us/library/ms183524.aspx

I believe that the group name is not in the correct format i.e. [DOMAIN\GROUP] whether previously specified as a domain group ... and that would very probably cause the...

I'm wondering if it would help to let SQL Server know somehow that [Lat] and [Lon] are actually related to LatLon (geography)?

Maybe something like computed persisted columns:

...,

Lat AS ([LatLon].[Lat]) PERSISTED...

I pressume that CTE might help with tempdb utilization where I'd say that tempdb might be used for temporary storing sub-queries results. I'm looking at the execution plan and wondering...