View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.
I've written a number of posts recently about the new T-SQL features. I thought it would be helpful for you to have a list with links to each one. You may also be interested in a Training on the T's webinar I did a couple of months ago where I demonstrated several of the features.