Kick Start! SQL Server 2019 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 2019 has introduced many new features. Here is a glimpse of the features we wil
Speaker: Pinal Dave SQLbits.com/sp...
Speaker Blog: blog.sqlauthor...
Speaker BIO: Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 30 Pluralsight courses and has written over 5000 articles at SQLauthority.com
SQLbits.com/Ses...
Tags: Optimising,Developing,Managing,On-prem,Cloud,performance,tuning,SQL 2019,DMV,sql server 2019,optimizing

[@PoleSlappa]

Thank you for this! Please keep them coming. I especially appreciate the explanation of SQL Compatibility Mode at kzbin.info/www/bejne/r5_Ln6Wdl7V5pc0!

[@penguinlover1986]

I don't understand why people use table aliases, it seems so lazy to me.

[@Ekaika_Non_Official]

Too much talk less demo, you can explain same thing in 10 minutes.

[@SQLBits]

Feel free to apply and give it a go yourself at our next SQLBits as a lightning session! We'd love to hear it!