Consolidating sql databases
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.
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.My first major consolidation effort was the result of SQL Server sprawl and an organization approaching an audit.Since then I have worked with numerous companies, helping with their consolidation and virtualization projects.There are many reasons for consolidating SQL Server.License and hardware reduction have always been primary drivers for organizations to consolidate.