Database Administrators and Developers often work across multiple versions of SQL Server. It is not possible to know every single configuration setting introduced in the latest version of SQL Server. To keep predictable SQL Server behavior, many of the newly introduced settings are kept off or disabled. In this fast-paced, demo-oriented session we will discuss the most important configuration settings that instantly give a performance boost to SQL Server once enabled.

Speaker: Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 33 Pluralsight courses and has written over 5100 articles on database technology on his blog at https://blog.sqlauthority.com. Along with 17+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.

Topics: Database Performance, Database Administration, Database Monitoring
Products: SQL Diagnostic Manager for SQL Server