SQLpassion Live Trainings

SQL Server Query Tuning Strategies - Live Training on May 16, 2023

If you have a database driven application which reacts very slowly when the data increases, then you are right in this online training! You will learn how you can tune SQL Server Queries with concrete Index Tuning Strategies.

If you have a database driven application which reacts very slowly when the data increases, then you are right in this online training! You will learn how you can tune SQL Server Queries with concrete Index Tuning Strategies.

In 1 day you will learn about:

  • Index Tuning Strategies
  • Pro and Con’s around Lookup Operations
  • Troubleshooting Plan Cache Issues
  • Resolving Parameter Sniffing Problems

SQL Server Availability Groups - Live Training on June 15, 2023

High Availability with previous versions of SQL Server was always complex: you had Clustering, Database Mirroring, Log Shipping, and Replication. Beginning with SQL Server 2012 Microsoft changed everything and introduced a new High Availability technology called Availability Groups.

In 1 day you will learn about:

  • Working with Availability Groups
  • Performing Failovers
  • Working with Active Secondaries
  • Troubleshooting Problems

Design, Deploy, and Optimize SQL Server on VMware Workshop

Are you a SQL Server or VMware Administrator and you are running SQL Server on top of VMware vSphere? Do you want to learn how to get the best possible SQL Server performance out from your existing vSphere infrastructure, and how to run SQL Server in a highly available configuration on it?

In 3 days you will learn about:

  • How to configure and manage the 3 core vSphere & SQL Server resources (CPU, Memory, Storage)
  • Improving SQL Server performance by changing the right configuration options in VMware vSphere
  • How to run SQL Server in a highly available configuration on VMware vSphere
  • How to get the maximum out from your VMware vSphere infrastructure

Info: currently only available on request or as a corporate training!

SQL Server Query Tuning Workshop

Are you desperately searching for a way to enhance your SQL Server skills – especially when it comes to query tuning? When you look at execution plans, do you understand how to interpret and analyze them? Are your queries slow? And yet you don’t know how to fine tune them and improve them?

In 5 days you will learn about:

  • Strategies to solve all your day-to-day query tuning problems
  • Ways to make your database faster
  • How to get faster performance – as much as 1,000 TIMES better
  • How to measure and analyze index changes
  • How you can use my proven methods to solve your problems

Info: currently only available on request or as a corporate training!

SQL Server Performance Tuning Workshop

Are you desperately searching for a way to enhance your SQL Server skills – especially when it comes to performance tuning? Yesterday your SQL Server was running smoothly, but today’s performance is very bad? Your end users are complaining? And You have no idea what the problem is nor how to solve it?

In 5 days you will learn about:

  • Strategies how to find out the root cause of your performance problems
  • Real-world knowledge how SQL Server works internally
  • How to make SQL Server faster by just flipping configuration options
  • How to use my proven methods to solve your performance problems
  • Improving the performance without buying new hardware

Info: currently only available on request or as a corporate training!