The year 2021 is bringing lots of learning opportunities and one of them is the Monthly Mentor series. I will be presenting along with Quest presentations on the monthly mentor series. The sessions which I have selected for this series are extremely relevant to the industry and also contain brand new freshly updated demonstrations. I strongly suggest everyone sign up for this series. Here is the link for the registration.
Discover Performance Tricks and Tips for SQL Server 2019
Date Time: January 26, 2021, 11 AM EST Register Now
Every release of SQL Server brings a load of new features you can add to your database management arsenal to increase efficiency. And in this session, Pinal Dave of SQL Authority will show you how to maximize the best functionality in SQL Server 2019. You’ll learn easy ways to optimize performance, accelerate database recovery, and much more. This SQL Server performance webcast will provide invaluable guidance to help any DBA or developer who wants to maximize SQL Server 2019 and its powerful features.
Fixing Troublemaking SQL Server Indexes, Fun Stories
Date Time: February 23, 2021, 11 AM EST Register Now
SQL Server indexes aren’t always as helpful as we’d like. Often, SQL Server indexes work against overall server performance. In this session, we’ll look at troublemaking scenarios and their workarounds. We’ll explore the dark side of indexes and their resolutions. Developers will receive scripts and knowledge they can immediately apply to their servers after the session.
Elementary! The Curious Case of the Deceptive Query Optimizer
Date Time: March 23, 2021, 11 AM EST Register Now
Join SQL sleuth Pinal Dave, as he examines two cases where the optimizer is the criminal that killed query performance. Together, we’ll carefully investigate the query optimizer and attempt to understand why it often behaves in a manner beyond common sense. Performance forensics isn’t for the faint of heart; join only if you have a keen desire to solve mysteries and learn advanced concepts of the query optimizer.
Reference: Pinal Dave (https://blog.sqlauthority.com)