Pour bénéficier d’une expérience Web optimale, utilisez Internet Explorer 11 ou version ultérieure, Chrome, Firefox, ou Safari.

Quest Database Training Days, September 2-30, 2021

Learn from Brent Ozar, Janis Griffin, Pinal Dave and Steph Locke and Boost your database management skills.

Our top tech experts are back again – and they want you to join them for five new, interactive sessions. Boost your SQL Server skills with free training from Microsoft Certified Master Brent Ozar, Oracle ACE Janis Griffin, Performance Tuning Expert Pinal Dave and Microsoft MVP Steph Locke.

You’ll see how to overcome your biggest tech challenges and have a lot of fun along the way.

Learn how to:

  • Run faster SQL Servers without changing queries or indexes
  • Solve performance problems after upgrading to SQL Server 2019
  • Read and fine-tune query plans for better performance
  • Increase your effectiveness as a database developer
  • Save time with SQL Server performance tuning for busy DBAs

Check the boxes to save spots for all the sessions that interest you.

Sélectionner vos événements


a la demande

Sept

2

Your users are complaining that SQL Server is slow, but you can't fix the code or the database, and the company isn't throwing hardware at the problem yet. What can you do? Use specific configuration changes to reduce the hardware required to run queries.We'll discuss blocking and other scenarios where SQL Server's configuration switches make all the difference. Code and indexes may still need work, but you'll have a few options to help in the meantime.

a la demande

Sept

9

SQL Server 2019 has been available for a while, but we’ve noticed many people don’t use it to its full potential. In this fast-paced, demo-oriented session, we’ll go over the new features that maximize SQL Server performance. We’ll also discuss what to do if you’ve recently upgraded SQL Server and your performance is missing the mark.

a la demande

Sept

16

The SQL Server Query Optimizer creates an execution plan for every statement running in the database. But sometimes it chooses a bad query plan, slowing the query and eating resources, so other processing can’t get done. Learn how to read and fine-tune query plans for better performance. We’ll go over the types of execution plans and when to use them. We’ll also examine the different operators, their statistics and costs; then determine steps to focus on tuning. As an added bonus, you’ll also learn several troubleshooting techniques. 

a la demande

Sept

23

See the tools and capabilities that’ll make you an even more effective database developer. We’ll cover database projects, unit testing and Continuous Integration and Continuous Deployment. You’ll learn about data collaboration tools from erwin® by Quest® and coding tools like Github Copilot (AI code writing). You’ll find at least one solution that’ll help you get more done with your time.

a la demande

Sept

30

Learn how to use native tools in SQL Server and scripts based on Dynamic Management Views (DMVs) to swiftly identify and resolve performance bottlenecks. In this session, you’ll discover effective methods for diagnosing performance issues and gain actionable insights that you can apply immediately to optimize your SQL Server environment.

Topics that will be discussed include:

  • Utilizing SQL Server native tools for performance monitoring
  • Leveraging Dynamic Management Views (DMVs) to pinpoint bottlenecks
  • Practical scripts to diagnose and resolve performance issues
  • Strategies for optimizing SQL Server performance

Speaker:

  • Pinal Dave, SQL Server Performance Tuning Expert at SQLAuthority.com

Sélectionnez un ou plusieurs webcasts auxquels vous souhaitez participer avant de vous inscrire.

Veuillez patienter...

triangle-down check
En téléchargeant, vous vous inscrivez pour recevoir des e-mails marketing de notre part. Pour vous désinscrire, veuillez suivre les instructions figurant dans notre politique de confidentialité.

Site protégé par reCAPTCHA. Consultez les conditions d’utilisation et la politique de confidentialité de Google.