SQL Server open source
Many routine SQL Server tasks have free tools from the community: for diagnosis, maintenance, checks and automation. Here we present selected projects, each with what it helps with, where its limits are and which license it uses.
In depth: dbatools
dbatools is a free PowerShell module with more than 700 commands for SQL Server, started in 2015 in the SQL Server community and maintained there to this day. We tested version 2.9.1 in our lab against SQL Server 2017 to 2025 on Linux and Windows. The series shows how to start safely, what the check commands really tell you and how to prove that your backups restore.
- Hub
dbatools: managing SQL Server with PowerShell
What dbatools is, how to start safely and where a green result ends
- Part 1
Install and connect securely
Installation, signature and the certificate error since version 2, without switching off encryption
- Part 3
What Test-Dba really tells you
MAXDOP, memory and tempdb: which rule is behind it and what it cannot know
- Part 4
Prove your backups restore
Test-DbaLastBackup: restore, CHECKDB, and why -VerifyOnly is not enough
Short profiles
These entries are based on the projects’ own documentation. dbatools installs three of them on request.
- Maintenance
Ola Hallengren Maintenance Solution
Stored procedures for backups, integrity checks and index and statistics maintenance, configurable and with logging. A building block when you want to set up maintenance systematically and be able to trace it. Limit: The tool does not decide whether a rebuild makes sense or whether the backups meet your recovery objectives.
- Diagnosis
First Responder Kit
Scripts for health checks and performance investigations, including sp_Blitz, sp_BlitzCache and sp_BlitzIndex. They help you find conspicuous settings, queries and indexes. Limit: A finding is a reason to check, not an automatically correct change.
- Diagnosis
sp_WhoIsActive
Shows which requests are working or waiting right now, with blocking and resource usage. A quick first look during an acute incident. Limit: A snapshot does not replace history. If you need trends, you have to save the output regularly yourself.
- Diagnosis
DarlingData
Specialized scripts for performance questions: sp_QuickieStore opens up Query Store data, sp_PressureDetector looks for resource bottlenecks, sp_HumanEvents helps with Extended Events. Limit: The scripts differ in prerequisites and in what they capture; results need the context of workload and time.
Basis: the projects’ documentation, license files and repositories, reviewed on Nov 17, 2026. We did not test these projects in the lab for these entries.
How we select
- Value for SQL Server: Every entry says what the project helps with, who benefits from it and which limit you should know.
- Documented open source license: We name the license of the main code and link the license file. Public source code or free use alone is not enough for us.
- Our own texts, no ranking: We write the descriptions ourselves. There are no paid placements and no ordering by popularity or GitHub stars.
- Visible basis: Every entry says what it is based on. What we tested ourselves in the lab is stated explicitly, with version and date.
Further reading
- At PSG: Knowledge with all articles, SQL Server performance, Backup & restore.
- Projects: dbatools.io, Ola Hallengren, First Responder Kit, sp_WhoIsActive, DarlingData.