Knowledge · Open source

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.

Updated Nov 17, 2026 · approx. 1 min read

Area Open sourceIn depth dbatoolsShort profiles 4
Community projects, connectedOla HallengrenInstall-DbaMaintenanceSolutionFirst Responder KitInstall-DbaFirstResponderKitsp_WhoIsActiveInstall-DbaWhoIsActivedbatoolsPowerShelldbatools installs these three projects on request.

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.

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.

    License MIT · Documentation in English · in dbatools: Install-DbaMaintenanceSolution · Project and documentation ↗

  • 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.

    License MIT · Documentation in English · in dbatools: Install-DbaFirstResponderKit · Project and documentation ↗

  • 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.

    License GPL-3.0 · Documentation in English · in dbatools: Install-DbaWhoIsActive · Project and documentation ↗

  • 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.

    License MIT · Documentation in English · Project and documentation ↗

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