Solutions Open source · Docs coming soon
SQL Server Tools and Solutions
Open-source frameworks and utilities that simplify and automate the hard parts of running SQL Server: backups and nightly restore-tests, auditing, diagnostics, and more. The code lives on GitHub today; documentation is moving here soon.
- Projects
- 7
- License
- Open source
- Docs
- Coming soon
Projects
The projects.
- admindb / S4 Simple SQL Server Scripts: robust backups, automated restore-testing, simpler disaster recovery, plus monitoring and maintenance utilities.Docs soon
- Dynamic Data Audits (DDA) Dynamic triggers that capture every INSERT, UPDATE, and DELETE as JSON in one table — with fast search and translation of audit data. Pure T-SQL.Docs soon
- psi (PowerShell SQL Interface) A lightweight alternative to Invoke-SqlCmd: real (injection-safe) parameters and smarter GO batch-splitting.Docs soon
- EventStore Extended Events capture for errors, blocking, deadlocks, and expensive queries — with counts, timelines, and heatmap reports. Part of S4.Docs soon
- TSMake A build tool for T-SQL projects: turns source files into single, versioned deployment scripts and documentation.Docs soon
- TSBatcher (Badger)Runs large data changes in small, throttled batches — so big UPDATEs and DELETEs don't block production.Docs soon
- Proviso Validate, provision, and document SQL Server hosts with PowerShell, one configuration "facet" at a time.Docs soon
Coming soon
Documentation is moving here.
Each project will get its own pages under /sql-server-tools. Until then, the readmes on GitHub are the place to start.
View the code on GitHub- An overview and documentation for every project
- Installation and quick-start guides
- Examples and recipes for common tasks
- Release notes and upgrade guidance
Consulting
Initial consultations are always free.
Bring your toughest SQL Server problem — performance, backups and restore-testing, auditing, encryption — and get an independent, experienced second set of eyes.