Moreover, we delivered a comprehensive list of best practices for evident and accessible management of their environment.
This course will show how to effectively plan and implement a consolidation strategy, including methods of consolidating, and ways to migrate databases and instances.
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.
I'm a Principal consultant with SQLskills, as well as a Microsoft Data Platform MVP, and I've been involved with SQL Server consolidation projects since 2008.
It is worth mentioning, however, that consolidating too many databases onto a single instance can bring about performance degradation and resource contention.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.At some point in your consolidation project, you are going to have to touch the systems so I cover just about every option you have for getting databases and servers from one location to another.If you are planning a consolidation project or an upgrade of your SQL Server environment, and looking at ways to help reduce your SQL Server licensing requirements, this course can help.