22-25 April 2026

Streamlining SQL Server management in larger environments.

Proposed session for SQLBits 2026

TL; DR

Managing a few databases is easy; managing many is not. Standardisation and automation reduce operational risk, improve efficiency, and allow DBA teams to focus on high-value work. This session presents a structured, scalable approach.

Session Details

When you’re managing just a few SQL-Server instances or databases, a structured approach might be unnecessary. However, as the number of databases and SQL-Servers increases, complexity grows exponentially.

Without standardization and automation, managing a growing number of databases will lead to increased operational risks and necessitate a larger DBA-team than initially planned. Implementing standardized processes and automation not only mitigates these risks but also massively enhances efficiency, allowing the DBA-team to focus on high-value tasks that drive organizational success.

Over the years, I’ve developed a structured approach for administering SQL-Servers and databases in larger environments. This method, rooted in expertise with MSSQL and PowerShell, enables DBA-teams to focus on tasks that deliver the most value to the organization.

3 things you'll get out of this session

Understand why standardisation and automation are essential for managing SQL Server Learn a structured, repeatable approach to administerSQL Server environments See how automation enables DBA-teams to reduce risk and focus on high-value work