Paul White explains how and when lock escalation is triggered in SQL Server, clarifying misleading information you may have seen in official documentation and other sources.
Paul White (@SQL_Kiwi) follows up a great post on calculating medians with some information on how locking can affect query performance, often undetected.
SQL Sentry's Aaron Bertrand (@AaronBertrand) investigates a deadlock issue with alias types and table-valued parameters, and the Connect items that have sprung up about this issue.