Groupby Free Sql Server Training

SQL Server 2016 "Hidden Gems" with Adam Machanic

Informações:

Sinopsis

By far the most important SQL Server release since the heady days of 2005, SQL Server 2016 represents a huge leap forward in a number of key areas. You've no doubt heard plenty about such features as Query Store, JSON support, Polybase, and the other big-ticket items. But there are also a number of very cool features that don't usually make the top 10 lists. In this talk, you'll learn about enhancements to indexing (including both Columnstore and traditional b-tree indexes), DMVs, compression, string handling, encryption, configuration, and even time zone support. These smaller features may not be highlighted in the latest glossy ads from Microsoft's marketing department, but they're the kinds of things that add up to make your life easier. Attend this session to learn all sorts of new and different reasons to upgrade as quickly as possible.