SQLpassion Live Trainings
SQL Server Query Tuning Fundamentals - Live Training on April 4, 2023
If you have a database driven application which reacts very slowly when the data increases, then you are right in this live training! In this live training you will learn how you can tune SQL Server Queries with the information available inside an execution plan.
You will learn how SQL Server retrieves data from the database files, how SQL Server can join resultsets, and how you can react with indexes if you are in performance troubles.
In 1 day you will learn about:
- How SQL Server executes Queries
- How SQL Server performs data access
- How to understand Execution Plans
- Typical Execution Plan Operators
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!