Skip to content

SQL Server Consolidation Strategies

Photo of Mark Ginnebaugh
Hosted By
Mark G.
SQL Server Consolidation Strategies

Details

Speaker: Rick Heiges, SQL Server MVP

There are many approaches to SQL Server Consolidation. Each organization has unique business rules that impact the decision on which approach fits their needs. This session will cover the various approaches from Instance Stacking / Virtualization to Appliances and where they "fit". You'll hear about methods for data collection from Perfmon to Powershell and the Microsoft MAP Toolkit. Lastly, Rick will discuss strategies to uncover the business rules, as these will be the true limiting factors of how far a consolidation effort can go.

He'll also take a look at Microsoft's latest Fast Track architecture for a Private Cloud and how that may play into your strategy.

You'll learn:

The various features of SQL Server that enable consolidation Different approaches for consolidating SQL Server How to start building a framework for your organization How licensing may impact your framework How virtualization may fit into your consolidation strategy
Rick Heiges is a SQL Server MVP and a Solutions Architect with Scalability Experts (http://www.scalabilityexperts.com/). He works with customers on solutions within the SQL Server environment and speaks at user groups, conferences, labs, and road shows across the USA, Europe, and Africa. Rick holds an MBA and a M.S. in MIS and a B.S. in Computer Science. He has worked as a professor, developer, trainer, database administrator, and project manager/leader. Rick served on the PASS Board of Directors from 2003 – 2011 and started the 24 Hours of PASS virtual events.

Photo of Silicon Valley Microsoft Fabric Meetup group
Silicon Valley Microsoft Fabric Meetup
See more events