SQL Server: Consolidation Tactics and Best Practices

Consolidating SQL Server is a common strategy, primarily driven by the need to reduce licensing and hardware costs. This course, SQL Server: Consolidation Tactics and Best Practices, provides a comprehensive guide to successfully consolidating your SQL Server environment.

We begin with essential general considerations that must be addressed before any planning begins. Learn effective methods for identifying SQL Server consolidation candidates and recommendations for prioritizing which servers to consolidate first.

You'll then explore three primary SQL Server consolidation methods:

• Large Single Instance: Understand the benefits and risks of consolidating onto a single, powerful SQL Server instance.
• Multiple-Instance Server: Discover how to leverage multiple SQL Server instances for efficient consolidation.
• Virtualization: Learn how to utilize virtualization technologies for streamlined SQL Server consolidation.

For each method, we delve into the advantages, potential risks, and practical considerations, drawing on real-world experiences.

Finally, gain expertise in migrating databases and servers from one location to another. We cover a wide range of migration options to ensure a smooth transition.

By the end of this course, you'll possess the skills to plan and execute a SQL Server consolidation project or upgrade, significantly reducing your SQL Server licensing requirements. Master the tactics for optimizing your SQL Server infrastructure and achieving substantial cost savings.