One of the shortest articles I have ever seen...

"Comments posted to this topic are about the item The Cloud Security Problem, which is is not currently available on the site."

Nice technique, Lori!

I parameterized a few things because, through no fault of my own, my server configurations are like a box of chocolates.

I don't have to deal with clustered SQL...

Thank you very much! Well done.

http://madebysql.blogspot.com/2011/06/database-mirroring-between-server-in.html

Why not recreate the mirror endpoints and use certificates?

Thank you for posting this information, Leo.

I know why someone specified a port. If you don't specify a port, a port between 49152 and 65535 is dynamically allocated. ...

Thank you, Steve!

I, too, had seen the first link. The second link you sent did the trick.

Seth

Very well written, Jason! I appreciate the elimination of the DBCC INPUTBUFFER step after all of my sp_who2 steps.

Thank you gentlemen for your time!

I appreciate the thought given, Kev...

All of the application code uses INTEGERS to compare to the database's DECIMALS except in very few cases where the DECIMAL datatype is actually warranted....

Thanks, Kev, just checking.

Thank you, Michael, for the sanity check.

Very good question, I have no idea how the data is inserted as it is done by a third party application. 'They' have no knowledge of the new DateInserted...

I smell what you are stepping in, Michael. Tail wagging dog, remember? This is the plan I have been instructed to follow: upgrade ServerX from RAID1 to...

Thank you for your response, Michael. Your point is well-taken, I am the dog being wagged by the tail. Bark-bark. 'We' have outgrown the current RAID1 configuration,...

Thank you for taking the time to respond, I truly appreciate your suggestions. I'm resigned to the fact that I'll be re-writing a bunch of stored procedures.