Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant.
He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4100 articles on the database technology on his blog at a https://blog.sqlauthority.com.
Along with 16+ years of hands on experience he holds a Masters of Science degree and a number of database certifications.
PRECON: Ask the Expert (Monday)
During the lunch break, there will be a panel of experts available in our 'Ask the Expert' booth. Between 12:45 and 13:15 you can ask our experts (listed below) for their practical advice and/or tips & tricks.
Feeding them will influence the quality of feedback you'll receive..
- SSAS (Mainly Tabular)
- Power BI
- (Dimensional) Data Modelling
- SQL Server Performance Tuning Expert
- (Azure) Data Platform
- Power BI
Ásgeir Gunnarsson Koen Verbeeck Wesley Backelant Precon 200
Kick Start! SQL Server 2016 / 2017 Performance Tips and Tricks
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 2016 / 2017 has introduced many new features. In this 75 minute session we will be learning quite a few of the new features of SQL Server 2016 / 2017. 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
This 75 minutes will be the most productive time for any DBA and Developer, who wants to quickly jump start with SQL Server 2016 / 2017 and its new features.