SQLpassion Live Trainings

Design, Deploy, and Optimize SQL Server on Microsoft Azure - Live Training on April 24 - 25, 2024

Unlock the power of Microsoft Azure and master the art of designing, deploying, and optimizing SQL Server with my cutting-edge online training course!

Learn expert strategies for crafting robust SQL Server architectures in the Azure environment. Explore best practices for scalability, security, and performance. Dive into the step-by-step process of deploying SQL Server seamlessly on Azure. Gain hands-on experience with real-world deployment scenarios. Uncover the secrets to fine-tuning SQL Server performance in the Azure cloud. Maximize efficiency and responsiveness with advanced optimization techniques.

In 2 days you will learn about:

  • Microsoft Azure Fundamentals
  • Running SQL Server on Azure VMs
  • Azure SQL Database
  • Azure SQL Managed Instance
  • SQL Hyperscale Tier
  • Performance Monitoring and Troubleshooting
  • High Availability Options & Migration Strategies

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!