Site map Every page, for humans
Site map
Every page on TotalSQL in one place: consulting, open-source solutions, and the full library of KB articles and tips. New articles show up here as they're published.
SQL Server Consulting 6
Working with me
- SQL Server ConsultingTalk through a SQL Server problem in a free initial consultation.
- ServicesBusiness continuity, HA + DR, performance tuning, remote DBA, AWS, Azure, and more.
- ExperienceDistinctions, writing, past clients, and testimonials.
- RatesHourly rates, and how billing works.
- AvailabilityCurrent availability, and a calendar for booking time.
- FAQsCommon questions about consultations and engagements.
SQL Server Tools and Solutions 8
Open-source frameworks
- SQL Server SolutionsLeverage open-source frameworks and solutions to make the most of SQL Server.
- 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
SQL Server Content and Guidance 10
The library
KB Articles 5
All KB articlesTips and Tricks 4
All tipsComing soon Articles Documentation Videos
TotalSQL 3
About the site
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.