Practical Insights on SQL Server Consolidation and Migration Andreas Wolter

Title: Practical Insights on SQL Server Consolidation and Migration 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. Speaker: Andreas Wolter is a former Program Manager for Access Control in Azure SQL and SQL Server at Microsoft. In this role, he spearheaded the revamp of SQL Server’s permission system and the design of the external authorization system used by Purview policies and Azure database and data warehouse in Fabric. He has over 20 years of experience with SQL Server, is one of only 7 Microsoft Certified Solutions Master for Data Platform (MCSM), and has been a regular speaker at conferences worldwide for over a decade. Andreas is the founder of Sarpedon Quality Lab LLC, a consulting company specializing in SQL Server performance, high availability, and security, which he manages in cooperation with Sarpedon Quality Lab Germany.