Paul White (@SQL_Kiwi) rolls up his sleeves in his usual way, showing off the debugger several times while explaining the internals of SQL Server sorts.
With detailed information and his uncanny knack for explaining technical concepts very well, Paul White (@SQL_Kiwi) concludes his series on ACID, transactions, and isolation levels in SQL Server with a great read on READ UNCOMMITTED.
Tim Radney (@tradney) of SQLskills discusses addressing high severity errors in SQL Server – those with high severity (19-25) and the dreaded I/O error 825.
Paul White (@SQL_Kiwi) follows up on his thorough breakdown of indexed view maintenance with the details of a bug that can render an indexed view incorrect.
Aaron Bertrand (@AaronBertrand) follows up on a question from his triggers presentation at SQLBits, addressing the impact of trigger overhead for T-SQL Tuesday.
SQL Sentry's Aaron Bertrand (@AaronBertrand) shows DDL commands in Azure SQL Database that can now run as online operations instead of blocking, size-of-data operations.
Paul White (@SQL_Kiwi) explains various ways SQL Server makes runtime decisions about whether to use the b-tree structure or perform allocation order scans.
