The IT industry is rapidly adopting SQL Server® 2016. Many applications previously running on SQL Server 2008/2012/2014 have now been upgraded to SQL Server 2016. This project is considered successful when all the features of the earlier versions work as they should in the upgrade. But a successful upgrade should also build upon the previous features to provide enhanced performance.
In our session, we will cover the following points:
- Columnstore indexes and performance tuning
- In-memory OLTP optimization of superior query performance
- New cardinality estimate for optimal performance
- Query store
This presentation will help any DBA quickly jumpstart SQL Server 2016 and its new features.