A collection of SQL Server scripts, tools, and utilities for database administration, performance monitoring, and development automation.
- SQL Server 2017+ (most scripts compatible)
- SQL Server Management Studio or other SQL IDE
- Docker (for testing framework)
- sqlcmd utility (for automation scripts)
- Toggle Schemabinding Procedures - How to reduce the scope of database change scripts while getting the benefits of enabling SCHEMABINDING by using
DBA.hsp_ToggleSchemabinding - Toggle Schemabinding Testing - Comprehensive Docker testing framework for
DBA.hsp_ToggleSchemabinding - Development Helper Scripts - misc. template scripts and queries to script out objects from the database
- Date Intervals - Flattening/Merging, Differencing, and Intersecting of date intervals
- Calendar Scheduling - Advanced date scheduling utility functions
- Temporal Tables - temporal table examples, both custom and system-versioned
- Performance Monitoring Scritps - queries for a variaty of performance related scenarios
- Backups, Maintenance, Integrity Checks
- Simple. Use Ola Hallengren's SQL Server Maintenance Solution. It's a life changer if you are currently using the built-in Database Maintenance Plans.
- Industry experts
This project is licensed under the MIT License - see the LICENSE.md file for details.
Repository maintained by: Joel Searcy
Focus: SQL Database Administration, Performance Optimization, and Development Automation
Latest Update: September 2025