Formed in 2009, the Archive Team (not to be confused with the archive.org Archive-It Team) is a rogue archivist collective dedicated to saving copies of rapidly dying or deleted websites for the sake of history and digital heritage. The group is 100% composed of volunteers and interested parties, and has expanded into a large amount of related projects for saving online and digital history.
dbadisa
DISA STIG automation module for SQL Server
Install
Install-Module dbadisa -Scope CurrentUserExamples - Install-DbsAudit
# Detect version and create appropriate audit from DISA, output to DATA\Stig\, shutdown on failulre
Install-DbsAudit -SqlInstance sql2017, sql2016, sql2012
# Detect version and create appropriate audit from DISA, output to C:\temp, continue on failulre
Install-DbsAudit -SqlInstance sql2017 -Path C:\temp -OnFaiure ContinueExamples - Set-DbsAcl
# Set permissions for the default data, log and backups on sql2017, sql2016, sql2012 by adding
# appropriate permissions for the "AD\SQL Admins" group as well as the SQL Server service accounts.
Set-DbsAcl -SqlInstance sql2017, sql2016, sql2012 -Account "AD\SQL Admins"Examples - New-DbsDocTemplate
# Create a DISA documentation template for 2016
New-DbsDocTemplate -FilePath C:\temp\sql2016.mdExamples - Get-DbsStig
# Parse DISA XML and return checklsits for database and instance for SQL Server 2014 and 2016
Get-DbsStigMore Help
Get more help
Get-Help Install-DbsAudit -DetailedDependencies
- dbatools - For working with SQL
- PSFramework - For PowerShell goodness
- dbachecks - For checking your work
- Pester - Included in dbachecks
