Business Intelligence

SQT10 What's New in SQL Server 2019 for Analytics

11/19/2019

2:45pm - 4:00pm

Level: Intermediate

Thomas LeBlanc

Data Warehouse Architect

Data on the Geaux

SQL Server 2019 has many new features for everybody, but for analytics, this session gets more specific. To increase performance, the column store index has some enhanced Batch mode processing and re-indexing improvements. Analysis Services (SSAS) has been update for the long awaited Calculation Groups which is similar to Scoping in Multidimensional. DAX updates include Single Calculation (filter context) and Sideways recursion. Performance improvements with window aggregate functions for those not using SSAS. The Power BI Report Server has been improved along with more Mobile display options. The session will end with some of the updates for Polybase and data virtualization.

You will learn:

  • Improvements in SQL Server 2019 Column store indexes
  • Improvements in SQL Server 2019 Analysis Services
  • Improvements in SQL Server 2019 Hybrid features