SQL Server: Consolidation Tactics and Best Practices
This course will show how to effectively plan and implement a consolidation strategy, including methods of consolidating, and ways to migrate databases and instances. This course is applicable to all versions of SQL Server.
There are many reasons for consolidating SQL Server but license and hardware cost reduction have always been primary drivers for organizations to consolidate. In this course, SQL Server: Consolidation Tactics and Best Practices, you'll start with general considerations for consolidation that should be thought about and completed before any planning, as well as ways that to identify consolidation candidates' recommendations for which type of servers to consider consolidating first. You'll then learn about three consolidation methods: using a large single instance, using a multiple-instance server, and using virtualization. The benefits of each consolidation method are explained as well as the risks associated with them, plus some considerations and practical experiences. Finally, you'll cover just about every option for migrating databases and servers from one location to another. By the end of this course, you'll have the skills required to plan and execute a consolidation project or an upgrade of your SQL Server environment, and you'll be well-versed in all the tactics that help reduce your SQL Server licensing requirements.
Course SyllabusIntroduction- 5m 49s
—Introduction to SQL Server Consolidation 1m 37s
—Benefits, Types, and Complications of Consolidation 2m 53s
—Course Structure 1m 19sGeneral Considerations- 20m 29s
—Introduction 1m 42s
—Having a Goal and Making a Plan 3m 34s
—Engaging the Right People and Knowing Your Environment 3m 54s
—Security and Hardware Considerations 3m 57s
—Storage and Maintenance Considerations 3m 17s
—High Availability 3m 15s
—Module Summary 0m 47sConsolidation Candidates- 35m 1sLarge Single Instance- 16m 45sMultiple Instances- 16m 26sVirtualization- 14m 14sMigration Strategies- 23m 31s