Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2017 / 2019 has introduced many new features. In this 60 minute session we will be learning quite a few of the new features of SQL Server 2017 / 2019. Here is the glimpse of the features we will cover in this session.
• Adaptive Query Plans
• Batch Mode Adaptive Join
• New cardinality estimate for optimal performance
• Adaptive Query Processing
• Indexing Improvements
• Introduction to Automatic Tuning / Intelligent query processing
This 75 minutes will be the most productive time for any DBA and Developer, who wants to quickly jump start with SQL Server 2017 / 2019 and its new features.