DBAs and Developers often work across multiple versions of SQL Server, both on premises and deployed on VMs which may be in the cloud. It is difficult to know every single configuration setting introduced in each version of SQL Server. To keep the behavior of SQL Server predictable, many of the newer settings are kept off or disabled. Join us for this fast-paced demo-oriented session on Wednesday April 24 @ 11AM CT, as Pinal Dave shows three critical and several other important configuration settings, which once enabled instantly improve the performance of SQL Server. We will further explore these settings to understand how they work in the cloud and have a comprehensive understanding of the SQL Server's performance. By the end, you will understand how to enable a few important settings for SQL Server which can improve SQL Server performance by multifold.
Speaker: Pinal Dave is a Developer Evangelist and SQL Server performance expert. He has authored 11 SQL Server database books, 14 Pluralsight courses and over 2900 articles on the database technology on his blog at http://blog.sqlauthority.com. Along with 10+ years of hands-on experience, he holds a Masters of Science degree and a number of certifications, including MCTS, MCDBA and MCAD (.NET).