SQLpassion Live Trainings
PostgreSQL for the SQL Server Professional - Live Training on April 2 - 3, 2025
Are you a SQL Server professional looking to expand your expertise and unlock the full potential of PostgreSQL? My live training is specifically designed to bridge the gap, diving deep into the critical differences between PostgreSQL and SQL Server.
Learn how to adapt your SQL Server knowledge to PostgreSQL seamlessly, optimize performance, and leverage PostgreSQL’s unique features to enhance your database management skills. Join me to gain the confidence and insights needed to efficiently work with PostgreSQL in any environment!
In 2 days you will learn about:
- PostgreSQL Architecture
- PostgreSQL vs. SQL Server
- Working with Query Plans
- Data Access Methods & Indexes
- Multi Version Concurrency Control
- Write Ahead Logging
- High Availability & Disaster Recovery
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!
