Streamlining SQL Server management in larger environments.
Proposed session for SQLBits 2026TL; 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.
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
Speakers
Bart Vernaillen's other proposed sessions for 2026
Analyse workload-level index usage with PowerShell and Query Store - 2026