Paul Randal (@PaulRandal) adds another chapter to his thorough series on knee-jerk wait statistics, focusing on the often-misunderstood PAGELATCH_XX waits.
Erin Stellato (@erinstellato) continues her popular series on proactively monitoring SQL Server, this time focusing on keeping your eye on wait statistics.
Glenn Berry (@GlennAlanBerry) provides some blueprints for how to decide whether newer processors are worth the investment to improve your OLTP workloads.
Paul White (@SQL_Kiwi) discusses some things to know about INSTEAD OF triggers – from execution plans and worktables to a cardinality estimation bug in SQL 2014.
Jonathan Kehayias (@SQLPoolBoy) of SQLskills uses practical examples to show multiple ways to monitor Availability Group replica synchronization in your environment.
Paul Randal (@PaulRandal) explains how to tell when CXPACKET waits are actually a problem (because, usually, they are just an indication of parallelism).
Aaron Bertrand (@AaronBertrand) follows up on his Always Encrypted posts from T-SQL Tuesday with improved code and more information on performance and space usage.
