README.md

SQL Scripts Repository

A collection of SQL Server scripts, tools, and utilities for database administration, performance monitoring, and development automation.

Getting Started

Prerequisites

• SQL Server 2017+ (most scripts compatible)
• SQL Server Management Studio or other SQL IDE
• Docker (for testing framework)
• sqlcmd utility (for automation scripts)

Documentation

Database Schema Migrations

• 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

Design Patterns and Advanced T-SQL Examples

• 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

• Performance Monitoring Scritps - queries for a variaty of performance related scenarios

Resource Recommendations

• 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
  • Adam Machanic
  • Bob Ward
  • Brent Ozar
  • Erik Darling
  • Erland Sommarskog
  • Grant Fritchey
  • Itzik Ben-Gan
  • Kendra Little
  • Kimberly Tripp
  • Ola Hallengren
  • Paul White
  • Pedro Lopes
  • Phil Factor

License

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