Aaron Bertrand (@AaronBertrand) compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.
Aaron Bertrand (@AaronBertrand) shows the ins and outs of a new function that appeared in SQL Server 2016 CTP 2.1 this week: sys.dm_exec_function_stats.
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.
