Practical Insights on SQL Server Consolidation and Migration - Andreas Wolter

Optimizing system resource usage has emerged as a top consulting priority—driven by factors like mergers, uncontrolled system growth, and cloud transitions that often overlook necessary architectural adjustments.

In this session, Andreas Wolter, a former program manager at Microsoft Azure Data, will guide participants through the process of assessing an existing SQL server landscape and steps to consolidate and migrate numerous SQL server databases to reduce licensing and hardware requirements. Based on real-world projects this includes avoiding pitfalls and seizing opportunities when migrating databases to new versions. Consideration of availability, performance, and security is crucial for success in the cloud and on-prem.

This session primarily focuses on SQL Server IaaS and on-premises implementations, but most concerns and steps will also apply to PaaS and cross-cloud projects.