The question was great and I liked the explanation of the table lock mechanism in SQL Server.

Thanks

Great and interesting question on the new features.

Easy question. Thanks

The question seemed to have more than one answer. I thought one had to have two instances for log-shipping? See below reference. Though a good choice of...

That's an interesting question on encryption. Easy one to miss the correct answers.

Reference (Read towards end of page): http://msdn.microsoft.com/en-us/library/bb934049.aspx

Thanks.

Great question and thanks covering the topic. Very common mistake when one is learning Loops.

Nice question and learnt more on SSIS Cache Transform. Thanks.

Interesting question on Policy Based Management new feature.

URL: http://sql-articles.com/articles/dba/policy-based-management-pbm/

Thanks.

Good question. Thanks.

Simple yet important concept on views where multiple tables are involved regardless of indexes, primary or foreign keys. Thanks for the question.

Nice question on the query plan. Thanks.

I learnt something new and thanks for the great question.

Great question that is easy and reviews the SQL Server Agent job topic.

That was an easy yet tricky. I revisited the Log Shipping topic to read more on it. Thanks.

Nice question. I figured out since they are been ran on two different databases that would still isolate them hence deriving to the correct answer.

Thanks.