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.