Paul White (@SQL_Kiwi) continues his series on ACID and transaction isolation levels in SQL Server, giving us fair warning about some potential issues with the SNAPSHOT isolation level.
Continuing his series on knee-jerk reactions to wait statistics, Paul Randal (@PaulRandal) of SQLskills adds another chapter, this time focusing on PAGEIOLATCH_SH.
Paul White (@SQL_Kiwi) looks into a limitation of filtered indexes and demonstrates some dangers involving performance degradation and the risk of deadlocks.
SQLskills' Glenn Berry (@GlennAlanBerry) talks about the cost and performance aspects of the Azure virtual machines Microsoft is hoping you start adopting.
SQL Sentry's Aaron Bertrand (@AaronBertrand) shows how you can use Extended Events to track temp table creation and identify which session created which #temp table.
