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.
Course info
Rating
(18)
Level
Intermediate
Updated
July 20, 2016
Duration
2h 12m
Table of contents
Introduction
5m 49s
Virtualization
14m 14s
Description
Course info
Rating
(18)
Level
Intermediate
Updated
July 20, 2016
Duration
2h 12m
Description

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.

About the author
About the author

Tim is a Principal Consultant with SQLskills. He has worked with SQL server for the past 15 years, in a variety of roles including DBA, Lead DBA, and multi-department manager, which have given him extensive experience planning and implementing large-scale environment changes and upgrades.

More from the author
Transcript
Transcript

Hello, my name is Tim Radney, and welcome to my course SQL Server: Consolidation Tactics and Best Practices. 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. We will explore three consolidation methods: using a large single instance, using a multiple instance server, and using virtualization. I will explain the benefits of each consolidation method as well as the risks associated with them, and I'll also share some considerations and personal experiences I've had. This course starts with general considerations for consolidation where I cover things that you should be thinking about and doing before you even plan your consolidation strategy. I cover ways that you can identify consolidation candidates in your environment and make recommendations on which type of servers you should consider consolidating first. I wrap up the course going over various migration strategies. 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. Experience with SQL Server installation and virtualization concepts is expected. I hope you'll join me as we explore the benefits and risks of consolidating SQL Server with this course, SQL Server: Consolidation Tactics and Best Practices, here on Pluralsight.