For T-SQL Tuesday #67, Aaron Bertrand (@AaronBertrand) describes a new way to track backup and restore operations using Extended Events in SQL Server 2016.
Aaron Bertrand (@AaronBertrand) takes a quick look at a couple of things you should be careful about when calling natively-compiled Hekaton stored procedures in SQL Server 2014.
Erin Stellato (@erinstellato) of SQLskills demonstrates that, while incremental statistics can help with maintenance, they are ignored by the optimizer.
Paul White (@SQL_Kiwi) concludes his two-part series on SQL Server sort internals, including two new classes specific to In-Memory OLTP in SQL Server 2014.
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.
Paul Randal (@PaulRandal) of SQLskills provides some thorough and helpful tips on reducing or eliminating the impact of index fragmentation in SQL Server.
