This project is a T-SQL maintenance framework and suite of automated scripts for SQL Server. It functions as a backup automator, index optimizer, and integrity checker designed to manage routine database administration tasks through a programmable set of stored procedures.
The solution distinguishes itself through a focus on automated orchestration, including the ability to target or exclude databases within Availability Groups and the use of mirror-write backup streams for redundancy. It employs fragmentation-driven indexing to determine whether to rebuild or reorganize indexes based on user-defined thresholds and utilizes token-based file pathing for dynamic backup naming.
The framework covers broad capability areas including backup management with retention policy enforcement, data integrity monitoring through consistency checks, and performance optimization via statistics updates. It also provides maintenance auditing through centralized relational logging and supports backup encryption using server certificates.
The system is implemented using T-SQL-based procedural logic and a table-based configuration store to execute operations directly within the database engine.
