Home / sanna dating / Consolidating sql databases

Consolidating sql databases

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.

This is especially true in large organizations with SQL Server infrastructures, where IT staffs often find themselves running many underutilized SQL Server installations.

consolidating sql databases-89consolidating sql databases-22

You'll then learn about three consolidation methods: using a large single instance, using a multiple-instance server, and using virtualization.

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.


  1. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *