{"repo":"amtwo/dba-database","free":true,"listed":false,"github":"https://github.com/amtwo/dba-database","clone":"git clone https://github.com/amtwo/dba-database.git","description":"Database containing DBA helper code and open source software.","language":"TSQL","stars":152,"topics":["database","sql-server"],"license":"BSD-2-Clause","category":"databases-storage","readme_excerpt":"dba-database This is my DBA database that contains my utility scripts that I use to help manage my servers. Some of this code was never intended to be used by anyone else--it's primarily here for myself, but if you want to use it, make sure you know exactly what it's doing before using any of this code. Some of this code (including the installer!) assumes that the First Responder Kit (firstresponderkit.org) and Ola Hallengren's SQL Server Maintenance Solution (ola.hallengren.com) are installed in the same database as well. PowerShell script provided to pull that stuff from it's respective download location. Redistributing other people's code isn't my thing. Prerequisites SQL Server 2016 or later. A lot of the code uses CREATE OR ALTER , so older versions won't install cleanly. PowerShell with the SqlServer module (the installer leans on Invoke-Sqlcmd and Write-SqlTableData ). Permission to create a database on the target instance (or a database that already exists for you to install into). Supported SQL Server versions: My goal is to support all versions of SQL Server that are currently supported by Microsoft. (2017+ as of 2026) Many scripts work on versions as old as SQL Server 2005, as they were written when 2005 was still a supported version. New work is not tested on older, unsupported versions. To install By default, the installer will create a database named DBA (if it doesn't already exist), and install all objects in that DBA database. You can deploy to a database nam","default_branch":null,"files":null,"tree":[],"storefront":"/r/amtwo","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/amtwo/dba-database/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}