I show some interesting maintenance opportunities for Service Broker queues available in the next version of SQL Server.
Category: SQL Server 2016
I explain how SQL Server 2016 improves tempdb configuration and performance.
I investigate the observable overhead involved with using a new SQL Server 2016 security feature, Always Encrypted.
I show the ins and outs of a new function that appeared in SQL Server 2016 CTP 2.1 this week: sys.dm_exec_function_stats.
I walk through some of the new JSON-related Transact-SQL functionality that will be available in SQL Server 2016.