Explore all the products and find the right solution for your business
Proactively manage server performance on-prem or in the cloud with timely alerts and analytics
Fast configuration of regulatory and audit compliance settings with proactive monitoring, alerts, and reporting
Automated database security, monitoring and management for MS SQL, Azure and Amazon RDS for SQL Server
Backup and instant recovery for SQL Server, Azure Blob Storage and Amazon S3
Discover, track and manage database inventory across the entire environment
24 Essential tools to simplify daily server administration
Get the right solution to keep your database running at peak performance.
All of the support you need at your convenience.
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