History of mankind says we have learned a lot from our past mistakes and improved our future. Similarly, SQL Server Performance Tuning is not as complex a subject as many think it is and we can learn a lot from its earlier behavior. If we analyze the past behavior of SQL Server we can easily predict the future and keep it at optimal speed. In this 60 minute session, we will be learning quite a few of the new features of SQL Server 2016 / 2017 and also get a glimpse of the same incremental features in SQL Server 2019.
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).
Topics: Database Performance Products: SQL Diagnostic Manager for SQL Server