SQLpassion Live Trainings
Design, Deploy, and Optimize SQL Server on Microsoft Azure - Live Training on November 27 - 28, 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
SQL Server Availability Groups - Live Training on December 4, 2024
Achieving 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.
During this Live Training you will learn how to install, configure, and manage fault-tolerant installations of SQL Server in combination with 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!
