Today I was honored to present my SQL Server 2016 “Hidden Gems” talk for the GroupBy online conference.
The slide deck and demos are attached to this post.
Following are some links to help you in further exploration of the various features I discussed:
Aaron Bertrand’s performance tests: https://sqlperformance.com/2016/03/sql-server-2016/string-split
Time Zone Support
AT TIME ZONE: https://msdn.microsoft.com/en-us/library/mt612795.aspx
Session Wait Stats
Live Query Statistics
Ability to attach to other sessions’ Live Queries! https://blogs.msdn.microsoft.com/sql_server_team/query-progress-anytime-anywhere/
Actual Query Plan Data Enhancements
Database Scoped Configuration
Increased Number of Index Keys
Increased Index Key Size
Too much stuff to list! Go google it.
File Attachment: machanic_sql_2016_hidden_gems.zip